我知道 mysql 怎么搞,就是不知道用 SQL Server 怎么办。我已经有一个分页的 sql server 的存储过程了,我想在 PHP 里调用,不知道怎么做
讲起来比较复杂,我用的是 ms sql server,所以要建立“游标”在进行分业,如果使用mysql,原理差不多,只不过更方便,直接用“limit”语句就行了。
告诉你最关键的地方!其他地方你都知道了! ".$page*$Maxperpage." $Maxperpage=每页显示记录数 $page=当前的页 $sql="select top ".$page*$Maxperpage." TrueName from table_name order by uoaccount desc"; $result=mssql_query($sql,$conn);这个下面还要加个条件 if($page>1) mssql_data_seek($result,($page-1)*$Maxperpage);下面的简单了
$strSQL = "select count(*) from guestbook"; $query = odbc_do($conn, $strSQL); $mess_count = odbc_result($query, 1); $page_size = 10; $page_count = ceil($mess_count / $page_size); echo "第 "; for ($i=1; $i<=$page_count; $i++ ) { echo " <a href=\"?page=$i\">$i</a> "; } echo " 页"; if ($page == 0) { $page = 1; } $start_id = $page_size * ($page - 1); $end_id = $page_size * $page; if ($end_id > $mess_count) { $end_id = $mess_count; } $strSQL = "select username, email, homepage, message, convert(nchar(19), writetime, 120) view_write_time from (select top " . ($end_id - $start_id) . " * from (select top " . $end_id . " * from guestbook order by id asc) as a order by id desc) as b order by id desc"; $query = odbc_do($conn, $strSQL);
以前用ASP+SQLSERVER的时候就是用此方法。当然还要用到其他的语句。循环肯定是有的。
http://chinesehis.com/starry/index.php
$sql = "select * from table limit $offset,10";
".$page*$Maxperpage." $Maxperpage=每页显示记录数
$page=当前的页
$sql="select top ".$page*$Maxperpage." TrueName from table_name order by uoaccount desc";
$result=mssql_query($sql,$conn);这个下面还要加个条件
if($page>1) mssql_data_seek($result,($page-1)*$Maxperpage);下面的简单了
$query = odbc_do($conn, $strSQL);
$mess_count = odbc_result($query, 1);
$page_size = 10;
$page_count = ceil($mess_count / $page_size);
echo "第 ";
for ($i=1; $i<=$page_count; $i++ )
{
echo " <a href=\"?page=$i\">$i</a> ";
}
echo " 页";
if ($page == 0)
{
$page = 1;
}
$start_id = $page_size * ($page - 1);
$end_id = $page_size * $page;
if ($end_id > $mess_count)
{
$end_id = $mess_count;
}
$strSQL = "select username, email, homepage, message, convert(nchar(19), writetime, 120) view_write_time from (select top " . ($end_id - $start_id) . " * from (select top " . $end_id . " * from guestbook order by id asc) as a order by id desc) as b order by id desc";
$query = odbc_do($conn, $strSQL);