Home >Backend Development >PHP Tutorial >An example of PHP+MSSQL paging_PHP tutorial

An example of PHP+MSSQL paging_PHP tutorial

WBOY
WBOYOriginal
2016-07-21 16:04:38830browse

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 "News";
echo "\n";
echo "

\n";
echo " echo "";
echo " \n";
echo "";
echo "    \n";
echo "    \n";
echo "    \n";
echo "    \n";
echo "    \n";
echo "  \n";
echo "

echo " color=#408080>新闻标题

echo " color=#408080>发表日期 echo " color=#408080>发表部门 echo " color=#408080>阅读 echo " color=#408080>图像
\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";
?> 

www.bkjia.comtruehttp://www.bkjia.com/PHPjc/315963.htmlTechArticle? 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); $q...
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article:php&java (3)_PHP tutorialNext article:php&java (3)_PHP tutorial