无为清净楼资源网 Design By www.qnjia.com
main页面(主页面)
<table width="100%" border="1" cellpadding="0" cellspacing="0"> <tr> <td>代号</td> <td>姓名</td> <td>性别</td> <td>民族</td> <td>生日</td> <td>操作</td> </tr> <"localhost","root","","mydb"); if(mysqli_connect_error()){ die("连接失败"); } $sql = "select * from Info"; $result = $db->query($sql); $attr = $result->fetch_all(); foreach($attr as $v) { $sex = $v[2]"select Name from Nation where Code ='$v[3]'"; $result = $db ->query($sql); $attr = $result->fetch_assoc(); echo "<tr> <td>{$v[0]}</td> <td>{$v[1]}</td> <td>{$sex}</td> <td>{$attr['Name']}</td> <td>{$v[4]}</td> <td> <a href='Delete.php"; } "Add.php" rel="external nofollow" >添加数据</a> </div>
Add(添加数据页面)
<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"> <"localhost","root","","mydb"); if(mysqli_connect_error()){ die("连接失败"); } $sql = "select * from Nation"; $r = $db->query($sql); $att = $r->fetch_all(); foreach($att as $v) { echo "<option value='{$v[0]}'>{$v[1]}</option>"; } "text" name="birthday" /></div> <div><input type="submit" value="添加数据" /></div> </form>
AddChuLi页面(添加数据处理页面)
<"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"); if(mysqli_connect_error()){ die("连接失败"); } $sql = "insert into Info values('{$code}','{$name}','{$s}','{$nation}','{$birthday}')"; //添加数据语句 $result = $db->query($sql); if($result) { header("location:main.php"); //php跳转页面方式 } else { echo "添加失败!"; }
DeleteChuLi页面(删除数据处理页面)
<"code"]; $db = new MySQLi("localhost","root","","mydb"); if(mysqli_connect_error()){ die("连接失败"); } $sql = "delete from Info where Code ='{$code}'"; //删除语句 $r = $db->query($sql); if($r) { header("location:main.php"); } else { echo "删除失败!"; }
Update页面(修改数据页面)
<h1>修改数据</h1> <"code"]; $db = new MySQLi("localhost","root","","mydb"); if(mysqli_connect_error()){ die("连接失败"); } $sql1 = "select * from Info where Code='{$code}'"; $r1 = $db->query($sql1); $att1 = $r1->fetch_row(); "UpdateChuLi.php" method="post"> <div>代号:<input type="hidden" name="code" value="<" /></div> <div>姓名:<input type="text" name="name" value="<" /></div> <div>性别: <input type="radio" value="男" name="sex" <"checked='checked'" : ""; "radio" value="女" name="sex" <"" : "checked='checked'"; "nation"> <"localhost","root","","mydb"); if(mysqli_connect_error()){ die("连接失败"); } $sql = "select * from Nation"; //查询nation一组数据 $r = $db->query($sql); $att = $r->fetch_all(); foreach($att as $v) { if($att1[3]==$v[0]) { echo "<option value='{$v[0]}' selected='selectec' >{$v[1]}</option>"; } else { echo "<option value='{$v[0]}'>{$v[1]}</option>"; } } "text" name="birthday" value="<"/></div> <div><input type="submit" value="修改数据" /></div> </form>
ateChuLi页面(修改数据处理页面)
<"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"); if(mysqli_connect_error()){ die("连接失败"); } $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 "修改失败!"; }
以上这篇使用PHP连接数据库_实现用户数据的增删改查的整体操作示例就是小编分享给大家的全部内容了,希望能给大家一个参考,也希望大家多多支持。
标签:
用户的增删改查
无为清净楼资源网 Design By www.qnjia.com
广告合作:本站广告合作请联系QQ:858582 申请时备注:广告合作(否则不回)
免责声明:本站文章均来自网站采集或用户投稿,网站不提供任何软件下载或自行开发的软件! 如有用户或公司发现本站内容信息存在侵权行为,请邮件告知! 858582#qq.com
免责声明:本站文章均来自网站采集或用户投稿,网站不提供任何软件下载或自行开发的软件! 如有用户或公司发现本站内容信息存在侵权行为,请邮件告知! 858582#qq.com
无为清净楼资源网 Design By www.qnjia.com
暂无评论...
更新日志
2024年09月25日
2024年09月25日
- 纯音入心系列纯音乐《天籁古筝》1CD[MP3][331MB]
- 男女对唱典藏天碟《发烧对唱·那个季节里的歌DSD》10CD[WAV]
- 群星2010-歌林精选辑[歌林][WAV+CUE]
- TrioZimbalist-PianoTriosofWeinberg,Auerbach,Dvorak(2024)[24-44,1]wav
- 群星.1992-滚石第一流台湾歌·12王牌大车拼【滚石】【WAV+CUE】
- 林子祥.1984-创作歌集【华纳】【WAV+CUE】
- 周汤豪.2010-周汤豪【华纳】【FLAC分轨】
- Mozart-TheStringQuintets-AmadeusQuartet,CecilAronowitz(2017)[24-44,1][WAV+CUE]
- JamesWilliamsDennisIrwin-Focus(2024,Red)[24-48]FLAC
- 藤泽麻衣《空みあげて》[WAV]
- 纯音入心系列纯音乐《中国古筝经典名曲》1CD[MP3][1.3GB]
- 纯音入心系列纯音乐《古筝新奏:岁月静好与筝语,细水流年与筝同》1CD[MP3][846.9MB]
- 670《脆弱敏感小女生》[320K/MP3][27.53MB]
- 曾琳.2011-好好爱我【南方】【WAV+CUE】
- 范晓萱.1995-RAIN【福茂】【WAV+CUE】