php - fatal error : Call to a member function fetch_array() on a non-object

Question

如何更改此代码以免收到上述错误？

这是完整的错误:

Fatal error: Call to a member function fetch_array() on a non-object in /home/bestc165/public_html/opinuo.com/stream.php on line 10

<?php 
$link = mysqli_connect('localhost', 'bestc165_opinuo', 'opinuo');

$sql_string = 'SELECT * FROM debates LIMIT 2  order by ts ';

$result = mysqli_query($link,$sql_string );

while($row = $result->fetch_array())
{
    $rows[] = $row;
}

foreach($rows as $row)
{
    $name =  $row['name'];
    $text =  $row['text'];
?>

<h2><?php echo $name;?></h2>
<p><?php echo $text;?></p>

<?php

}

?>

Answer 1

LIMIT 位于 ORDER BY

之后

将您的查询更改为

$sql_string = 'SELECT * FROM debates ORDER BY ts LIMIT 2';

mysqli_query 在失败时返回 FALSE，因此您的 $result 不是一个对象，而是一个 boolean 因此您的错误.

更新

如评论中所述，请确保在连接中传递数据库名称

$link = mysqli_connect('host', 'username', 'password', 'databaseName');

或者使用mysqli_select_db

mysqli_select_db($link, "databaseName");