Heim >Backend-Entwicklung >PHP-Tutorial >PHP简单分页的实现

PHP简单分页的实现

WBOY
WBOYOriginal
2016-06-20 12:30:45990Durchsuche

程序的关键点是页码的获取

<?php    function pagef($every,$table){    include('../conf/config.php');    echo "<link rel='stylesheet' type='text/css' href='../css/testpg.css'>";    $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"."页<br/>";    // $pageNow=($pageNow-1)*$every;    echo "<table class='table' border=1 cellspacing=0>";          // echo "<h3 class='info'>测试信息表   <a href='addCompany.html' class='link'>添加</a></h3>";                // echo "<h1>$pageNow"."页</h1>";                echo "<tr>";                for ($i=0; $i < $fieldNum; $i++) {                    echo "<td class='td'>".$field[$i]->name."</td>";                }          echo "</tr>";          //显示分页          $sql="select * from $table limit $start,$every;";          // echo $sql;          $newRest = $conn->query($sql);          while($row = $newRest->fetch_row()){               echo "<tr>";               for ($j=0; $j <$fieldNum ; $j++) {                   echo "<td class='td' id='td'>".$row[$j]."</td>";               }               echo "</tr>";          }    echo "</table>";    echo "<div id='divclass'>";    echo "<div id='center'>";    echo "<span class='fy'>$pageNow/$allpage</span>";    echo "<a href='{$url}?pageNow=1' class='fy'>首页</a>";    if($pageNow==1){         echo "<a href='{$url}?pageNow=1' class='fy'>上一页</a>";    }else{        $pagePre=$pageNow-1;        echo "<a href='{$url}?pageNow={$pagePre}' class='fy'>上一页</a>";    }    // echo "<a href='{$url}?pageNow={$pageNow-1}' class='fy'>上一页</a>";    // echo "<a href='{$url}?pageNow={$pageNow+1}' class='fy'>下一页</a>";    if($pageNow==$allpage){       echo "<a href='{$url}?pageNow={$allpage}' class='fy'>下一页</a>";    }else{       $pageNext=$pageNow+1;      //  echo "<h1>$pageNow</h1>";       echo "<a href='{$url}?pageNow={$pageNext}' class='fy'>下一页</a>";    }    echo "<a href='{$url}?pageNow={$allpage}' class='fy' >尾页</a>";    echo "<form action='{$url}' method='get' >";    echo "<select name='pageNow' class='option'>";    echo "<option value='1'>选择分页</option>";          for($i=1;$i<=$allpage;$i++){              echo "<option value='{$i}'>$i</option>";          }    echo "<input type='submit' value='跳转' class='button'>";    echo "</div>";  echo "</div>";$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;}


Stellungnahme:
Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn