数据库增删改查

最新推荐文章于 2023-01-08 22:08:19 发布

林家芳草绿

最新推荐文章于 2023-01-08 22:08:19 发布

阅读量77

点赞数

本文链接：https://blog.csdn.net/ithaonaner/article/details/92797532

版权

连接文件

<?php
$con=mysqli_connect('localhost','root','root','pp');
if(!$con){
  die('数据库连连接失败');
}

?>

主页`

<!DOCTYPE HTML>
<html lang="en-US">
<head>
	<meta charset="UTF-8">
	<title>数据的增删改查</title>
	
</head>
<body>
<p><a href="add.php">添加</a></p>
    <table border="1">
	  <tr>
	  	<td>姓名</td>
	  	<td>性别</td>
	  	<td>年龄</td>
	  	<td>操作</td>
	  </tr>
	  
	  <?php 
	     require 'conn.php';
	     $sql="select * from menber";
		 $res=mysqli_query($con,$sql);
		
		
		while($row=mysqli_fetch_array($res)){
			 echo '<tr><td>' . $row["name"] .'</td><td>' .$row["gender"]. '</td><td>' .$row["age"].'</td><td>
			 <a href="delete.php?id='. $row["id"] .'">删除</a>
			 <a href="update.php?id='. $row["id"] .'">修改</a></td></tr>';
		 };
		 ?>
	  
	    
	</table>
</body>
</html>

修改

<?php
require 'conn.php';
$id=$_GET['id'];
$sql="select * from `menber` where `id`=$id limit 1";
$res=mysqli_query($con,$sql);

$row=mysqli_fetch_assoc($res);
if(!$row){
	die('找不到你要编辑的数据');
	}
?>
<form action=" edit.php" method="post" >

   
    <input type="hidden"  name="id" value="<?php echo $row['id']?>"/>
    <label>名字：</label><input type="text" name="name" value="<?php echo $row['name']?>"  required>

    <label>性别：</label>
	   <select name="gender"  required>
	       <option value="">请选择性别</option>
	       <option value="男" <?php echo $row['gender']=='男'?' selected':'' ?>>男</option>
	       <option value="女" <?php echo $row['gender']=='女'?' selected':'' ?>>女</option>
	   </select>
	
	<label>年龄：</label><input type="text" name="age" value="<?php echo $row['age']?>"  required>

    

    <input type="submit" value="保存">
	</form>里插入代码片

<?php
require 'conn.php';
$id=$_POST['id'];
$name=$_POST['name'];
$gender=$_POST['gender'];
$age=$_POST['age'];
$sql="update menber set `name`='$name', `age`='$age',`gender`='$gender' where id='$id'";
$res=mysqli_query($con,$sql);
header('Location:index.php');
?>

添加

<form action="adddo.php" method="post" >

   
   
    <label>名字：</label><input type="text" name="name" value="" required>

    <label>性别：</label>
	   <select name="gender"  required>
	       <option value="">请选择性别</option>
	       <option >男</option>
	       <option >女</option>
	   </select>
	
	<label>年龄：</label><input type="text" name="age" value="" required>

    

    <input type="submit" value="保存">
	</form>

<?php
$name=$_POST['name'];
$age=$_POST['age'];
$gender=$_POST['gender'];
require 'conn.php';
$sql="insert into menber (name,age,gender) values('$name','$age','$gender')";
$res=mysqli_query($con,$sql);
header('location:index.php');
?>

删除

<?php
$id=$_GET['id'];
require 'conn.php';
$sql="delete from menber where id='".$id."'";
$res=mysqli_query($con,$sql);
header('Location:index.php');
?>