php后台增删改跳转
php登录页面:
1 2 3 4 5 6 | <h1>登录界面</h1> <form action= "dengluchuli.php" method= "post" > 用户名:<input type= "text" name= "uid" /> 密码:<input type= "text" name= "pwd" /> <input type= "submit" value= "登录" /> </form> |
其中 dengluchuli.php在规定路径下。
登录跳转页面:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | <?php $yonghuming = $_POST [ "uid" ]; $mima = $_POST [ "pwd" ]; $db = new mysqli( "localhost" , "root" , "" , "12345" ); $sql = "select password from login where username='{$yonghuming}'" ; $result = $db ->query( $sql ); $atter = $result ->fetch_row(); if ( $atter [0]== $mima && ! empty ( $mima )) { header( "location:xinxi.php" ); } else { echo "用户名或密码错误" ; } ?> |
此页面用于登录界面登录成功后通过用户名找到相应的数据。
登录主界面:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 | <?php $de = new mysqli( "localhost" , "root" , "" , "12345" ); $e = "select * from info" ; $result = $de ->query( $e ); $atter = $result ->fetch_all(); echo "<table border=1>" ; echo "<tr> <td>代号</td> <td>姓名</td> <td>性别</td> <td>民族</td> <td>出生日期</td> <td>操作</td> </tr> "; for ( $i =0; $i < count ( $atter ); $i ++) { echo "<tr>" ; for ( $j =0; $j < count ( $atter [ $i ]); $j ++) { if ( $j ==4) { echo "<td>" . $atter [ $i ][ $j ]. "</td> <td><a href='shanchu.php?code={$atter[$i][1]}' onclick=\"return confirm('确定删除?')\"> 删除</a></td>" ; } else { echo "<td>" . $atter [ $i ][ $j ]. "</td>" ; } } echo "</tr>" ; } echo " </table>" ; echo "<a href='tianjia.php'>添加数据</a>" ?> |
添加数据(tianji.php):
1 2 3 4 5 6 7 8 9 | <h1>添加数据</h1> <form action= "zeng.php" method= "post" > 代号:<input type= "text" name= "daihao" /> <br /> 姓名:<input type= "text" name= "xinming" /><br /> 性别:<input type= "text" name= "xinbie" /><br /> 民族:<input type= "text" name= "minzu" /><br /> 生日:<input type= "text" name= "shengri" /><br /> <input type= "submit" value= "提交" /> </form> |
zeng.php :
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | <?php $code = $_POST [ "daihao" ]; $name = $_POST [ "xinming" ]; $sex = $_POST [ "xinbie" ]; $nation = $_POST [ "minzu" ]; $birthday = $_POST [ "shengri" ]; $db = new mysqli( "localhost" , "root" , "" , "12345" ); $sql = "insert into info values('{$code}','{$name}','{$sex}','{$nation}','{$birthday}')" ; $r = $db ->query( $sql ); if ( $r ) { header( "location:xinxi.php" ); } else { echo "添加失败" ; } ?> |
添加成功:
shanchu.php
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | <?php $name = $_GET [ "code" ]; $db = new mysqli( "localhost" , "root" , "" , "12345" ); $sql = "delete from info where name='{$name}'" ; $result = $db ->query( $sql ); if ( $result ) { header( "location:xinxi.php" ); } else { echo "删除失败" ; } ?> |
修改数据:
在xinxi.php文件中插入代码:
1 | <a href= 'xiugai.php?code={$atter[$i][1]}' >修改</a> |
相同路径下新建xiugai.php
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | <?php $name = $_GET [ "code" ]; $db = new mysqli( "localhost" , "root" , "" , "12345" ); $sql = "select * from info where name='{$name}'" ; $r = $db ->query( $sql ); $atter = $r ->fetch_row(); ?> <h1>修改</h1> <form action= "xiugaichuli.php" method= "post" > <input type= "hidden" name= "daihao" value= "<?php echo $atter[0]; ?>" /> <br /> 姓名: <input type= "text" name= "xinming" value= "<?php echo $atter[1]; ?>" /> <br /> 性别: <input type= "text" name= "xinbie" value= "<?php echo $atter[2]; ?>" /> <br /> 民族: <input type= "text" name= "minzu" value= "<?php echo $atter[3]; ?>" /> <br /> 生日: <input type= "text" name= "shengri" value= "<?php echo $atter[4]; ?>" /> <br /> <input type= "submit" value= "修改" /> </form> |
相同路径下新建xiugaichuli.php
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | <?php $code = $_POST [ "daihao" ]; $name = $_POST [ "xinming" ]; $sex = $_POST [ "xinbie" ]; $nation = $_POST [ "minzu" ]; $birthday = $_POST [ "shengri" ]; $db = new mysqli( "localhost" , "root" , "" , "12345" ); $sql = "update info set name='{$name}',sex={$sex},nation='{$nation}',birthday='{$birthday}' where code='{$code}'" ; $r = $db ->query( $sql ); if ( $r ) { header( "location:xinxi.php" ); } else { echo "修改失败" ; } ?> |
点击修改其中一条数据:
修改成功。
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步