一个PHP+MSSQL分页的例子

2020-03-22 16:30:15

字体：大中小

来源：转载

供稿：网友

?
require config.php
dl( extensions/php_mssql70.dll
if (!isset($page)) { $page=1; }
if ($page =0) { $page=1; }
$db=mssql_connect($local,$user,$pass);
mssql_select_db($name,$db);
$query=mssql_query( select count(*) as date from news ,$db);
$query=mssql_fetch_array($query);
$pages=ceil($query[0]/$userperpage);
if ($page $pages) { $page=$pages;}
if ($query[0] $userperpage) { $userperpage=$query[0]; }
$dangqian=($page-1)*$userperpage;
echo title News /title
echo style type=text/css /n
echo !--/n
echo A{text-decoration:none}/n
echo A:hover {color:blue;; text-decoration: underline}/n
echo td { font-size: 9pt}/n
echo -- /style /n
echo div align=center center /n
echo table border=0 width=100% cellspacing=0 cellpadding=0 height=19/n
echo tr
echo td width=52% colspan=5 img src=xw.gif width=100% /td /tr /n
echo tr
echo td width=52% height=19 valign=bottom bgcolor=#B5C6B0 p align=center font/n
echo color=#408080 新闻标题 /font /td /n
echo td width=14% height=19 valign=bottom align=center bgcolor=#B5C6B0 font/n
echo color=#408080 发表日期 /font /td /n
echo td width=19% height=19 valign=bottom align=center bgcolor=#B5C6B0 font/n
echo color=#408080 发表部门 /font /td /n
echo td width=7% height=19 valign=bottom align=center bgcolor=#B5C6B0 font/n
echo color=#408080 阅读 /font /td /n
echo td width=8% height=19 valign=bottom align=center bgcolor=#B5C6B0 font/n
echo color=#408080 图像 /font /td /n
echo /tr /n
echo /table /n
echo /center /div /n
echo div align=center center /n
echo table border=0 width=100% cellspacing=0 cellpadding=0 height=19 /n
$db=mssql_connect($local,$user,$pass);
mssql_select_db($name,$db);
$query=mssql_query( select * from news order by date desc ,$db);
$roro=mssql_num_rows($query);
if ($roro==0) {
echo br br p align=/ center/ font color=/ #FF0000/ size=/ 2/ marquee behavior=/ alternate/ border=/ 0/ width=/ 300/ height=/ 16/ scrolldelay=/ 70/ 目前数据库中无任何记录！ /marquee /font /p
exit;
}
mssql_data_seek($query,$dangqian);
$i=0;
while ($arr=mssql_fetch_array($query)) {
if ($i =$userperpage) { break;}
echo tr /n
echo td width=52% bgcolor=#F3F3F3 height=19 valign=bottom p align=left a href=/ readnews.php?id=$arr[date]/ target=/ _blank/ font color=#3D5449 $arr[title] /font /a /td /n
$datee=date( Y-m-d ,$arr[date]);
echo td width=14% bgcolor=#F3F3F3 height=19 valign=bottom align=center font color=#3D5449 $datee /font /td /n
echo td width=19% bgcolor=#F3F3F3 height=19 valign=bottom align=center font color=#3D5449 $arr[type] /font /td /n
echo td width=7% bgcolor=#F3F3F3 height=19 valign=bottom align=center font color=#808080 $arr[click] /font /td /n
echo td width=8% bgcolor=#F3F3F3 height=19 valign=bottom align=center /n
$arr[photo]=trim($arr[photo]);
if (($arr[photo] ) || (file_exists($arr[photo]))) {
echo img src=picture.gif
}
else { echo }
echo /td /n
echo /tr /n
$i++;
} //while
echo tr /n
echo td width=100% height=20 colspan=5 /td /n
echo /tr /n
echo tr td width=100% colspan=5 center /n
if ($page 1) {
echo a href=$PHP_SELF?page=1 font color=#408080 首页 /font /a /n
}
if ($page 1) {
$upage=$page-1;
echo a href=$PHP_SELF?page=$upage font color=red 上一页 /font /a /n
}
for($y=1;$y =$pages;$y++) {
echo a href=$PHP_SELF?page=$y $y /a /n
}
if ($page $pages) {
$npage=$page+1;
echo a href=$PHP_SELF?page=$npage font color=red 下一页 /font /a /n
}
if ($page $pages) {
echo a href=$PHP_SELF?page=$pages font color=#408080 尾页 /font /a /n
}
echo /center /td /n
echo /tr /n
echo /table /n
echo /center /div /n
?更多编程语言

郑重声明：本文版权归原作者所有，转载文章仅为传播更多信息之目的，如作者信息标记有误，请第一时间联系我们修改或删除，多谢。

上一篇：php打包网站并在线压缩为zip

下一篇：PHP协程内容的详解