Copy code The code is as follows:
Poll results
The user left a message as follows:
Copy code Code As follows:
$link = mysql_connect('localhost', 'root', '') or die(mysql_error());
mysql_select_db('vote' , $link) or die(mysql_error());
mysql_query("set names utf8");
$num = 3;
$url = "page.php";
$con = "
";
$page = (isset($_REQUEST['page'])) ? $_REQUEST['page'] : 1;
$offset = ($ page - 1) * $num;
$result = mysql_query("SELECT COUNT(*) FROM client");
$total = mysql_fetch_row($result);
$total = $total[0] ;
$pagenum = ceil($total / $num);
$page = min($pagenum, $page); //Get the home page
$prepg = $page - 1; //Previous Page
if ($prepg <= 1)
$prepg = 1;
$nextpg = ($page == $pagenum ? 1 : $page + 1); //Next page
//If there is only one page, jump out of the function:
if ($pagenum <= 1)
return false;
$sql = "SELECT `name`,`content` FROM `client` LIMIT " . $offset . "," . $num;
$res = mysql_query($sql);
while ($content = mysql_fetch_row($res)) {
$con .= "- $content[0]: $content[1]
";
}
$con .= "
";
$ con .= <<< PAGE
Home|Previous page| Next page|Last page
PAGE;
echo $con;
?> ;
http://www.bkjia.com/PHPjc/322244.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/322244.htmlTechArticleCopy the code as follows: !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd" html head title voting results/title meta http-equiv="c...