PHP连接数据库
<?php $servername = "localhost";$username = "root";$password = "0000012";$dbname = "myweb"; // 创建连接$conn = mysqli_connect($servername, $username, $password,$dbname); // 检测连接if (!$conn) { die("Connection failed: " . mysqli_connect_error());}echo "连接成功";$sql = "select * from user";$rst = mysqli_query($conn,$sql); ?><!doctype html><html><head><meta charset="UTF-8"><title>index</title><style>*{font-family: 微软雅黑;}</style><link rel="stylesheet" rel="external nofollow" rel="external nofollow" href="bs/css/bootstrap.min.css"><script src='bs/js/jquery.min.js'></script><script src='bs/js/bootstrap.min.js'></script></head><body><div class="container"><h2 class='page-header'>查看用户:</h2><table class='table table-bordered table-hover'><tr><th>编号</th><th>用户名</th><th>密码</th><th>删除</th></tr><?php while($row=mysqli_fetch_assoc($rst)){echo "<tr>";echo "<td>{$row['id']}</td>";echo "<td>{$row['usename']}</td>";echo "<td>{$row['password']}</td>";echo "</tr>";} ?></table></div></body></html>测试删除ID脚本
<?php $servername = "localhost";$username = "root";$password = "133nubia022";$dbname = "myweb"; // 创建连接$conn = mysqli_connect($servername, $username, $password,$dbname); $sql = "select * from user";$rst = mysqli_query($conn,$sql); ?><!doctype html><html><head><meta charset="UTF-8"><title>index</title><style>*{font-family: 微软雅黑;}</style><link rel="stylesheet" rel="external nofollow" rel="external nofollow" href="bs/css/bootstrap.min.css"><script src='bs/js/jquery.min.js'></script><script src='bs/js/bootstrap.min.js'></script></head><body><div class="container"><h2 class='page-header'>查看用户:</h2><table class='table table-bordered table-hover'><tr><th>编号</th><th>用户名</th><th>密码</th><th>删除</th></tr><?php while($row=mysqli_fetch_assoc($rst)){echo "<tr>";echo "<td>{$row['id']}</td>";echo "<td>{$row['usename']}</td>";echo "<td>{$row['password']}</td>";echo "<td><a href='javascript:' class='del' id='{$row['id']}'>删除</a></td>";echo "</tr>";} ?></table></div></body><script>$('.del').click(function(){ id=this.id; console.warn(id);});</script>**
**
**
**
**
**
**
**
**
**
**
**
**
**