分页信息
$pagesize=10;
if (isset($_GET['page'])){
$page=intval($_GET['page']);
}else{
$page=1;
}
$sqlstr=mysql_query("select * from tolook ",$connstr);
$allrow=mysql_num_rows($sqlstr);
if ($allrow){
if ($allrow<$pagesize){$page_count=1;} //如果总记录数小于分页数就分页数=1因为能在一页显示下
if ($allrow % $pagesize) {
$page_count=(int)($allrow / $pagesize)+1;
}else{
$page_count=$allrow / $pagesize;
}
}else{
$pagesize=0; //如果记录为空 那就分页数为空
}
$page_string = '';
if( $page == 1 ){
$page_string .= '第一页|上一页|';
}
else{
$page_string .= '第一页|上一页|';
}
if( ($page == $page_count) || ($page_count == 0) ){
$page_string .= '下一页|尾页';
}
else{
$page_string .= '下一页|尾页';
}
if ($allrow){
$sqls=" select * from tolook where userid='ehxee' limit ". ($page-1)*$pagesize .", $pagesize";
$resut=mysql_query($sqls,$connstr);
while ($rrows=mysql_fetch_array($resut)){
$title=$rrows["titile"];
$lookordown=$rrows["lookordown"];
$looktime=$rrows["looktime"];
$userip=$rrows["userip"];
echo "";
echo " $title";
echo " $lookordown";
echo " $looktime";
echo " $userip";
echo "";
}
if ($title==""){
echo "对不起!您现在还没有任何消费记录";
}
}
?>