PHP mysqli 实现简单的增删改查

最新推荐文章于 2024-07-07 10:05:16 发布

懒得起名字的小白

最新推荐文章于 2024-07-07 10:05:16 发布

阅读量6.2k

点赞数 6

分类专栏： PHP 增删改查初学 mysqli CURD

本文链接：https://blog.csdn.net/qq_40341527/article/details/79186286

版权

初学同时被 3 个专栏收录

4 篇文章 0 订阅

订阅专栏

增删改查

2 篇文章 0 订阅

订阅专栏

CURD

2 篇文章 0 订阅

订阅专栏

首先需要下载jquery.js 文件

数据表 tb_mysqli

数据库名为：mysqli_curd

DROP TABLE IF EXISTS `tb_mysqli`;
CREATE TABLE `tb_mysqli` (
  `uid` int(100) NOT NULL AUTO_INCREMENT,
  `uname` varchar(100) DEFAULT NULL,
  `pswd` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`uid`)
)

创建首页：login_reg.php

<html>  
<head>  
<meta charset="gb2312"> 
<title>登录和注册</title>  
</head> 
<script type="text/javascript" src="js/jquery.js"></script> 
<body> 
<form name="form1" method="post" action="" id="form1">
用户名：<input type="text" id="uname" name="uname" ><br>
密码：<input type="text" id="pswd" name="pswd" ><br>
<input type="button" id="denglu" value="登录" οnclick="is_submit(1)"/>
<input type="button" id="zhuce" value="注册" οnclick="is_submit(2)" />
</form>
<script>
    function is_submit(value) {
        var form1 = $("#form1");
        if (value == 1) {          
            form1.action = "login.php";
             $("#form1").attr("action",form1.action);
            form1.submit();
        }
        if (value == 2) {
            form1.action = "reg.php";
            $("#form1").attr("action", form1.action);
            form1.submit();


        }
    }

</script>
</body>  
</html>

创建登录：login.php

<?php 
header("content-type:text/html;charset=gb2312"); 
echo "登录<br>";
$uname=$_POST["uname"];
$pswd=$_POST["pswd"];
echo $uname." ".$pswd;
//造对象
$db = new MySQLi("localhost","root","","mysqli_curd");
//判断是否出错
!mysqli_connect_error() or die("连接失败！！");   
//SQL语句
$sql = "select pswd from tb_mysqli where uname='$uname'";
// 执行SQL语句
$result = $db-> query($sql);
$v = $result->fetch_row();  
//  mysql_fetch_row() 函数从结果集中取得一行作为数字数组
if($pswd==$v[0])  
{  
header("location:yes.php");  
}  
else  
{  
echo"您输入的用户名或密码不正确，请重新输入！！";  
}  
?>

注册：reg.php

<?php
header("content-type:text/html;charset=gb2312"); 
echo "注册<br>";
$uname=$_POST["uname"];
$pswd=$_POST["pswd"];
echo $uname." ".$pswd;
//造对象
$db = new MySQLi("localhost","root","","mysqli_curd");
//判断是否出错
!mysqli_connect_error() or die("连接失败！！");
// 判断用户名是否已经存在
$sql_exist="select * from tb_mysqli where uname='$uname'"; 
// 执行SQL语句
$count = $db-> query($sql_exist);
$v = $count->fetch_row();  
if($v>=1)
{
echo "用户名已经存在";
}else {
$sql = "insert into tb_mysqli (uname,pswd) values ('$uname','$pswd');";
    // 执行SQL语句
    $result = $db-> query($sql);
    if($result)  
    {  
    header("location:yes.php");  
    }  
    else  
    {  
    echo"很抱歉，注册失败！！";  
    }  

}

?>

添加一个yes.php

<?php

echo "成功<br>";

?>
<a href="showall.php">显示全部信息</a>

显示全部：showall.php

<html>
<head>
<title>全部信息</title>
</head>
<body>
<table border="1">
<tr>
<td>ID</td>
<td>用户名</td>
<td>密码</td>
<td>删除</td>
<td>修改</td>
</tr>
<?php 
//造对象
$db = new MySQLi("localhost","root","","mysqli_curd");
//判断是否出错
!mysqli_connect_error() or die("连接失败！！"); 
//SQL语句
$sql = "select * from tb_mysqli";
// 执行
$result = $db-> query($sql);
while($attr=$result->fetch_row())
{
echo 
"
<tr>
<td>{$attr[0]}</td>
<td>{$attr[1]}</td>
<td>{$attr[2]}</td>";
?>
<td><a href="delete.php?uid=<?php echo "{$attr[0]}" ?>" οnclick="return window.confirm('确认删除？')">删除</a></td>
    <td><a href="getone.php?uid=<?php echo "{$attr[0]}" ?>" οnclick="return window.confirm('确认修改？')">修改</a></td>
</tr>
<?php 
} 
    ?>
</table>
</body>
</html>

删除：delete.php

<?php
header("content-type:text/html;charset=gb2312"); 
$uid=$_GET['uid'];
echo "$uid<br>";
//造对象
$db = new MySQLi("localhost","root","","mysqli_curd");
//判断是否出错
!mysqli_connect_error() or die("连接失败！！"); 
//SQL语句
$sql = "delete from tb_mysqli where uid='$uid'";
// 执行
$result = $db-> query($sql);
if($result)
{
echo 
"
<script>
       alert('删除成功');
       window.location.href='showall.php';
    </script>

";
}else 
{
echo 
"
<script>
       alert('删除失败');
       window.location.href='showall.php';
    </script>
";
}
?>

修改：getone.php

<!DOCTYPE HTML> 
<html>
<head>
</head>
<body> 
<?php 
header("content-type:text/html;charset=gb2312");
$uid=$_GET['uid'];
//造对象
$db = new MySQLi("localhost","root","","mysqli_curd");
//判断是否出错
!mysqli_connect_error() or die("连接失败！！"); 
//SQL语句
$sql = "select * from tb_mysqli where uid='$uid'";
// 执行
$result = $db-> query($sql);
while($attr=$result->fetch_row())
{
$uname=$attr[1];
$pswd=$attr[2];
}
?>
<form method="post" action="update.php"> 
<input type="hidden" name="uid" value="<?php echo $uid ?>"/>
  用户名：<input type="text" name="uname" value="<?php echo $uname ?>">
   <br><br>
  密码：<input type="text" name="pswd" value="<?php echo $pswd ?>">
<br><br>
   <input type="submit" name="submit" value="修改"> 
</form>

</body>
</html>

执行修改：update.php

<?php
header("content-type:text/html;charset=gb2312"); 
$uid=$_POST['uid'];
$uname=$_POST['uname'];
$pswd=$_POST['pswd'];
//造对象
$db = new MySQLi("localhost","root","","mysqli_curd");
//判断是否出错
!mysqli_connect_error() or die("连接失败！！"); 
//SQL语句
$sql = "update tb_mysqli set uname='$uname',pswd='$pswd' where uid='$uid'";
// 执行
$result = $db-> query($sql);
if($result)
{
echo 
"
<script>
       alert('修改成功');
       window.location.href='showall.php';
    </script>

";
}else 
{
echo 
"
<script>
       alert('修改失败');
       window.location.href='showall.php';
    </script>
";
}
?>

懒得起名字的小白

关注

6
点赞
踩
16

收藏

觉得还不错? 一键收藏
2
评论
PHP mysqli 实现简单的增删改查

首先需要下载jquery.js 文件数据表 tb_mysqli数据库名为：mysqli_curdDROP TABLE IF EXISTS `tb_mysqli`;CREATE TABLE `tb_mysqli` ( `uid` int(100) NOT NULL AUTO_INCREMENT, `uname` varchar(100) DEFAULT NULL,
复制链接

扫一扫

专栏目录