php后台增删改跳转
2023-09-14 08:59:25 时间
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 "修改失败" ; } ?> |
点击修改其中一条数据:
相关文章
- PHP 变量类型的强制转换 & 创建空对象
- centos7系统下安装php-fpm并配置nginx支持并开启网站gzip压缩
- 【转】PHP网站(nginx、php-fpm、mysql) 用户权限解析
- Windows下图文详解PHP三种运行方式(php_mod、cgi、fastcgi)
- PHP引用(&)初探:函数的引用返回
- 【PHP面向对象(OOP)编程入门教程】21.多态的应用
- php进程导致服务器cpu 100问题追查过程
- PHP Socket编程 之 php实现http服务
- PHP字符串压缩
- [PHP 开源类库]simple-Excel — 兼具优雅与性能的Excel和CSV文件读写工具
- php面试题之PHP核心技术
- [获取行数]php读取大文件提供性能的方法,PHP的stream_get_line函数读取大文件获取文件的行数的方...
- PHP采集库-Snoopy.class.php
- php:用数组实现多语言(PHP 7.4.2)
- php类库PHP QR Code 二维码
- PHP执行批量mysql语句
- thinkphp6: 用phpspreadsheet导出数据到excel (php 8.1.1 / thinkphp v6.0.10LTS / phpspreadsheet 1.21.0 )
- LZW算法PHP实现方法 lzw_decompress php
- PHP获得数组的交集与差集
- [php-src] 窥探Php内核中的数组与面向对象
- [php-src]一个Php扩展的结构
- 彻底理解PHP的SESSION机制
- Atitit 调用另外语言的功能 目录 1. Waht 常见的语言java python js sql xml h5 c# php等之间的互相调用1 2. 为什么需要互相调用why1 3. 常
- Atitit。Js调用后台语言 java c# php swing android swt的方法大总结
- paip. 内存占用少的php ide选择评测总结
- paip.执行shell cmd 命令uapi java php python总结
- 【整理】Linux下中文检索引擎coreseek4安装,以及PHP使用sphinx的三种方式(sphinxapi,sphinx的php扩展,SphinxSe作为mysql存储引擎)
- 统计php程序运行时间及设置PHP最长运行时间