一個PHPMSSQL分頁的例子

本文格式為Word版，下載可任意編輯——一個PHPMSSQL分頁的例子一個PHP+MSSQL分頁的例子

貌似眾多的PHP開發(fā)人員根本沒有使用它，甚至聞所未聞。就跟隨我一起去了解下吧，想了解更多相關(guān)信息請持續(xù)關(guān)注我們我!

?

requireconfig.php;

dlextensions/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_queryselectcount*asdatefromnews,$db;

$query=mssql_fetch_array$query;

$pages=ceil$query[0]/$userperpage;

if$page$pages$page=$pages;

if$query[0]$userperpage$userperpage=$query[0];

$dangqian=$1*$userperpage;

echotitleNews/title;

echostyletype=text/cssn;

echo!--n;

echoAtext-decoration:nonen;

echoA:hovercolor:blue;;text-decoration:underlinen;

echotdfont-size:9ptn;

echo--/stylen;

echopalign=centercentern;

echotableborder=0width=100%cellspacing=0cellpadding=0height=19n;

echotr;

echotdwidth=52%colspan=5imgsrc=xw.gifwidth=100%/td/trn;

echotr;

echotdwidth=52%height=19valign=bottombgcolor=#B5C6B0palign=centerfontn;

echocolor=#408080新聞標(biāo)題/font/tdn;

echotdwidth=14%height=19valign=bottomalign=centerbgcolor=#B5C6B0fontn;

echocolor=#408080發(fā)表日期/font/tdn;

echotdwidth=19%height=19valign=bottomalign=centerbgcolor=#B5C6B0fontn;

echocolor=#408080發(fā)表部門/font/tdn;

echotdwidth=7%height=19valign=bottomalign=centerbgcolor=#B5C6B0fontn;

echocolor=#408080閱讀/font/tdn;

echotdwidth=8%height=19valign=bottomalign=centerbgcolor=#B5C6B0fontn;

echocolor=#408080圖像/font/tdn;

echo/trn;

echo/tablen;

echo/center/pn;

echopalign=centercentern;

echotableborder=0width=100%cellspacing=0cellpadding=0height=19n;

$db=mssql_connect$local,$user,$pass;

mssql_select_db$name,$db;

$query=mssql_queryselect*fromnewsorderbydatedesc,$db;

$roro=mssql_num_rows$query;

if$roro==0

echobrbrpalign=centerfontcolor=#FF0000size=2marqueebehavior=alternateborder=0width=300height=16scrolldelay=70目前數(shù)據(jù)庫中無任何記錄！/marquee/font/p;

exit;

mssql_data_seek$query,$dangqian;

$i=0;

while$arr=mssql_fetch_array$query

if$i=$userperpagebreak;

echotrn;

echotdwidth=52%bgcolor=#F3F3F3height=19valign=bottompalign=leftahref=readnews.php?id=$arr[date]target=_blankfontcolor=#3D5449$arr[title]/font/a/tdn;

$datee=dateY-m-d,$arr[date];

echotdwidth=14%bgcolor=#F3F3F3height=19valign=bottomalign=centerfontcolor=#3D5449$datee/font/tdn;

echotdwidth=19%bgcolor=#F3F3F3height=19valign=bottomalign=centerfontcolor=#3D5449$arr[type]/font/tdn;

echotdwidth=7%bgcolor=#F3F3F3height=19valign=bottomalign=centerfontcolor=#808080$arr[click]/font/tdn;

echotdwidth=8%bgcolor=#F3F3F3height=19valign=bottomalign=centern;

$arr[photo]=trim$arr[photo];

if$arr[photo]||file_exists$arr[photo]

echoimgsrc=picture.gif;

elseecho;

echo/tdn;

echo/trn;

$i++;

//while

echotrn;

echotdwidth=100%height=20colspan=5/tdn;

echo/trn;

echotrtdwidth=100%colspan=5center