<?php
include("conn.php");$pagesize=5;
$url=$_SERVER["REQUEST_URI"];
$url=parse_url($url);
$url=$url[path];
$numq=mysql_query("SELECT * FROM `test`");
$num = mysql_num_rows($numq);if($_GET[page]){
$pageval=$_GET[page];
$page=($pageval-1)*$pagesize;
$page.=',';}if($num > $pagesize){
if($pageval<=1)$pageval=1;
echo "共 $num 条".
" <a href=$url?page=".($pageval-1).">上一页</a> <a href=$url?page=".($pageval+1).">下一页</a>";
}
$SQL="SELECT * FROM `test` limit $page $pagesize ";echo $page;
$query=mysql_query($SQL);
while($row=mysql_fetch_array($query)){ echo "<hr><b>".$row[name]." | ".$row[sex]; }
?>上面代码中第一个标出的代码目的是啥呀? 就是为了加一个逗号吗?为什么把逗号直接加到第二个后面翻页的时候就提示错误呢
include("conn.php");$pagesize=5;
$url=$_SERVER["REQUEST_URI"];
$url=parse_url($url);
$url=$url[path];
$numq=mysql_query("SELECT * FROM `test`");
$num = mysql_num_rows($numq);if($_GET[page]){
$pageval=$_GET[page];
$page=($pageval-1)*$pagesize;
$page.=',';}if($num > $pagesize){
if($pageval<=1)$pageval=1;
echo "共 $num 条".
" <a href=$url?page=".($pageval-1).">上一页</a> <a href=$url?page=".($pageval+1).">下一页</a>";
}
$SQL="SELECT * FROM `test` limit $page $pagesize ";echo $page;
$query=mysql_query($SQL);
while($row=mysql_fetch_array($query)){ echo "<hr><b>".$row[name]." | ".$row[sex]; }
?>上面代码中第一个标出的代码目的是啥呀? 就是为了加一个逗号吗?为什么把逗号直接加到第二个后面翻页的时候就提示错误呢
$SQL="SELECT * FROM `test` limit $page $pagesize ";
$page.=','; ==> 等于由start变成了 start,
$page=($pageval-1)*$pagesize;
$SQL="SELECT * FROM `test` limit $page, $pagesize ";
这种写法吗?可以的。