PHP、MYSQLI实现简单的增、删、改、查功能(初学者)
发布时间:2020-07-29 18:21:23
来源:51CTO
阅读:65441
作者:无忧you
index.php#连接数据库
$conn = mysqli_connect("localhost","root","");
#判断是否连接成功
if(!$conn){
echo "失败";
}
//选择数据库
mysqli_select_db($conn,"bbs");
//准备sql语句
$sql = "select * from bbs_user";
//发送sql语句
$obj = mysqli_query($conn,$sql);
echo "
echo "
echo "
编号姓名密码地址性别年龄操作";while($row = mysqli_fetch_assoc($obj)){
echo "
";echo '
'.$row['id'].'';echo '
'.$row['username'].'';echo '
'.$row['password'].'';echo '
'.$row['address'].'';echo '
'.$row['sex'].'';echo '
'.$row['age'].'';echo '
删除/ 修改';echo "
";}
echo "
";echo "添加";
echo "
//关闭连接
mysqli_close($conn);
?>
点击删除:
del.php$id =$_GET['id'];
$link = mysqli_c