PHP MySQLi 增删改查
来源:互联网 发布:汽车外观设计软件 编辑:程序博客网 时间:2024/05/18 22:44
1:登陆页面
[php] view plain copy print?
- //前端显示部分
- <!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>
- <h2>管理员登陆</h2>
- <form action="dlyz.php" method="post">
- <div>用户名:<input type="text" name="user" value="请输入您的工号" /></div>
- <br />
- <div>密 码:<input type="password" name="psd" /></div>
- <br />
- <input type="submit" value="登录" />
- <input type="submit" value="注册新用户" formaction="zhuc.php"/>
- </form>
- </body>
- </html>
[php] view plain copy print?
- <?php
- $user = $_POST["user"];
- $psd = $_POST["psd"];
- //造对象
- $db = new MySQLi("localhost","root","","newssystem");
- //判断是否出错
- !mysqli_connect_error() or die("连接失败!!");
- //写sql语句
- $sql = "select psd from yonghu where user='{$user}'";
- //执行SQL语句
- $result = $db-> query($sql);
- $v = $result->fetch_row();
- if($psd==$v[0])
- {
- header("location:fabuxinwen.php");
- }
- else
- {
- echo"您输入的用户名或密码不正确,请重新输入!!";
- }
2:注册页面
[php] view plain copy print?
- <!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>
- <h2>欢迎注册</h2>
- <body>
- <form action="zhucyz.php"method="post">
- <div>用户名:<input type="text" name="user" value="请输入您的工号"/></div><br />
- <div>密 码:<input type="password" name="psd" /></div><br />
- <input type="submit" value="提交" />
- </form>
- </body>
- </html>
- <?php
- $user = $_POST["user"];
- $psd = $_POST["psd"];
- //造对象
- $db = new MySQLi("localhost","root","","newssystem");
- //判断是否出错
- !mysqli_connect_error() or die("连接失败!!");
- //写sql语句
- $sql = "insert into yonghu values('{$user}','{$psd}')";
- //执行SQL语句
- $result = $db-> query($sql);
- if($result)
- {
- header("location:dl.php");
- }
- else
- {
- echo"很抱歉,注册失败!!";
- }
3:登陆进去以后,是发布页面,可以发布和查看
[php] view plain copy print?
- <!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>
- <div style="width:100%; text-align:center" >
- <h2>发布新闻</h2>
- <form method="post">
- <input type="hidden" name="newsid"/>
- <table style="margin:0 auto; text-align:left" >
- <tr>
- <td >标题:</td><td><input type="text" style="width:400px" name="title" /></td>
- </tr>
- <tr>
- <td >作者:
- </td><td><input type="text" style="width:400px" name="Author" /></td>
- </tr>
- <tr>
- <td >来源:</td><td><input type="text" style="width:400px" name="source"/></td>
- </tr>
- <tr>
- <td >内容:</td>
- <td><textarea cols="auto" rows="auto" style="width:400px; height:400px" name="content"></textarea></td>
- </tr>
- </table><br />
- <?php
- $time = date('y-m-d h:i:s');
- echo "<input type=\"hidden\" name=\"time\" value=\"{$time}\"/>";
- ?>
- <input type="submit" value="提交" formaction="tijiao.php"/>
- <input type="submit" value="查看" formaction="chakan.php"/>
- </form>
- </div>
- </body>
- </html>
[php] view plain copy print?
- <?php
- $title = $_POST["title"];
- $Author = $_POST["Author"];
- $source = $_POST["source"];
- $content = $_POST["content"];
- //造对象
- $db = new MySQLi("localhost","root","","newssystem");
- //判断是否出错
- !mysqli_connect_error() or die("添加失败!!");
- //写sql语句
- $sql = "insert into news(title,Author,source,content) values('{$title}','{$Author}','{$source}','{$content}')";
- //执行SQL语句
- $result = $db-> query($sql);
- if($result)
- {
- header("location:fabuxinwen.php");
- }
- else
- {
- echo"很抱歉,添加失败!!";
- }
[php] view plain copy print?
- <!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>
- <table width="70%" border="1px" cellpadding="0" cellspacing="0" style="text-align:center">
- <tr>
- <td>编号</td>
- <td>标题</td>
- <td>作者</td>
- <td>来源</td>
- <td>日期</td>
- <td>删除</td>
- <td>修改</td>
- </tr>
- <?php
- $db=new mysqli("localhost","root","","newssystem");
- !mysqli_connect_error() or die("连接错误");
- $sql="select * from news";
- $result=$db->query($sql);
- while($attr=$result->fetch_row())
- {
- echo "
- <tr>
- <td>{$attr[0]}</td>
- <td>{$attr[1]}</td>
- <td>{$attr[2]}</td>
- <td>{$attr[3]}</td>
- <td>{$attr[5]}</td>
- <td><a onclick=\" return confirm('确定删除')\" href='scchuli.php?newsid={$attr[0]}'>删除</a></td>
- <td><a href='xiugai.php?newsid={$attr[0]}'>修改</a></td>
- </tr>
- ";
- }
- ?>
- </table>
- </body>
- </html>
[php] view plain copy print?
- <!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>
- <?php
- $id = $_GET["newsid"];
- $db=new mysqli("localhost","root","","newssystem");
- !mysqli_connect_error() or die("连接错误");
- $sql="select * from news where newsid='{$id}'";
- $result=$db->query($sql);
- $attr=$result->fetch_row();
- ?>
- <div style="width:100%; text-align:center" >
- <h2>修改新闻</h2>
- <form action="xgchuli.php" method="post">
- <input type="hidden" name="newsid" <?php echo "value='{$attr[0]}'";?>/>
- <table style="margin:0 auto; text-align:left" >
- <tr>
- <td >标题:</td><td><input type="text" style="width:400px" name="title" <?php echo "value='{$attr[1]}'";?>/></td>
- </tr>
- <tr>
- <td >作者:
- </td><td><input type="text" style="width:400px" name="Author" <?php echo "value='{$attr[2]}'";?>/>
- </td>
- </tr>
- <tr>
- <td >来源:</td><td><input type="text" style="width:400px" name="source" <?php echo "value='{$attr[3]}'";?>/>
- </td>
- </tr>
- <tr>
- <td >内容:</td>
- <td><textarea cols="auto" rows="auto" style="width:400px; height:400px" name="content"><?php echo "{$attr[4]}";?>
- </textarea></td>
- </tr>
- </table><br />
- <?php
- $time = date('y-m-d h:i:s');
- echo "<input type=\"hidden\" name=\"time\" value=\"{$time}\"/>";
- ?>
- <div><a href="chakan.php"><input type="button" title="查看" value="查看" /></a><input type="submit" title="修改" value="修改"/>
- </div>
- </form>
- </body>
- </html>
- <?php
- $id=$_POST["newsid"];
- $title=$_POST["title"];
- $Author=$_POST["Author"];
- $source=$_POST["source"];
- $content=$_POST["content"];
- $time=$_POST["time"];
- $db = new MySQLi("localhost","root","","newssystem");
- !mysqli_connect_error() or die("连接失败");
- $sql="update news set title='{$title}',Author='{$Author}',source='{$source}',content='{$content}',time='{$time}' where newsid='{$id}' ";
- $result=$db->query($sql);
- if ($result)
- {
- header("location:chakan.php");
- }
- else
- {
- echo "修改失败";
- }
//删除数据
[php] view plain copy print?
- <?php
- $id=$_GET["newsid"];
- $db=new mysqli("localhost","root","","newssystem");
- !mysqli_connect_error() or die("连接失败");
- $sql="delete from news where newsid='{$id}'";
- $result=$db->query($sql);
- if ($result)
- {
- header("location:chakan.php");
- }
- else
- {
- echo "删除失败";
- }
6:修改页面
[php] view plain copy print?
- <?php
- $title = $_POST["title"];
- $Author = $_POST["Author"];
- $source = $_POST["source"];
- $content = $_POST["content"];
- //造对象
- $db = new MySQLi("localhost","root","","newssystem");
- //判断是否出错
- !mysqli_connect_error() or die("添加失败!!");
- //写sql语句
- $sql = "insert into news(title,Author,source,content) values('{$title}','{$Author}','{$source}','{$content}')";
- //执行SQL语句
- $result = $db-> query($sql);
- if($result)
- {
- header("location:fabuxinwen.php");
- }
- else
- {
- echo"很抱歉,添加失败!!";
- }
0 0
- PHP MySQLi 增删改查
- PHP MySQLi 增删改查
- PHP mysqli 增删改查(一)
- 【PHP】使用MySQLi方式连接数据库,增删改查
- php封装msql 常用函数 增删改查 mysqli
- 07-mysqli的增删改查
- mysqli预处理实现增删改查
- PHP使用mysqli扩展库实现增删改查(面向对象版)
- PHP编程:增删改查
- php的增删改查
- php增删改查示例
- php简易增删改查
- PHP MySql增删改查
- php增删改查,demo
- PHP MySql增删改查
- mongodb php 增删改查
- PHP开发增删改查
- PHP增删改查代码
- LevelDB源码分析3-Slice.md
- 动态设置iframe的高度
- 任务牵引,我要的是什么?
- Java 枚举7常见种用法
- 100道动态规划——13 UVA 10163 Storage Keepers 有约束条件下的DP,递推,不能使用结构体作为基本单位
- PHP MySQLi 增删改查
- PC - 来电自动开机设置
- Spring定时任务-xml实现
- Redis和Memcache对比及选择
- Qtcreator连接本地Sqlite数据库(Qt5.5 + Sqlite3.15)
- 嵌入式设计与开发-基础入门
- SPOJ DIVCNT2
- Visual Stduio快捷键
- PHPExcel下载excel文件正常,打开报错:'break' not in the 'loop' or 'switch' context