mysql 查询 分页显示_php mysql查询结果分页显示

$mysql_server_name="localhost";

$mysql_username='root';

$mysql_password='';

$mysql_database='hp';

$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password);

@mysql_connect("localhost","root","") or die("数据库连接失败");

@mysql_select_db("hp") or die("数据库不存在");

mysql_query("set names utf8");

if($_POST['submit']){

$strsql="select * from zichan where 1=1 ";

$strsql .=$_POST['idc'] ? " and idc='$_POST[idc]' ":"";

$strsql .=$_POST['jiguihao'] ? " and jiguihao='$_POST[jiguihao]' ":"";

$strsql .=$_POST['neicun'] ? " and neicun='$_POST[neicun]' ":"";

$strsql .=$_POST['yingpan'] ? " and yingpan='$_POST[yingpan]' ":"";

$strsql .=$_POST['xinghao'] ? " and xinghao='$_POST[xinghao]' ":"";

$strsql .=$_POST['cpu'] ? " and cpu='$_POST[cpu]' ":"";

$strsql .=$_POST['guishu'] ? " and guishu='$_POST[guishu]' ":"";

$strsql .=$_POST['ip'] ? " and ip='$_POST[ip]' ":"";

}

$result=mysql_db_query($mysql_database,$strsql,$conn);

$row=mysql_fetch_row($result);

echo '';

echo '

// 显示字段名称

echo "

for ($i=0; $i

{

echo '

mysql_field_name($result, $i);

echo "

}

echo "

// 定位到第一条记录

mysql_data_seek($result, 0);

// 循环取出记录

while ($row=mysql_fetch_row($result))

{

echo "

for ($i=0; $i

{

echo '

echo $row[$i];

echo '

}

echo '

echo '

echo '

echo '

echo "

}

echo "

echo "";

// 释放资源

mysql_free_result($result);

// 关闭连接

mysql_close($conn);

?>

本页已经可以正常查询出所有结果，就是不能分页，请高人修改下，要求是我复制代码回去什么都不用修改，就能分页显示，谢谢···

展开