無JS,完全php面向過程,資料分頁

001
<?php           
002
                //登陸版面設定的session,當session中存在name時
003
                //session_start();
004
        //$name = $_SESSION['name'];
005
        //if (empty($name)){
006
        //  header("Location: error.php");
007
        //  exit();
008
        //}
009
 
010
        //面向過程, 資料分頁顯示
011
        if(false!=($mysql = mysql_connect('本地mysql', 'mysql使用者名稱', 'mysql密碼'))){
012
            mysql_query('set names utf8',$mysql);    //設定資料庫中的編碼
013
            mysql_select_db("資料庫database",$mysql);
014
        }else{
015
            die("串連失敗");
016
        }
017
        
018
        
019
        $pageSize = 10;     //頁面顯示條數
020
        $rowCount = 0;  //資料總條數,從資料庫獲得
021
        
022
        $sqlCount = 'select count(id) from employee';
023
        $res1 = mysql_query($sqlCount,$mysql);
024
        
025
        //取出資料條數
026
        if(false!=($row=mysql_fetch_row($res1))){
027
            $rowCount = $row[0];
028
        }
029
        
030
        //總頁數,通過計算得到
031
        $pageCount = 0;
032
        $pageCount = ceil($rowCount/$pageSize);
033
        
034
        //擷取當前頁
035
        if(!isset($_GET['pageNow'])){           // 當 get/post都為空白的時候賦預設值1
036
            $pageNow = 1;   //當前頁數
037
        }elseif(false!=is_numeric($_GET['pageNow'])){
038
            $pageNow = $_GET['pageNow'];
039
        }else{
040
            header("Location: ../Error/error.php");
041
                        exit();
042
        }
043
 
044
                //列印分頁資料
045
            echo "<div  style='margin-left:300px;margin-top:1px;'>";
046
            echo "<table style='border:1px;border-style:solid;border-width:1px;border-color:green'>";
047
            echo "<tr><th>id</th>&nbsp;<th>name</th>&nbsp;<th>age</th>&nbsp;<th>sex</th>&nbsp;<th>birthday</th>&nbsp;<th>編輯僱員</th>&nbsp;<th>刪除僱員</th>&nbsp;</tr>";
048
            $sqList = "select id,name,age,sex,birthday from employee limit ".($pageNow-1)*$pageSize.",".$pageSize;
049
            $res2 = mysql_query($sqList,$mysql);
050
            while (false!=($row=mysql_fetch_assoc($res2))){
051
                echo "<tr><td>{$row['id']}</td>&nbsp;<td>{$row['name']}</td>&nbsp;<td>{$row['age']}</td>&nbsp;<td>{$row['sex']}</td>&nbsp;<td>{$row['birthday']}</td>&nbsp;<td><a href=#>編輯</a></td>&nbsp;<td><a href=#>刪除</a></td></tr>";
052
            }
053
            echo "</table>";
054
 
055
                        //表單控制顯示頁數
056
            echo "<form action='當前頁'>";
057
            //上一頁按鈕
058
            if($pageNow>1){        
059
                $pageUp = $pageNow-1;
060
                echo "<a href='?pageNow=".$pageUp."'>上一頁</a>&nbsp;";
061
            }
062
            
063
            //下一頁按鈕
064
            if($pageNow<$pageCount){
065
                $pageDown = $pageNow+1;
066
                echo "<a href='?pageNow=".$pageDown."'>下一頁</a>&nbsp;<br/>";
067
            }
068
            
069
            //後退十頁按鈕
070
            if($pageNow-10>0){
071
                echo "<a href='?pageNow=".($pageNow-10)."'>&lt;&lt;&lt;</a>&nbsp;";
072
            }
073
            
074
                
075
            //向本頁傳遞當前顯示的頁數,並顯示第幾頁按鈕
076
            for($i=1;$i<=$pageCount;$i++){
077
                    
078
                    if($i>$pageNow-2 && $i<$pageNow+6){
079
                        if($i!=$pageNow){
080
                            echo "<a href='?pageNow=".$i."'>第".$i."頁</a>&nbsp;";
081
                        }
082
                    }
083
            }
084
                
085
            //前進十頁
086
            if($pageNow+10<=$pageCount){
087
                echo "<a href='?pageNow=".($pageNow+10)."'>&gt;&gt;&gt;</a>&nbsp;";
088
            }
089
            
090
            //顯示當前頁與總頁數
091
            echo "<br/>當前頁".$pageNow."頁/共".$pageCount."頁";          
092
            
093
            
094
            //跳轉頁
095
            echo "跳轉到:<input type='text' name='pageNow' id='pageNow' style='width:30px;height:20px'/>頁<input type='submit' style='width:37px;height:20px;font-size:11px;' value='go'/>";
096
            echo "</form>";  www.2cto.com
097
            echo "</div>";
098
        
099
        
100
?>
作者：優酪乳喝不完