数据删除跟重新添加
2024-09-21 03:30:15 215人阅读
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="http://www.mamicode.com/1" checked="checked" />男 <input type="radio" name="sex" value="http://www.mamicode.com/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=http://www.mamicode.com/‘{$v[0]}‘>{$v[1]}"; } ?> </select> </div> <div>生日:<input type="text" name="birthday" /></div> <div><input type="submit" value="http://www.mamicode.com/添加" /></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");
|
数据删除跟重新添加
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉:
投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。