PHP 留言簿（带Oracle数据库分页的显示功能）_PHP实例

ora_parse($cursor, $query) or die;

ora_exec($cursor);

$i=0;

while(ora_fetch($cursor)) {

$guestbook[$i][0] = ora_getcolumn($cursor,0);

$guestbook[$i][1] = ora_getcolumn($cursor,1);

$guestbook[$i][2] = ora_getcolumn($cursor,2);

$guestbook[$i][3] = ora_getcolumn($cursor,3);

$gu

estbook[$i][4] = ora_getcolumn($cursor,4);

$guestbook[$i][5] = ora_getcolumn($cursor,5);

$guestbook[$i][6] = ora_getcolumn($cursor,6);

$guestbook[$i][7] = ora_getcolumn($cursor,7);

$i++;

}

ora_close($cursor);

ora_logoff($handle);

echo "<a href=addmsg.php>新增留言....</a><p>\n";

if ($QUERY_STRING!="")

$page = $QUERY_STRING;

} else

$page = 0;

}

$i=count($guestbook);

$msgnum=20; // 每页二十笔

$start = $page * $msgnum;

$end = $start + $msgnum;

if ($end > $i) $end=$i;

$totalpage=$i/$msgnum;

$pagestr="";

if ($page>0) $pagestr=$pagestr."<a

href=index.php?".($page-1).">&lt;上页</a> - ";

$pagestr=$pagestr."[第 ";

for ($i=0; $i<$totalpage; $i++)

if ($i!=$page)

$pagestr = $pagestr."<a href=index.php?$i>".($i+1)."</a> ";

} else

$pagestr = $pagestr.($i+1)." ";