PHP簡單分頁的實現

程式的關鍵點是頁碼的擷取

";    $url=$_SERVER["PHP_SELF"];    $pageNow =isset($_GET['pageNow'])?$_GET['pageNow']:1;    $start=($pageNow-1)*$every;    $allsql = "select * from {$table};";    // die();    // $sql = "select * from test;";    $rest = $conn->query($allsql);    $field = $rest->fetch_fields();    $fieldNum = count($field);   //欄位數量    //擷取資料量    $rowNum = $rest->num_rows;    // echo "記錄條數:".$rowNum;    $allpage=ceil($rowNum/$every);    // echo "----每頁分$every"."條時有$allpage"."頁
";    // $pageNow=($pageNow-1)*$every;    echo "
測試資訊表   添加
$pageNow"."頁
 
  ";          // echo "";                // echo "";                echo "
  
    "; for ($i=0; $i < $fieldNum; $i++) { echo "
    "; } echo "
   "; //顯示分頁 $sql="select * from $table limit $start,$every;"; // echo $sql; $newRest = $conn->query($sql); while($row = $newRest->fetch_row()){ echo "
   
    "; for ($j=0; $j <$fieldNum ; $j++) { echo "
    "; } echo "
   "; } echo "
  

   
".$field[$i]->name."
".$row[$j]."
 
";    echo "";    echo "";    echo "$pageNow/$allpage";    echo "首頁";    if($pageNow==1){         echo "上一頁";    }else{        $pagePre=$pageNow-1;        echo "上一頁";    }    // echo "上一頁";    // echo "下一頁";    if($pageNow==$allpage){       echo "下一頁";    }else{       $pageNext=$pageNow+1;      //  echo "
$pageNow
";       echo "下一頁";    }    echo "尾頁";    echo "";    echo "";    echo "選擇分頁";          for($i=1;$i<=$allpage;$i++){              echo "$i";          }    echo "";    echo "";  echo "";$conn->close();}//實際使用一個測試資料表echo pagef(10,'test');?>

//css檔案

*{padding: 0px;  margin: 0px;}.center{text-align: left;        color: red;        text-indent: 500px;}#info{color: DodgerBlue;}.table{       margin-left: auto;       margin-right: auto;       width: auto;       text-align: center;       color: royalblue;       border: 0;       }.td{width: 150px;    /*text-indent: 10px;*/    text-align: left;    font-size: 14px;}#td{color: #555;}tr:hover{background-color: DodgerBlue;}.info{text-align: center;      color: red;}.link{color: blue;      text-decoration: none;      text-align: center;      font-size: 12px;}.h3{text-align: center;    }#divclass{width: 100%;          height: 30px;          margin-top: 10px;          font-size: 18px;          /*background: coral;*/          }#center{width: 27%;        /*display: inline-block;*/        height: 30px;        margin-left: auto;        margin-right: auto;        /*background: orange;*/      }.fy{    /*background: DodgerBlue;*/    height: 30px;    line-height: 30px;    display: inline-block;    float: left;    color: DodgerBlue;    padding-left: 5px;    text-decoration: none;    text-align: center;   }.option{width: 80px;        height: 30px;        background: white;        float: left;        border: 2px solid DodgerBlue;        display: inline-block;}.button{width: 56px;        float: left;        color: white;        background: DodgerBlue;        height: 30px;        border: 0px;        border-radius: 0px;        display: inline-block;}

