1 数据库中的操作
create database empmanage;
create table emp(
id int primary key auto_increment,
name varchar(64) not null,
grade tinyint ,/*级别*/
email varchar(64) not null,
salary float
);
//插入数据(多插入几条)
insert into emp (name,grade,email,salary)values("yuan",1,"2361@qq.com",10000);
2
//此文件命名为yzy.php
<html>
<head><meta http-equiv="content-type";content="text/html;charset=utf-8"/>
<title>雇员信息列表</title>
</head>
<?php
//显示用户信息
//查询数据
$conn=mysql_connect("localhost"," "," ")or die(mysql_error());
mysql_query("set names utf8");
mysql_select_db("empmanage",$conn);
//分页显示
$pageSize=3;//每页显示的记录条数
$rowCount=0;//从数据库中可以获取总共的记录行数
$pageNow=2;//正在显示第几页
$pageCount=0;//共有多少页,计算得出
if(!empty($_GET['pageNow'])){
$pageNow=$_GET['pageNow'];
}
$sql="select count(id) from emp";//获取表总共记录数
$res1=mysql_query($sql,$conn);
if($row=mysql_fetch_row($res1))
{
$rowCount=$row[0];//取出了行数
}
//计算总共多少页
$pageCount=ceil($rowCount/$pageSize);//ceil函数向上取整
//每页显示的内容
//$sql="select * from emp where id=1";
//$sql="select * from emp limit".($pageNow-1)*$pageSize.",$pageSize";
$begain=($pageNow-1)*$pageSize;
$sql="select * from emp limit $begain,$pageSize";
$res2=mysql_query($sql,$conn);
echo "<table border='1' cellspacing='1px' width='700px'>";
echo "<tr><th>id</th><th>name</th><th>grade</th><th>email</th><th>salary</th></tr>";
while($row=mysql_fetch_assoc($res2)){/
echo"<tr><td>{$row['id']}</td><td>{$row['name']}</td><td>{$row['grade']}</td><td>{$row['email']}</td><td>{$row['salary']}</td></tr>";
}
echo "<h1>雇员信息列表</h1>";
echo "</table>";
//向上翻页
if($pageNow>1)
{
$pagePre=$pageNow-1;
echo "<a href='yzy.php?pageNow=$pagePre'>上一页</a> ";
}
//向下翻页
if($pageNow<$pageCount)
{
$pageNext=$pageNow+1;
echo "<a href='yzy.php?pageNow=$pageNext'>下一页</a> ";
}
echo "当前页数{$pageNow}共{$pageCount}页";//{}表明$pageNow和$pageCount是变量,和汉字混在一起,它以为后面的也是变量名
//页面跳转
?>
<form action="yzy.php">
跳转到<input type="text" name="pageNow"/>
<input type="submit" value="Go"/>
</form>
<?php
//关闭资源
mysql_free_result($res1);
mysql_free_result($res2);/
mysql_close($conn);
?>
</html>