php - “可捕获的 fatal error :类mysqli_result的对象……”-无法通过fetch_assoc进行修复

Question

完整的错误消息：

 Catchable fatal error: Object of class mysqli_result could not be converted to string in C:\wamp\www\profile_page.php on line 373

在我的网站上实现无限滚动功能时出现此错误。我不能（或找不到方法）实现 mysqli_fetch_assoc来获取结果，因为与此建议相关的其他答案很多。

这是完整的代码，可以解释原因：

$limit = 10;

$page = (int) (!isset($_GET['p'])) ? 1 : $_GET['p'];
# sql query
$get_thoughts_from_db = mysqli_query($connect, 
    "SELECT * FROM user_thoughts WHERE added_by='$user' AND shared ='yes' ORDER BY id DESC");
# find out query start point
$start = ($page * $limit) - $limit;
# query for page navigation
if(mysqli_num_rows($get_thoughts_from_db) > ($page * $limit) ){
    $next = ++$page;
}

$query = mysqli_query($connect, $get_thoughts_from_db . " LIMIT {$start}, {$limit}");
if (mysqli_num_rows($query) < 1) {
    header('HTTP/1.0 404 Not Found');
    echo 'Page not found!';
    exit();
}

在此行中引起错误（行373）：

$query = mysqli_query($connect, $get_thoughts_from_db . " LIMIT {$start}, {$limit}");

Answer 1

您保存到$get_thoughts_from_db mysqli_query结果：

$get_thoughts_from_db = mysqli_query($connect, 
    "SELECT * FROM user_thoughts WHERE added_by='$user' AND shared ='yes' ORDER BY id DESC");

然后将其与字符串连接：

$query = mysqli_query($connect, $get_thoughts_from_db . " LIMIT {$start}, {$limit}");

也许您想运行以下查询：

$query = mysqli_query($connect, 
    "SELECT * FROM user_thoughts WHERE added_by='$user' AND shared ='yes' ".
    "ORDER BY id DESC LIMIT {$start}, {$limit}");