PHP Beginners Tutorial: Reading database programs

Let's start by building a data link.

<?php
mysql_connect (' localhost ', ' root ', ' Mailangel ') or Die (' database server no exists! ');
mysql_select_db (' Vot ') or Die (' Database error! ');
mysql_query ("SET NAMES ' GBK '");//set document CharSet encode
?>

Here's the code to read the data and pagination.

<?php
$page =isset ($_get[' page ')? $_get[' page ']:1;
$sql = "SELECT * from Su_mon_vote ORDER by id DESC";
$result =mysql_query ($sql) or Die (' Fail1 '. mysql_error ());
$rs =mysql_fetch_array ($result);
$rdcount =mysql_num_rows ($result);
if ($rdcount) {
$pagesize = 10;
$pagecount = ($rdcount% $pagesize)? (int) ($rdcount/$pagesize) + 1: $rdcount/$pagesize;//Total Statistics page
$start = ($page >=1 && $page <= $pagecount)? $start = $pagesize * ($page-1): $start =1;//to get the super record

$sql = "SELECT * from Su_mon_vote ORDER BY id desc limit $start, $pagesize";
$result =mysql_query ($sql);
while ($rs =mysql_fetch_array ($result)) {

?>
<tr>
&LT;TD height= "A" bgcolor= "#FFFFFF" ><?php echo $rs [0]; ></td>
&LT;TD align= "left" valign= "Top" bgcolor= "#FFFFFF" ><?php echo $rs [7]; ></td>
&LT;TD align= "left" valign= "Top" bgcolor= "#FFFFFF" ><?php echo $rs [9]; ></td>
&LT;TD align= "left" valign= "Top" bgcolor= "#FFFFFF" ><?php echo $rs [8]; ></td>
&LT;TD align= "left" valign= "Top" bgcolor= "#FFFFFF" ><?php echo $rs [10]; ></td>
&LT;TD align= "left" valign= "Top" bgcolor= "#FFFFFF" ><?php echo $rs [1]; ></td>
&LT;TD align= "left" valign= "Top" bgcolor= "#FFFFFF" ><?php echo $rs [2]; ></td>
&LT;TD align= "left" valign= "Top" bgcolor= "#FFFFFF" ><?php echo $rs [3]; ></td>
&LT;TD align= "left" valign= "Top" bgcolor= "#FFFFFF" ><?php echo $rs [4]; ></td>
&LT;TD align= "left" valign= "Top" bgcolor= "#FFFFFF" ><?php echo $rs [5]; ></td>
&LT;TD align= "left" valign= "Top" bgcolor= "#FFFFFF" ><?php echo $rs [6]; ></td>
</tr>

<?php
}
}
pagelist ($page, $pagecount, $rdcount, '? page= ', $pagesize);
?>

See the Bold section of the code, PageList function is as follows.

<?php
function PageList ($page, $pagecount, $totalrecord, $url, $pagesize) {
if ($page = = "" | | $page > $pagecount) {exit ();}
Echo ("Record". $totalrecord. " Altogether ". $pagecount." Page per page ". $pagesize." Article <a href= ". $url." 1>&nbsp; home </a>&nbsp; ");
if ($page >1) {echo ("<a href="). $url. ( $page-1). " >&nbsp; prev &nbsp;</a> "); }
if ($page +9> $pagecount) {$current = $pagecount;} else{$current = $page +9;}
for ($i = $page; $i <= $current; $i + +) {echo ("<a href=". $url. "  $i class= ' SF ' > $i </a>); }
if ($pagecount > $page) {echo ("<a href=". $url. ( $page + 1). " >&nbsp; next Page &nbsp;</a> "); }
Echo ("<a href=". $url. $pagecount. " >&nbsp; last </a> ");
}
?>

Original works reproduced please specify: www.111cn.net/phper/php.html