php mysql 下拉_mysql通过php实现下拉框分页

以数据库test里的user表为例:

$host = 'localhost';

$username = 'root';

$password = '';

$dbname = 'test';

// 开始获取数据库连接

$conn = mysql_connect($host, $username, $password);

if (!$conn)

{

die('未能连接数据库： ' . mysql_error());

}

// 手动更改客户端编码

mysql_query("set names utf8");

// 选择使用哪一个数据库

mysql_select_db($dbname);

// 获取总的记录数

$sql_count = "select count(*) from user";

$total_records_result = mysql_query($sql_count);

if ($total_records_result) {

$total_records = mysql_fetch_row($total_records_result);

} else {

echo "";

exit;

}

echo "总的记录数位： ".$total_records[0]."
";

// 获得总页数，一般来说页面大小事固定的，所以这里暂且定为一页5个数据

$page_size = 10;

$total_pages = ceil($total_records[0]/$page_size);

echo "总页数为: ".$total_pages;

// 通过GET方式获得客户端访问的页码

$current_page_number = isset($_GET['page_number'])?$_GET['page_number']:1;

//判断页码越界

if($current_page_number<1) {

$current_page_number =1;

}

if($current_page_number>$total_pages){

$current_page_number = $total_pages;

}

echo "要访问的页码为：".$current_page_number;

// 获取到了要访问的页面以及页面大小，开始分页

$begin_position = ($current_page_number-1)*$page_size;

$sql = "select * from user limit " .$begin_position . "," .$page_size;

$result = mysql_query($sql);

// 处理结果集

echo "

echo "

序号姓名性别";

while(($row = mysql_fetch_assoc($result))){

echo "

";

echo "

".$row['id']."";

echo "

".$row['name']."";

echo "

".$row['sex']."";

echo "

";

}

echo "

";

//下拉框显示页码

echo '

';

echo '跳转到：';

for($i=1;$i<=$total_pages;$i++){

if ($i == $current_page_number) {

echo '第' . $i . '页';

} else {

echo '第' . $i . '页';

}

}

echo '';

echo '

';

if ($current_page_number != 1) {

echo '首页  ';

if ($current_page_number != 2) {

echo '