#连接数据库
$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_connect('localhost','root','');
if(!$link){
exit('连接失败');
}
mysqli_select_db($link,'bbs');
$sql = "delete from bbs_user where id =$id";
$result = mysqli_query($link,$sql);
if($result && mysqli_affected_rows($link)){
echo "删除成功返回";
}else{
echo "删除失败";
}
mysqli_close($link);
?>
更改数据:<?php
$id = $_GET['id'];
$link = mysqli_connect('localhost','root','');
if(!$link){
exit('连接失败');
}
mysqli_select_db($link,'bbs');
$sql = "select * from bbs_user where id =$id";
$obj = mysqli_query($link,$sql);
$row = mysqli_fetch_assoc($obj);
?>
" />
编号: | <?php echo $row['id'];?> |
用户名: | " /> |
密码: | <?php echo $row['password'];?> |
地址: | " /> |
性别: | " /> |
年龄: | " /> |
执行更改:<?php
$id = $_GET['id'];
$username = $_GET['username'];
#$password = $_GET['password'];
$address = $_GET['address'];
$sex = $_GET['sex'];
$age = $_GET['age'];
$link = mysqli_connect('localhost','root','');
if(!$link){
exit('连接失败');
}
mysqli_select_db($link,'bbs');
$sql = "update bbs_user set username = '$username', address = '$address', sex = '$sex', age = '$age' where id =$id";
$obj = mysqli_query($link,$sql);
if($obj && mysqli_affected_rows($link)){
echo "修改成功返回";
}else{
echo "修改失败";
}
mysqli_close($link);
?>
添加数据:
编号:
姓名:
密码:
地址:
性别:男
女
年龄:
执行添加数据:
//获取添加的数据信息
$id = $_GET['id'];
$username = $_GET['username'];
$password = md5($_GET['password']);//加密
$address = $_GET['address'];
$sex = $_GET['sex'];
$age = $_GET['age'];
//连接数据库
$link = mysqli_connect('localhost' , 'root' , '');
//判断是否连接成功
if(!$link){
exit('连接数据库失败'.mysqli_connect_error());
}
//选择数据库
mysqli_select_db($link , 'bbs');
//准备sql语句
$sql = "insert into bbs_user(id,username,password,address,sex,age) values('$id','$username','$password','$address','$sex','$age')";
//发送sql语句
$obj = mysqli_query($link , $sql);
if($obj){
echo "添加成功返回";
}else{
echo "添加失败";
}
mysqli_close($link);
?>
PHP、MYSQLI实现简单的增、删、改、查功能(初学者)
标签:php mysqli
本条技术文章来源于互联网,如果无意侵犯您的权益请点击此处反馈版权投诉
本文系统来源:http://blog.51cto.com/13534640/2088247