【待反馈】小白求助

宝塔用户_pwtvzb · 发表于 2021-3-18 16:09:28

谢花郎发表于 2021-3-18 16:05
这不是显示连接上了吗？状态返回也是200

还想麻烦帮看下后面那个报错...

宝塔用户_pwtvzb · 发表于 2021-3-18 17:20:35

报错信息{"readyState":4,"responseText":"连接成功 \nFatal error: Call to a member function fetch_all() on boolean in /www/wwwroot/1.XX.XXX.XXX/php/love.php on line 11 \n","status":200,"statusText":"OK"}

php代码

<?php
/*
版权信息可删除，但请勿修改
*/
$type = $_REQUEST['type'];
$love_id = $_REQUEST['id'];
include "conn.php";
$sql = "SELECT COUNT(*) FROM love_sentence";//love_sentence为数据表
$result_count = $conn->query($sql);
$love_count_arr = $result_count->fetch_all();
$love_count = $love_count_arr[0][0];
if ($type == "json") {
if($love_id){
$sql2 = "SELECT * FROM love_sentence WHERE id=$love_id";
$result_byId = $conn->query($sql2);
$result_arr_byId = mysqli_fetch_assoc($result_byId);
$return = $result_arr_byId;
$return = json_encode($return);
}else{
$index_rand = mt_rand(0, $love_count);
$sql3 = "SELECT * FROM love_sentence WHERE id=$index_rand";
$result_byRandId = $conn->query($sql3);
$result_arr_byRandId = mysqli_fetch_assoc($result_byRandId);
$return = $result_arr_byRandId;
$return = json_encode($return);
}
}
if ($type == "string" || $type == "") {
if($love_id){
$sql2 = "SELECT * FROM love_sentence WHERE id=$love_id";
$result_byId = $conn->query($sql2);
$result_arr_byId = mysqli_fetch_assoc($result_byId);
$return = $result_arr_byId["data"];
}else{
$index_rand = mt_rand(0, $love_count);
$sql3 = "SELECT * FROM love_sentence WHERE id=$index_rand";
$result_byRandId = $conn->query($sql3);
$result_arr_byRandId = mysqli_fetch_assoc($result_byRandId);
$return = $result_arr_byRandId["data"];
}
}
echo $return;
?>

复制代码

谁能帮我看下哪儿错了嘛

█菠萝云买2送1活动！12G内存99元	A2招租，联系qq394030111	APP分发-无行业限制免审核	香港CN2物理机8核32G，398元/月	【UStat】免费易用的网站分析平台
高防服务器，无视一切流量攻击	【阿里云】宝塔一键部署，低至5折	香港站群金牌Gold 6138大促销	【阿里云】宝塔一键部署，低至5折	OV/EV SSL证书，可当日签发
█ 易探云·香港/美国vps仅9元 █	▶CPS云◀海外大带宽vps服务器	OV/EV SSL证书，可当日签发	【云防护】专注域名和网站安全防护	【UStat】免费易用的网站分析平台