亚洲精品中文字幕亚洲精品,亚洲va欧美va天堂v国产综合

當(dāng)前位置：首頁 > 范文|應(yīng)用文 > IT技術(shù)專欄 > 網(wǎng)絡(luò)編程

PHP MSSQL 分頁實(shí)例

來源：易賢網(wǎng) 閱讀：822 次日期：2016-08-26 15:49:06

溫馨提示：易賢網(wǎng)小編為您整理了“PHP MSSQL 分頁實(shí)例”,方便廣大網(wǎng)友查閱！

本文實(shí)例為大家分享了PHP MSSQL可刷新分頁實(shí)例，具體內(nèi)容如下:

<?php

'頁面說明：

$link=mssql_connect("MYSQL2005","sa","123456") or die("db link error!".mssql_error());

mssql_select_db("edu_dzk",$link) or die("db open error!".mssql_error());

//mssql_query("set names 'utf8'");

$sqlstrcount="SELECT count(1) FROM reguser";

$page = $_GET["page"];

if(!is_numeric($page)){

$page="1";

}

$pagesize="30";

//$sql=mysql_query($sqlstr);

//$totalnum=mysql_num_rows($sql);

$sql=mssql_query($sqlstrcount);

list($totalnum)=mssql_fetch_row($sql);

$pagecount=ceil($totalnum/$pagesize);

$offset=($page-1)*$pagesize;

$sqlstr="Select top ".($pagesize)." * from reguser where id not in (select top ".(($page-1)*$pagesize)." id from reguser order by id desc) order by id desc";

$sql=mssql_query($sqlstr);

$result="";

while($result=mssql_fetch_array($sql)){

echo $result["id"].'<br>';

}

showpageinfo2($totalnum,$pagecount,$page,"&z=".$z);

mssql_Close($link);

function showpageinfo2($totalnum,$pagecount,$page,$filster)

{

echo "共計(jì): $totalnum 條記錄,共 $pagecount 頁,當(dāng)前是第 $page 頁 ";

if($page!=1)

{

echo "<a href=?page=1$filster>首頁</a> ";

echo "<a href=?page=".($page-1)."$filster>上一頁</a> ";

}

if($page<$pagecount)

{

echo "<a href=?page=".($page+1)."$filster>下一頁</a> ";

echo "<a href=?page=$pagecount$filster>尾頁</a> ";

}

下面為大家分享了PHP+MSSQL通用分頁公式，供大家參考，具體內(nèi)容如下:

<?php

//phpinfo();

//$conn=mssql_connect('192.168.0.3','app','web')or die (mssql_get_last_message());

//if($conn)

//{

//?echo "success";

//}else{

//?echo "fail";

//}

<html>

<head>

<title>PHP分頁</title>

</head>

<body>

$gPageSize= 10; //每頁顯示的記錄數(shù)

$hostname = "."; //MsSQL Server

$dbuser = "sa"; //用戶名

$dbpasswd = ""; //密碼

//連接數(shù)據(jù)庫

$id = mssql_connect($hostname,$dbuser,$dbpasswd) or die("無法連接數(shù)據(jù)庫服務(wù)器！");

$db = mssql_select_db("phmis04",$id) or die("無法連接數(shù)據(jù)庫！");

//以xxx表為例,構(gòu)建查詢字符串

$query = "select top 20 ag_mate,ag_color,ag_width,ag_mode,mi_name,convert(char,ag_date,23)as ag_date,ag_grid,au_name,ag_num from acco_grid join mate_info on ag_mate=mi_id join appl_unit on au_id=ag_unit;";

//執(zhí)行查詢語句

$rresult = mssql_query($query) or die("無法執(zhí)行SQL：$query");

//$page變量標(biāo)示當(dāng)前顯示的頁

if(!isset($page)) $page=1;

if($page==0) $page=1;

//得到當(dāng)前查詢到的紀(jì)錄數(shù) $nNumRows

if(($nNumRows= mssql_num_rows($rresult))<=0)

{

echo "<p align=center>沒有紀(jì)錄";

exit;

};

//得到最大頁碼數(shù)MaxPage