Pertanyaan paging PHP ditulis sebagai "select word from ufeature.spam_accuse_word_list where flag='0'." Pernyataan ini ialah pernyataan pertanyaan SQL dan hasil pertanyaan boleh diperolehi.

Persekitaran pengendalian artikel ini: sistem Windows 7, PHP versi 7.1, komputer Dell G3.

Bagaimana hendak menulis pertanyaan paging dalam php? 3 cara untuk melaksanakan fungsi paging dalam php

Terus muat naik kod tersebut, saya harap anda boleh membacanya dengan teliti.

Kaedah 1: Pertanyaan SQL untuk melaksanakan paging, anda perlu memanggil beberapa fungsi, lihat skrip untuk butiran:

1.pager.class.php

<?php
  
  class pager {
    public $sql; //SQL查詢語(yǔ)句
    public $datanum; //查詢所有的數(shù)據(jù)總記錄數(shù)
    public $page_size; //每頁(yè)顯示記錄的條數(shù)
    protected $_errstr;
    protected $_conn;
    protected $_query_id;
    public function query($query)///這個(gè)函數(shù)有問題，暫時(shí)可以不用
    {
    $ret = false;
    if (!empty($query)) {
      if ($this->_conn === false || !is_resource($this->_conn)) {
       warningLog(__METHOD__ . &#39;: query sql with no connection&#39;, true);
      return false;
      }
    $this->_query_id = @mysql_query($query, $this->_conn);
    if ($this->_query_id === false) {
    $this->_errstr = @mysql_error();
    $ret = false;
     } else {
    $this->_errstr = &#39;SUCCESS&#39;;
    $ret = $this->_query_id;
      }
    }
     $msg = ($ret === false) ? &#39;false&#39; : strval($ret);
     debugLog(__METHOD__.": [$msg] returned for sql query [$query]");
    return $ret;
    }
function __construct($sql,$page_size) {
      $result = mysql_query($sql);
      $datanum = mysql_num_rows($result);
      $this->sql=$sql;
      $this->datanum=$datanum;
      $this->page_size=$page_size;
    }
    //當(dāng)前頁(yè)數(shù)
    public function page_id() {
      if($_SERVER[&#39;QUERY_STRING&#39;] == ""){
        return 1;
      }elseif(substr_count($_SERVER[&#39;QUERY_STRING&#39;],"page_id=") == 0){
        return 1;
      }else{
        return intval(substr($_SERVER[&#39;QUERY_STRING&#39;],8));
      }
    }
    //剩余url值
    public function url() {
      if($_SERVER[&#39;QUERY_STRING&#39;] == ""){
        return "";
      }elseif(substr_count($_SERVER[&#39;QUERY_STRING&#39;],"page_id=") == 0){
        return "&".$_SERVER[&#39;QUERY_STRING&#39;];
      }else{
        return str_replace("page_id=".$this->page_id(),"",$_SERVER[&#39;QUERY_STRING&#39;]);
      }
    }
    //總頁(yè)數(shù)
    public function page_num() {
      if($this->datanum == 0){
        return 1;
      }else{
        return ceil($this->datanum/$this->page_size);
      }
    }
//數(shù)據(jù)庫(kù)查詢的偏移量
    public function start() {
      return ($this->page_id()-1)*$this->page_size;
    }
    //數(shù)據(jù)輸出
    public function sqlquery() {
      return $this->sql." limit ".$this->start().",".$this->page_size;
    }
    //獲取當(dāng)前文件名
    private function php_self() {
      return $_SERVER[&#39;PHP_SELF&#39;];
    }
    //上一頁(yè)
    private function pre_page() {
      if ($this->page_id() == 1) { //頁(yè)數(shù)等于1
        return "<a href=".$this->php_self()."?page_id=1".$this->url().">上一頁(yè)</a> ";
      }elseif ($this->page_id() != 1) { //頁(yè)數(shù)不等于1
        return "<a href=".$this->php_self()."?page_id=".($this->page_id()-1).$this->url().">上一頁(yè)</a> ";
      }
    }
    //顯示分頁(yè)
    private function display_page() {
      $display_page = "";
      if($this->page_num() <= 10){ //小于10頁(yè)
        for ($i=1;$i<=$this->page_num();$i++) //循環(huán)顯示出頁(yè)面
          $display_page .= "<a href=".$this->php_self()."?page_id=".$i.$this->url().">".$i."</a> ";
          return $display_page;
      }elseif($this->page_num() > 10){ //大于10頁(yè)
        if($this->page_id() <= 6){
          for ($i=1;$i<=10;$i++) //循環(huán)顯示出頁(yè)面
            $display_page .= "<a href=".$this->php_self()."?page_id=".$i.$this->url().">".$i."</a> ";
            return $display_page;
        }elseif(($this->page_id() > 6) && ($this->page_num()-$this->page_id() >= 4)){
          for ($i=$this->page_id()-5;$i<=$this->page_id()+4;$i++) //循環(huán)顯示出頁(yè)面
            $display_page .= "<a href=".$this->php_self()."?page_id=".$i.$this->url().">".$i."</a> ";
 return $display_page;
        }elseif(($this->page_id() > 6) && ($this->page_num()-$this->page_id() < 4)){
          for ($i=$this->page_num()-9;$i<=$this->page_num();$i++) //循環(huán)顯示出頁(yè)面
            $display_page .= "<a href=".$this->php_self()."?page_id=".$i.$this->url().">".$i."</a> ";
            return $display_page;
        }
      }
    }
    //下一頁(yè)
    private function next_page() {
      if ($this->page_id() < $this->page_num()) { //頁(yè)數(shù)小于總頁(yè)數(shù)
        return "<a href=".$this->php_self()."?page_id=".($this->page_id()+1).$this->url().">下一頁(yè)</a> ";
      }elseif ($this->page_id() == $this->page_num()) { //頁(yè)數(shù)等于總頁(yè)數(shù)
        return "<a href=".$this->php_self()."?page_id=".$this->page_num().$this->url().">下一頁(yè)</a> ";
      }
    }
    // 設(shè)置分頁(yè)信息
    public function set_page_info() {
      $page_info = "共".$this->datanum."條 ";
      $page_info .= "<a href=".$this->php_self()."?page_id=1".$this->url().">首頁(yè)</a> ";
      $page_info .= $this->pre_page();
      $page_info .= $this->display_page();
      $page_info .= $this->next_page();
      $page_info .= "<a href=".$this->php_self()."?page_id=".$this->page_num().$this->url().">尾頁(yè)</a> ";
      $page_info .= "第".$this->page_id()."/".$this->page_num()."頁(yè)";
      return $page_info;
    }
  }
?>

2. Skrip 2:

<?php
  //類的用法
  // 讀取分頁(yè)類
  include("pager.class.php");
  // 數(shù)據(jù)庫(kù)連接初始化
//  $db = new mysql();
  $impeach_host = &#39;10.81.43.139&#39;;
  $impeach_usr = &#39;vmtest15&#39;;
  $impeach_passwd = &#39;vmtest15&#39;;
  $impeach_name = &#39;ufeature&#39;;
  $impeach_con = mysql_connect($impeach_host, $impeach_usr, $impeach_passwd) or
    die("Can&#39;t connect ".mysql_error());
  mysql_select_db($impeach_name, $impeach_con);
  // 這是一個(gè)sql查詢語(yǔ)句，并得到查詢結(jié)果
  $sql = "select word from ufeature.spam_accuse_word_list where flag=&#39;0&#39;";
  // 分頁(yè)初始化
  $page = new pager($sql,20);
  // 20是每頁(yè)顯示的數(shù)量
  // $res_1 = mysql_query($sql) or
  //    die("Can&#39;t get result ".mysql_error());
   $result=mysql_query($page->sqlquery());
while($info = mysql_fetch_array($result,MYSQL_ASSOC)){
  // while($info = mysql_fetch_array($res_1, MYSQL_ASSOC)){
  echo $info["word"]."<br/>";
  }
  // 頁(yè)碼索引條
  echo $page->set_page_info();
?>

Kaedah 2: Menggunakan ajax

1. Mula-mula fahami penggunaan had dalam pernyataan SQL >

PILIH * DARI jadual …… hadkan kedudukan permulaan, bilangan operasi (kedudukan permulaan bermula dari 0)

Contoh

Dapatkan 20 rekod pertama: PILIH * DARI jadual …… had 0, 20

Dapatkan 20 rekod bermula dari 11hb: PILIH * DARI jadual... had 10, 20

LIMIT n bersamaan dengan LIMIT 0,n.

Contohnya, pilih * dari jadual LIMIT 5; // Kembalikan 5 baris pertama, sama seperti pilih * dari jadual LIMIT 0, 5

Prinsip paging

Apa yang dipanggil paparan paging , iaitu, keputusan yang ditetapkan dalam pangkalan data dipaparkan bahagian demi bahagian

Cara membahagikannya, perenggan mana ia berada pada masa ini (berapa banyak item setiap halaman, halaman apa adakah ia sedang dihidupkan)

10 Rekod Teratas: pilih * daripada had jadual 0,10

Rekod 11 hingga 20: pilih * daripada had jadual 10,10

Rekod 21 hingga 30: pilih * daripada had jadual 20,10

Formula halaman:

(nombor halaman semasa - 1) 1) * $PageSize, $PageSize

3 Fungsi $_SERVER["REQUEST_URI"]

ialah sejenis pembolehubah pelayan pratakrif Semua yang bermula dengan $_SERVER dipanggil pembolehubah pelayan yang telah ditetapkan.

Fungsi REQUEST_URI adalah untuk mendapatkan URI semasa, iaitu laluan alamat lengkap kecuali nama domain.

Contoh:

Halaman semasa ialah: http://www.test.com/home.php?id=23&cid=22

Hasilnya ialah : / home.php?id=23&cid=22

echo $_SERVER["REQUEST_URI"]

4. parse_url() parse URL function

parse_url() ialah fungsi yang menghuraikan URL ke dalam tatasusunan dengan nilai kunci tetap ??

Contoh

Hasil:

$ua=parse_url("http://username:password@hostname/path?arg=value#anchor");
print_r($ua);

Array
(
 [scheme] => http  ；協(xié)議
 [host] => hostname  ；主機(jī)域名
 [user] => username  ；用戶
 [pass] => password  ；密碼
 [path] => /path   ；路徑
 [query] => arg=value  ；取參數(shù)
 [fragment] => anchor  ；
)

5. Contoh kod

Halaman mesej ini terbahagi kepada 3 bahagian Satu ialah reka bentuk pangkalan data, satu ialah halaman sambungan, dan satu lagi ialah halaman paparan.

(1) Pangkalan data reka bentuk

Pangkalan data reka bentuk dipanggil bbs Terdapat jadual data yang dipanggil mesej, yang mengandungi medan seperti tajuk, tarikh akhir, pengguna, kandungan, dll., yang masing-masing. mewakili tajuk mesej, tarikh mesej, dan sebagainya Orang yang meninggalkan mesej, kandungan mesej

(2) Sambungkan halaman

(3) Paparkan halaman

<?php
$conn = @ mysql_connect("localhost", "root", "123456") or die("數(shù)據(jù)庫(kù)鏈接錯(cuò)誤");
mysql_select_db("bbs", $conn);
mysql_query("set names &#39;GBK&#39;"); //使用GBK中文編碼;
//將空格，換行轉(zhuǎn)換為HTML可解析
function htmtocode($content) {
 $content = str_replace("\n", "<br>", str_replace(" ", " ", $content)); //兩個(gè)str_replace嵌套
 return $content;
}
//$content=str_replace("&#39;","‘",$content);
 //htmlspecialchars();
 
?>

Kaedah 3:

<?php
 include("conn.php");
$pagesize=2; //設(shè)置每頁(yè)顯示2個(gè)記錄
$url=$_SERVER["REQUEST_URI"]; 
$url=parse_url($url);
$url=$url[path];
$numq=mysql_query("SELECT * FROM `message`");
$num = mysql_num_rows($numq);
if($_GET){
$pageval=$_GET;
$page=($pageval-1)*$pagesize;
$page.=&#39;,&#39;;
}
if($num > $pagesize){
 if($pageval<=1)$pageval=1;
 echo "共 $num 條".
 " <a href=$url?page=".($pageval-1).">上一頁(yè)</a> <a href=$url?page=".($pageval+1).">下一頁(yè)</a>";
}
$SQL="SELECT * FROM `message` limit $page $pagesize ";
 $query=mysql_query($SQL);
 
 while($row=mysql_fetch_array($query)){
?>
<table width=500 border="0" cellpadding="5" cellspacing="1" bgcolor="#add3ef">
 <tr bgcolor="#eff3ff">
 <td>標(biāo)題：<?php echo $row[title]?></td> <td>時(shí)間：<?php echo $row[lastdate]?></td>
 </tr>
 <tr bgcolor="#eff3ff">
 <td> 用戶：<?php echo $row[user]?></td><td></td>
 </tr>
 <tr>
 <td>內(nèi)容：<?php echo htmtocode($row[content]);?></td>
 </tr>
 <br>
</table>
<?php
 }
?>

Skrip 2:

<script> 
function viewpage(p){ 
if(window.XMLHttpRequest){ 
var xmlReq = new XMLHttpRequest(); 
} else if(window.ActiveXObject) { 
var xmlReq = new ActiveXObject(&#39;Microsoft.XMLHTTP&#39;); 
} 
var formData = "page="+p; 
xmlReq.onreadystatechange = function(){ 
if(xmlReq.readyState == 4){ 
document.getElementByIdx_x(&#39;content2&#39;).innerHTML = xmlReq.responseText; 
} 
} 
xmlReq.open("post", "hotel_list.php", true); 
xmlReq.setRequestHeader("Content-Type", "application/x-www-form-urlencoded"); 
xmlReq.send(formData); 
return false; 
} 
</script>

Pembelajaran yang disyorkan: "

Tutorial Video PHP

header("Content-Type:text/html;charset=GB2312"); 
$pagesize=10; 
//echo $_POST['page']; 
$result = mysql_query("Select count(DISTINCT hotelname) FROM ".TBL_HOTELS); 
$myrow = mysql_fetch_array($result); 
$numrows=$myrow[0]; 
$pages=intval($numrows/$pagesize); 
if ($numrows%$pagesize) 
$pages++; 
if (isset($_POST['page'])){ 
$page=intval($_POST['page']); 
} 
else{ 
//設(shè)置為第一頁(yè) 
$page=1; 
} 
$first=1; 
$prev=$page-1; 
$next=$page+1; 
$last=$pages; 
//計(jì)算記錄偏移量 
$offset=$pagesize*($page - 1); 
//讀取指定記錄數(shù) 
$result=mysql_query("select `hotelname` , count( * ) from ".TBL_HOTELS." GROUP BY `hotelname` order by id desc limit $offset,$pagesize"); 
$num = mysql_num_rows($result); 
while ($row = mysql_fetch_array($result,MYSQL_NUM)) { 
$hotelname[] = $row[0]; 
$countpeople[] = $row[1]; 
} 
for($a=0;$a<$num;$a++) 
{ 
//$result=mysql_query("select count(title) from " . TBL_Comments ." where `title`=\"".$title[$a]."\""); 
//$row = mysql_fetch_row($result); 
echo "<TABLE style=\"MARGIN-BOTTOM: 20px\" cellSpacing=0 cellPadding=0 width=100% border=0>\n"; 
echo "<TBODY>\n"; 
echo "<TR>\n"; 
echo "<TD style=\"PADDING-TOP: 5px\" vAlign=top align=left width=80>\n"; 
//rating_bar($title[$a],5); 
echo "</TD>\n"; 
echo "<TD style=\"PADDING-TOP: 5px\" align=left width=100%><A title=$hotelname[$a] style=\"FONT-SIZE: 14px\" href=#>$hotelname[$a]</A>\n"; 
echo "</TD></TR>\n"; 
echo " <TR>\n"; 
echo "<TD></TD>\n"; 
echo "<TD style=\"PADDING-LEFT: 0px\">\n"; 
echo "<IMG src=\"images/comment.gif\" border=0> 推薦人數(shù):($countpeople[$a]) |\n"; 
echo "<SPAN>平均分：<STRONG></STRONG> (".$count."票) | 評(píng)論數(shù):()</SPAN>\n"; 
echo "</TD></TR></TBODY></TABLE>\n"; 
} 
echo "<TABLE style=\"MARGIN-TOP: 30px\" cellSpacing=0 cellPadding=0 width=\"100%\""; 
echo "border=0>"; 
echo "<TBODY><TR><TD colSpan=3 height=20>"; 
echo "<DIV align=center>"; 
echo "<P align=left><FONT color=red>第".$page."頁(yè)/總".$pages."頁(yè) | 總".$numrows."條</FONT> | "; 
if ($page>1) echo "<a onclick=\"viewpage(".$first.")\" href=&#39;#&#39;>首頁(yè)</a> | "; 
if ($page>1) echo "<a onclick=\"viewpage(".$prev.")\" href=&#39;#&#39;>上頁(yè)</a> | "; 
if ($page<$pages) echo "<a onclick=\"viewpage(".$next.")\" href=&#39;#&#39;>下頁(yè)</a> | "; 
if ($page<$pages) echo "<a onclick=\"viewpage(".$last.")\" href=&#39;#&#39;>尾頁(yè)</a>"; 
echo "轉(zhuǎn)到第 <INPUT maxLength=3 size=3 value=1 name=goto_page> 頁(yè) <INPUT hideFocus onclick=\"viewpage(document.all.goto_page.value)\" type=button value=Go name=cmd_goto>"; 
echo "</P></DIV></TD></TR></TBODY></TABLE>";

"

Atas ialah kandungan terperinci Bagaimana untuk menulis pertanyaan paging dalam php. Untuk maklumat lanjut, sila ikut artikel berkaitan lain di laman web China PHP!