- <?php
- $conn = mysql_connect('localhost','root','mysql');
- $db = mysql_select_db("wiki");
- $q = mysql_query("select * from wiki_doc");
-
- $num = mysql_num_rows($q);
- $perpage = 5;
- $totalpage = @ceil($num/$perpage);
- $page =$_GET['page'];
-
- if(!isset($page)){
- $page = 1;
-
- }
-
-
- $start = ($page-1)*$perpage;
- $qq=mysql_query("select * from wiki_doc limit $start,$perpage");
- $info = array();
- while($result=mysql_fetch_array($qq)){
- $info[] = $result;
- }
-
- echo "<table>";
- foreach($info as $key){
- echo "<tr><td>$key[did]</td><td> </td><td>$key[title]</td></tr>";
- }
- echo "</table>";
- if($page!=1){?>
- <a href="page2.php?page=<?php echo $page-1; ?>">Prev</a>
- <?php
- }
- for($i=1;$i<=$totalpage;$i++){
- ?>
- <a href="page2.php?page=<?php echo $i; ?>"><?php echo $i; ?></a>
- <?php
-
- }
- if($page<$totalpage){?>
- <a href="page2.php?page=<?php echo $page+1; ?>">Next</a>
- <?php
- }?>
az2HTML5中文学习网 - HTML5先行者学习网az2HTML5中文学习网 - HTML5先行者学习网