一个PHP加MSSQL分页的例子

本篇文章给大家分享的内容是关于一个php加mssql分页的例子，有需要的朋友可以参考一下

$pages) { $page=$pages;} 
      if ($query[0]<$userperpage) { $userperpage=$query[0]; } 
$dangqian=($page-1)*$userperpage; 
echo ""; 
echo "\n"; 
echo "
\n"; 
echo ""; 
echo " \n"; 
echo ""; 
echo "    \n"; 
echo "    \n"; 
echo "    \n"; 
echo "    \n"; 
echo "    \n"; 
echo "  \n"; 
echo "
@@##@@
新闻标题
发表日期
发表部门
阅读
图像
\n"; 
echo "
\n"; 
echo "
\n"; 
echo "\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 "

目前数据库中无任何记录！
"; 
       exit; 
                    } 
     mssql_data_seek($query,$dangqian); 
     $i=0; 
     while ($arr=mssql_fetch_array($query)) { 
      if ($i>=$userperpage) { break;} 
echo "\n"; 
echo "    \n"; 
$datee=date("Y-m-d",$arr[date]); 
echo "    \n"; 
echo "    \n"; 
echo "    \n"; 
echo "    \n"; 
echo "\n"; 
    $i++; 
                                             }  //while 
echo "\n"; 
echo "\n"; 
echo "\n"; 
echo "\n"; 
echo "\n"; 
echo "
$arr[title]
$datee
$arr[type]
$arr[click]
\n"; 
  $arr[photo]=trim($arr[photo]); 
   if (($arr[photo]<>"") || (file_exists($arr[photo]))) { 
echo "@@##@@"; 
                                                        } 
   else { echo " "; } 
echo "
\n"; 
   if ($page<>1) { 
echo "首页\n"; 
                 } 
  if ($page>1) {  
  $upage=$page-1;  
echo "上一页\n"; 
               } 
  for($y=1;$y<=$pages;$y++) { 
   echo "$y\n"; 
                             } 
  if ($page<$pages) { 
  $npage=$page+1; 
echo "下一页\n"; 
                    } 
  if ($page<>$pages)  { 
echo "尾页\n"; 
                      } 
echo "
\n"; 
echo "
\n"; 
?>

商城购物系统

商城购物系统是一个以php+MySQL进行开发的可塑性极强的电子商品平台；商城购物系统可自定义商品栏目内容，包含分销功能，分销管理、分销订单提成完整功能，商品加购物车、商品支付、商品发货等一系列流程，包括pc端和手机H5端。

下载