PHP MSSQL Paging Instance _php tips

This example of this article for you to share the PHP MSSQL can refresh the paging instance, specific content as follows

<?php/* ' page description: * * $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 isn't in (select top). (

($page-1) * $pagesize). "ID from Reguser ORDER BY id DESC" 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] total: $totalnum records, Total $pagEcount page, current page $page ";
 if ($page!=1) {echo "<a href=?page=1$filster> home </a>"; echo "<a href=?page=". ($page-1). "
 $filster > Prev </a> "; } if ($page < $pagecount) {echo "<a href=?page=". ( $page + 1). "
 $filster > Next </a> ";
 echo "<a href=?page= $pagecount $filster> last </a>  ";
 }}?>

Below for everyone to share the Php+mssql General page formula for your reference, the specific content as follows

<?php//phpinfo ();
$conn =mssql_connect (' 192.168.0.3 ', ' app ', ' web ') or Die (Mssql_get_last_message ()); if ($conn)//{//?echo "Success";//}else{//?echo "fail";//}?>  

The above is the entire content of this article, I hope that you learn PHP program help.