PHP MySQLi 增删改查
1：登陆页面
//前端显示部分 <!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对提交登陆信息的处理
<?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：注册页面
<!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：登陆进去以后，是发布页面，可以发布和查看
<!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
$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"很抱歉，添加失败！！";
}4：查看页面
<!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>5：在查看页面可以进行修改和删除<!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
$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
$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"很抱歉，添加失败！！";
}
声明：该文观点仅代表作者本人，牛骨文系教育信息发布平台，牛骨文仅提供信息存储空间服务。
- 上一篇： 在JSP中如何使用JSTL（EL表达式）格式化日期
- 下一篇： js获取文档高度
