无JS,完全php面向过程数据分页实现代码_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 ""; 
$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 ""; 
} 
echo "
id
 
name
 
age
 
sex
 
birthday
 
编辑雇员
 
删除雇员
 
{$row['id']}
 
{$row['name']}
 
{$row['age']}
 
{$row['sex']}
 
{$row['birthday']}
 
编辑
 
删除
"; 
//表单控制显示页数 
echo ""; 
echo ""; 
?>