（案例）用户登陆，数据分页，数据的增删改查
//登陆页面
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>用户登陆</title>
</head>
<body>
<!-- 用户登陆界面-->
<form action="denglyz.php" method="post">
<table border="1" rules="all" style="margin:150px auto">
<tr><td colspan="2" align="center" >用户登陆</td></tr>
<tr><td>用户名：</td><td><input type="text" name="username"></td></tr>
<tr><td>密 码：</td><td><input type="password" name="psw"></td></tr>
<tr align="center"><td colspan="2"><input type="submit" value="登陆"> <input type="reset"></td></tr>
</table>
</form>
</body>
</html>
//登陆验证页面
<?php
//包含并运行连接数据库文件
include ("lianjsjk.php");
//获取表单传过来的用户名和密码
$user=$_POST["username"];
$psw=$_POST["psw"];
//在表单里查找用户名和密码
$dljgj=mysql_query("select * from 007_admin where username='$user' AND password='$psw'");
//判断是否找到
if( $dl=mysql_fetch_assoc($dljgj)){
header("location:01.php");
}else{
echo "<script type='text/javascript'>";
echo "alert('登录失败');";
echo "location.href='denglu.php';";
echo "</script>";
}
?>
//登陆成功页面
<style type="text/css">
a:link {
color: blue;
text-decoration: none
}
a:visited {
color: blue
}
a:hover {
color: red
}
a:active {
color: blue
}
</style>
<?php
//包含连接数据库文件
include("lianjsjk.php");
//返回一个结果集
$jgj = mysql_query("select * from 007_news order by `id` ", $link);
//获得总数据个数
$zongsjgs = mysql_num_rows($jgj);
//分页显示数据数量
$fenysl = 10;
//分页总页数
$fenyzys = ceil($zongsjgs / $fenysl);
//判断地址栏当前页是否存在
if ($_GET['page']) {
$page = (int)$_GET['page'];
} else {
$page = 1;
header("location:01.php?page=1&id=");
}
//获得第n页的第一行数据是总数据的第几行数据
$a = ($page - 1) * 10;
//获得分页的结果集降序排列
$jgj = mysql_query("select * from 007_news ORDER BY id desc limit $a,$fenysl", $link);
//判断地址栏要删除的id是否存在
if ($_GET['id']) {
//存在则删除这个id的数据
mysql_query("delete from 007_news where id=" . $_GET['id'] . "");
//再次访问这个页面，起到了删除数据后刷新页面的作用
header("location:01.php");
}
//输出表格
echo "<div align='center'>";
echo "<table border='1' width='80%'>";
echo "<tr align='center' bgcolor='#efefef'>";
echo "<th>id</th><th>标题</th><th>作者</th><th>来源</th><th>点击量</th><th>发布时间</th><th>操作选项</th>";
echo "</tr>";
//循环输出分页结果集中的数据
while ($sj = mysql_fetch_assoc($jgj)) {
echo "<tr>";
echo "<td>" . $sj['id'] . "</td><td><a href='neirong.php?id=" . $sj['id'] . "&page=" . $page . "'>" . $sj['title'] . "</a></td><td>" . $sj['author'] . "</td>";
echo "<td>" . $sj['source'] . "</td><td>" . $sj['hits'] . "</td><td>" . date('Y-m-d H:i:s', $sj["addate"]) . "</td>";
echo "<td><a href='xiugai.php?id=" . $sj['id'] . "'>修改</a> <a href='javascript:void(0)' onclick='shanchu(" . $sj['id'] . ")'>删除</a> </td>";
echo "</tr>";
}
echo "<tr >";
echo "<td colspan='7' align='center'>";
echo "<div style='float: left; padding:3px 0'><button onclick='tianjsj()'>添加数据</button></div>";
//上一页超链接调用JS函数
echo "<a href='javascript:syy(" . $page . ")'>上一页</a>";
//循环输出总页数
for ($i = 1; $i <= $fenyzys; $i++) {
if ($i == $page) {
echo "<font size='5'>" . $i . "</font> ";;
} else {
echo "<font size='5'><a href='01.php?page=" . $i . "&id='>" . $i . "</a></font> ";
}
}
//下一页超链接调用JS函数
echo "<a href='javascript:xyy(" . $page . ")'>下一页</a>";
echo "</td>";
echo "</tr>";
echo "</table>";
echo "</div>";
?>
<!--点击删除连接调用的JS函数-->
<script type="text/javascript">
function shanchu(id) {
if (window.confirm("你确定要删除此数据？")) {
//点击确定时往地址栏传递点击的这个数据的id
location.href = "01.php?id=" + id;
}
}
//上一页调用的函数
function syy(syy) {
syy--;
location.href = '01.php?id=&page=' + syy;
}
//下一页调用的函数
function xyy(xyy) {
xyy++;
location.href = '01.php?id=&page=' + xyy;
}
function tianjsj() {
location.href = 'tianjsj.php';
}
</script>
//添加数据页面
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>添加数据</title>
</head>
<body>
<!--表单填写要加入的数据-->
<form action="jiarsj.php" method="post">
<table border="1" align="center" cellpadding="3">
<tr bgcolor="yellow" align="center">
<td colspan="3"><h2>添加一条数据</h2></td>
</tr>
<tr>
<td>标题:</td>
<td colspan="2"><input type="text" size="40" name="biaot"></td>
</tr>
<tr>
<td>作者:</td>
<td colspan="2"><input type="text" size="10" name="zuoz">来源:<input type="text" size="15" name="laiy">
发布时间:<input type="text" name="fabsj" value="<?php echo date("Y-m-d H:i;s") ?>"></td>
</tr>
<tr>
<td>内容:</td><td><textarea rows="10" cols="60" name="neir"></textarea></td>
<td><input type="submit" value="添加数据"></td>
</tr>
</table>
</form>
</body>
</html>
//确定添加数据页面
<?php
//包含连接数据库文件
include "lianjsjk.php";
//获得表单提交的数据
$biaot=$_POST["biaot"];
$zuoz=$_POST["zuoz"];
$laiy=$_POST["laiy"];
$fabsj=time();
$neir=$_POST["neir"];
//添加数据
$a=mysql_query("insert into 007_news (title,author,source,content,addate) values('$biaot','$zuoz','$laiy','$neir','$fabsj')");
header("location:01.php?page=1&id=");
?>
//连接数据库页面
<?php
//PHP设置返回的字符集
header("Content-type:text/html;charset=utf-8");
//连接服务器
$link = @mysql_connect("localhost", "root", "root");
if (!$link) {
echo "连接服务器失败" . mysql_error();
exit();
}
//选择数据库
$sjk = mysql_select_db("ceshi", $link);
if (!$sjk) {
echo "选择数据库失败" . mysql_error();
exit();
}
//设置MySql返回的字符集
mysql_query("set names utf8");
?>
//显示具体内容页面
<?php
//包含并运行连接数据库文件
include("lianjsjk.php");
//获取地址栏传来的id值
$id = $_GET['id'];
//返回这个id的结果集
$jgj = mysql_query("select * from 007_news where id=" . $id . "");
//返回这个id的数据的值
$nrsj = mysql_fetch_assoc($jgj);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>文章内容</title>
<!--JS程序-->
<script type="text/javascript">
//定义返回首页的函数
function sy(page) {
//调用首页这个文件并传进去原来的当前页面
location.href = '01.php?id=&page=' + page;
}
//定义上一篇文章的函数
function syp(id) {
id--;
location.href = 'neirong.php?id=' + id + '&page=1';
}
//定义下一篇的函数
function xyp(id) {
id++;
location.href = 'neirong.php?id=' + id + '&page=1';
}
</script>
</head>
<body>
<!--表单写入取得的这个id的值的各个字段的具体信息-->
<table cellpadding="5" align="center" width="80%">
<tr>
<td>
<div style="float: left">
<button onclick="syp(<?php echo $_GET['id'] ?>)"><
<上一篇
</button>
</div>
<div align="center">
<button onclick="sy(<?php echo $_GET['page'] ?>)">首页</button>
</div>
<div style="float: right">
<button onclick="xyp(<?php echo $_GET['id'] ?>)">下一篇>></button>
</div>
</td>
</tr>
<tr>
<td align="center"><h2><?php echo $nrsj['title'] ?></h2></td>
</tr>
<tr>
<td align="center" bgcolor="#f0f0f0">
作者:<?php echo $nrsj['author'] ?>
来源:<?php echo $nrsj['source'] ?>
<?php
//点击量加一并更新
$nrsj['hits']++;
mysql_query("update 007_news set hits=" . $nrsj['hits'] . " where id=" . $nrsj['id'] . "");
?>
点击量:<font color="red"><?php echo $nrsj['hits'] ?></font>
发布时间:<?php echo date("Y-m-d H:i:s", $nrsj['addate']) ?>
</td>
</tr>
<tr>
<td><?php echo ($nrsj['content']) ? $nrsj['content'] : "内容为空"; ?></td>
</tr>
</table>
</body>
</html>
//确定修改页面
<?php
include "lianjsjk.php";
$biaot=$_POST["biaot"];
$zuoz=$_POST["zuoz"];
$laiy=$_POST["laiy"];
$fabsj=strtotime($_POST["fabsj"]);
$neir=$_POST["neir"];
$id=$_GET["id"];
mysql_query("update 007_news set title='$biaot',author='$zuoz',source='$laiy',addate='$fabsj',content='$neir' where id=$id");
header("location:01.php?page=&id=");
?>
//修改页面
<?php
include "lianjsjk.php";
$id =$_GET['id'];
$xgjgj = mysql_query("select * from 007_news where `id`=$id",$link);
$xgsj = mysql_fetch_assoc($xgjgj);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>修改数据</title>
</head>
<body>
<!--表单填写要加入的数据-->
<form action="quedxg.php?id=<?php echo $xgsj['id'] ?>" method="post">
<table border="1" align="center" cellpadding="3">
<tr bgcolor="yellow" align="center">
<td colspan="3"><h2>修改数据</h2></td>
</tr>
<tr>
<td>标题:</td>
<td colspan="2"><input type="text" size="40" name="biaot" value="<?php echo $xgsj['title'] ?>"></td>
</tr>
<tr>
<td>作者:</td>
<td colspan="2"><input type="text" size="10" name="zuoz" value="<?php echo $xgsj['author'] ?>">
来源:<input type="text" size="15" name="laiy" value="<?php echo $xgsj['source'] ?>">
发布时间:<input type="text" name="fabsj" value="<?php echo date("Y-m-d H:i:s",$xgsj['addate']) ?>"></td>
</tr>
<tr>
<td>内容:</td>
<td><textarea rows="10" cols="60" name="neir"><?php echo $xgsj['content'] ?></textarea></td>
<td><input type="submit" value="确定修改"></td>
</tr>
</table>
</form>
</body>
</html>
浙公网安备 33010602011771号