数据的增删改

以多个人的信息进行添加、删除、修改为例

1.主页面

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>主页面</title>
</head>

<body>
<h1>主页面</h1>
<table border="1" cellpadding="0" cellspacing="0" width="700px">
<tr>
    <td>代号</td>
    <td>姓名</td>
    <td>性别</td>
    <td>民族</td>
    <td>生日</td>
    <td>操作</td>
</tr>
<?php
    $db=new MySQLi("localhost","root","","mydb");
	!mysqli_connect_error() or die("连接失败");
	$sql="select * from Info";
	$result=$db->query($sql);
	$attr=$result->fetch_all();
	foreach($attr as $v)
	{
		$sex=$v[2]?"男":"女";
		//处理民族名称
		$sqln="select name from nation where code='$v[3]'";
		$rnation=$db->query($sqln);
		$attrn=$rnation->fetch_assoc();
		
		echo "<tr>
		      <td>{$v[0]}</td>
			  <td>{$v[1]}</td>
			  <td>{$sex}</td>
			  <td>{$attrn['name']}</td>
			  <td>{$v[4]}</td>
			  <td>
			  <a href='delete.php?code={$v[0]}'>删除</a>
			  <a href='update.php?code={$v[0]}'>修改</a>
			  </td>
		      </tr>";
	}
?>
</table>
<div><a href="add.php" target="_blank">添加数据</a></div>


</body>
</html>

2.添加页面

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>添加页面</title>
</head>

<body>
<h1>添加表单</h1>
<form action="addchuli.php" method="post">
     <div>代号：<input type="text" name="code"/></div>
     <div>姓名：<input type="text" name="name"/></div>
     <div>性别：<input type="radio" value="男" name="sex"/>男
               <input type="radio" value="女" name="sex"/>女
     </div>
     <div>民族：
               <select name="nation">
               <?php
			     $db=new MySQLi("localhost","root","","mydb");
				 $sql="select * from nation";
				 $result=$db->query($sql);
				 $attr=$result->fetch_all();
				 foreach($attr as $v)
				 {
					 
					 echo "<option value='{$v[0]}'>{$v[1]}</option>";
				 }
               ?>
               </select>
     </div>
     <div>生日：<input type="text" name="birthday"/></div>
     <div><input type="submit" value="添加数据"/></div>
</form>
<div><a href="main.php" target="_blank">主页面</a></div>
</body>
</html>

　　添加页面的处理代码

<?php
$code=$_POST["code"];
$name=$_POST["name"];
$sex=$_POST["sex"];
$s=1;
if($sex=="女")
{
	$s=0;
}
$nation=$_POST["nation"];

$birthday=$_POST["birthday"];
 

$db=new MySQLi("localhost","root","","mydb");
$sql="insert into Info values ('{$code}','{$name}',{$s},'{$nation}','{$birthday}')";
$result=$db->query($sql);

if($result)
{
	header("location:add.php");	//跳转到add.php
}
else
{
	echo "添加失败！";
	}

3.修改页面

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>修改页面</title>
</head>

<body>
<h1>修改数据</h1>

<?php
$code=$_GET["code"];
$db=new MySQLi("localhost","root","","mydb");
$sinfo="select * from info where code='{$code}'";
$r=$db->query($sinfo);
$arr=$r->fetch_row();    //这个人所有信息

//var_dump($arr);

?>


<form action="updatechuli.php" method="post">
     <div><input type="hidden" name="code" value="<?php echo $arr[0] ?>"/></div>
     <div>姓名：<input type="text" name="name" value="<?php echo $arr[1] ?>"/></div>
     <div>性别：
               <input type="radio" value="男" name="sex" <?php echo $arr[2]?"checked='checked'":"" ?>/>男
               <input type="radio" value="女" name="sex" <?php echo $arr[2]?"":"checked='checked'" ?>/>女
     </div>
     <div>民族：
               <select name="nation">
               <?php
			     
				 $sql="select * from nation";
				 $result=$db->query($sql);
				 $attr=$result->fetch_all();
				 foreach($attr as $v)
				 {
					 if($v[0]==$arr[3])
					 {
					     echo "<option selected='selected' value='{$v[0]}'>{$v[1]}</option>";
					 }
					 else
					 {
						 echo "<option value='{$v[0]}'>{$v[1]}</option>";
					 }
				 }
               ?>
               </select>
     </div>
     <div>生日：<input type="text" name="birthday" value="<?php echo $arr[4] ?>"/></div>
     <div><input type="submit" value="修改数据"/></div>
</form>
<div><a href="main.php" target="_blank">主页面</a></div>
</body>
</html>

修改页面的处理代码

<?php
$code=$_POST["code"];
$name=$_POST["name"];
$sex=$_POST["sex"];
$s=1;
if($sex=="女")
{
	$s=0;
}
$nation=$_POST["nation"];

$birthday=$_POST["birthday"];

$db=new MySQLi("localhost","root","","mydb");
$sql="update info set name='{$name}',sex={$s},nation='{$nation}',birthday='{$birthday}' where code='{$code}'";
$r=$db->query($sql);

if($r)
{
	header("location:main.php");
}
else
{
	echo "修改失败！";
}

4.删除数据的代码

<?php

$code=$_GET["code"];

$db=new MySQLi("localhost","root","","mydb");
$sql="delete from info where code='{$code}'";
$r=$db->query($sql);
if($r)
{
	header("location:main.php");
}
else
{
	echo "删除失败！";
}