<?php
function db_connect()
{
$db=@new mysqli("localhost","root","900111","test");
if(mysqli_connect_error())
{
echo '数据库连接失败!<br>';
echo mysqli_connect_error();
exit;
}
return $db;
$db->close();
}$db=db_connect();
$sql="select*from test";
$conn=$db->query($sql);
$num=$conn->num_rows;
echo $num;$pagesize=5;
$pagetal=ceil($num/$pagesize);if($_GET[page])
{
$pagetal=$_GET[page];
$page=($pagetal-1)*$pagesize;
}$sql="select*from test limit $page,$pagesize";
$conn=$db->query($sql);
while($row=mysql_fetch_array($conn,MYSQL_ASSOC))
{
echo $row['name'].$row['sex'];
}
echo "共".$num."条"."<a href=12.php?page=".($pagetal-1).">上一页</a><a href=12.php?page=".($pagetal+1).">下一页</a>";
?>
2
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in F:\AppServ\www\PHP100_13\12.php on line 22
共2条上一页下一页
好像数据库跟表都没错啊。。
function db_connect()
{
$db=@new mysqli("localhost","root","900111","test");
if(mysqli_connect_error())
{
echo '数据库连接失败!<br>';
echo mysqli_connect_error();
exit;
}
return $db;
$db->close();
}$db=db_connect();
$sql="select*from test";
$conn=$db->query($sql);
$num=$conn->num_rows;
echo $num;$pagesize=5;
$pagetal=ceil($num/$pagesize);if($_GET[page])
{
$pagetal=$_GET[page];
$page=($pagetal-1)*$pagesize;
}$sql="select*from test limit $page,$pagesize";
$conn=$db->query($sql);
while($row=mysql_fetch_array($conn,MYSQL_ASSOC))
{
echo $row['name'].$row['sex'];
}
echo "共".$num."条"."<a href=12.php?page=".($pagetal-1).">上一页</a><a href=12.php?page=".($pagetal+1).">下一页</a>";
?>
2
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in F:\AppServ\www\PHP100_13\12.php on line 22
共2条上一页下一页
好像数据库跟表都没错啊。。
//因为你的才用的是mysqli链接的数据库要用对应的mysqli类库
//对了·之前的应该是,这个是过程化的方式获取
while($row=mysqli_fetch_array($conn, MYSQLI_ASSOC))