当前位置:Gxlcms >
PHP教程 >
:mysql_fetch_row():suppliedargumentisnotavalidMySQLresultresource
:mysql_fetch_row():suppliedargumentisnotavalidMySQLresultresource
时间:2021-07-01 10:21:17
帮助过:8人阅读
求救:mysql_fetch_row(): supplied argument is not a valid MySQL result resource
function db_connect()
{
$result = new mysqli('localhost', 'root', '654321', 'smsprj');
//$result = new mysqli('localhost', 'root', '654321');
if (!$result)
{
throw new Exception('Could not connect to database server');
}
else
{
return $result;
}
}
?>
$conn = db_connect();
$sql = $conn->query("SELECT * FROM user");
if (!$sql)
{
echo ("wrong");
}
else
{
echo "
";
echo "userid | name | pssword | maxsmscount | maxuseday | leftday | leftsmscount |
";
while( $row = mysql_fetch_row($sql) )
{
echo "$row[0] | $row[1] | $row[2] | $row[3] | $row[4] | $row[5] | $row[6] |
";
}
}
我的目的是将数据库中的所有用户信息显示出来
可这段程序老是报错,不知道什么原因
求大侠帮助,小弟不胜感激
mysql_fetch_row
分享到:
------解决方案--------------------
db_connect 中是这样的
$result = new mysqli('localhost', 'root', '654321', 'smsprj');
所以要这样查询
$sql = $conn->query("SELECT * FROM user");
要这样读取
while( $row = $sql->fetch_row())
人气教程排行