数据删除跟重新添加

　　php删除处理页面：

<?php
$code = $_GET["c"];

//造连接对象
$db = new MySQLi("localhost","root","123","mydb");

$sql = "delete from info where code='{$code}'";

$r = $db->query($sql);

if($r)
{
header("location:main.php");
}
else
{
echo "删除失败";
}

　　　　添加页面：

<!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>

<form action="addchuli.php" method="post">
<div>代号：<input type="text" name="code" /></div>
<div>姓名：<input type="text" name="name" /></div>
<div>性别：
<input type="radio" name="sex" value="1" checked="checked" />男
 
<input type="radio" name="sex" value="0" />女
</div>
<div>民族：
<select name="nation">
<?php
//造连接对象
$db = new MySQLi("localhost","root","123","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>

</body>
</html>

　　　　添加的处理页面：

<?php
$code = $_POST["code"];
$name = $_POST["name"];
$sex = $_POST["sex"];
$nation = $_POST["nation"];
$birthday = $_POST["birthday"];

//造连接对象
$db = new MySQLi("localhost","root","123","mydb");

$sql = "insert into info values('{$code}','{$name}',{$sex},'{$nation}','{$birthday}')";

$db->query($sql);

header("location:main.php");

相关阅读:
左孩子右兄弟的字典树
UVA 1401 Remember the Word
HDOJ 4770 Lights Against Dudely
UvaLA 3938 "Ray, Pass me the dishes!"
UVA
Codeforces 215A A.Sereja and Coat Rack
Codeforces 215B B.Sereja and Suffixes
HDU 4788 Hard Disk Drive
HDU 2095 find your present (2)
图的连通性问题—学习笔记

原文地址：https://www.cnblogs.com/chenshanhe/p/6839280.html