php 面向过程分页,无JS,完全php面向过程,数据分页

//登陆页面设置的session,当session中存在name时

//session_start();

//$name = $_SESSION['name'];

//if (empty($name)){

//header("Location: error.php");

//exit();

//}

//面向过程, 数据分页显示

if(false!=($mysql = mysql_connect('本地mysql', 'mysql用户名', 'mysql密码'))){

mysql_query('set names utf8',$mysql);    //设置数据库中的编码

mysql_select_db("数据库database",$mysql);

}else{

die("连接失败");

}

$pageSize = 10;//页面显示条数

$rowCount = 0;//数据总条数,从数据库获得

$sqlCount = 'select count(id) from employee';

$res1 = mysql_query($sqlCount,$mysql);

//取出数据条数

if(false!=($row=mysql_fetch_row($res1))){

$rowCount = $row[0];

}

//总页数,通过计算得到

$pageCount = 0;

$pageCount = ceil($rowCount/$pageSize);

//获取当前页

if(!isset($_GET['pageNow'])){// 当 get/post都为空的时候赋默认值1

$pageNow = 1;//当前页数

}elseif(false!=is_numeric($_GET['pageNow']) && $_GET['pageNow']<=$pageCount){

$pageNow = $_GET['pageNow'];

}else{

header("Location: ../Error/error.php");

exit();

}

//打印分页数据

echo "

";

echo "

echo "

id name age sex birthday 编辑雇员 删除雇员 ";

$sqList = "select id,name,age,sex,birthday from employee limit ".($pageNow-1)*$pageSize.",".$pageSize;

$res2 = mysql_query($sqList,$mysql);

while (false!=($row=mysql_fetch_assoc($res2))){

echo "

{$row['id']} {$row['name']} {$row['age']} {$row['sex']} {$row['birthday']}  编辑  删除";

}

echo "

";

//表单控制显示页数

echo "

";

//上一页按钮

if($pageNow>1){

$pageUp = $pageNow-1;

echo "上一页 ";

}

//下一页按钮

if($pageNow

$pageDown = $pageNow+1;

echo "下一页 
";

}

//后退十页按钮

if($pageNow-10>0){

echo "<<< ";

}

//向本页传递当前显示的页数,并显示第几页按钮

for($i=1;$i<=$pageCount;$i++){

if($i>$pageNow-2 && $i

if($i!=$pageNow){

echo "第".$i."页 ";

}

}

}

//前进十页

if($pageNow+10<=$pageCount){

echo ">>> ";

}

//显示当前页与总页数

echo "
当前页".$pageNow."页/共".$pageCount."页";

//跳转页

echo "跳转到:页";

echo "

";

echo "

";

?>