我在一个PHP文件中总共有三个函数。我的第一项功能运行良好。第二个和第三个函数只是表名不同,其他都可以。当我运行第二个或第三个函数时,它会给我错误,就像下面的一样
Uncaught Error: Call to a member function fetch_row() on boolean in
我在最后两个函数的每一行下面都有错误。
while($row = $result->fetch_row()) {
我已经测试了phpmyadmin中的所有查询,它运行良好,没有任何问题。
我的完整PHP文件如下
<?php
require_once("includes/conf.php");
function getAllNumbers() {
global $conn;
$sql = "SELECT number from number_list WHERE server=1";
$result = $conn->query($sql);
$data = array();
if($result) {
while($row = $result->fetch_row()) {
array_push($data, $row[0]);
}
}
$response["data"] = $data;
return $response;
}
function getNewNumbers() {
global $conn;
$sql = "SELECT number, id from new_numbers WHERE server = 1";
$result = $conn->query($sql);
$newData = array();
if($result) {
while($row = $result->fetch_row()) {
array_push($newData, $row[0]);
$id = $row[1];
$delete = "DELETE number from new_numbers WHERE id = $id";
$result = $conn->query($delete);
}
}
$response["newData"] = $newData;
return $response;
}
function getDeleteNumbers() {
global $conn;
$sql = "SELECT number, id from delete_numbers WHERE server = 1";
$result = $conn->query($sql);
$deleteData = array();
if($result) {
while($row = $result->fetch_row()) {
array_push($deleteData, $row[0]);
$id = $row[1];
$delete = "DELETE number from delete_numbers WHERE id = $id";
$result = $conn->query($delete);
}
}
$response["deleteData"] = $deleteData;
return $response;
}
?>
表号列表
id int(11) NO PRI NULL auto_increment
name varchar(50) NO NULL
number varchar(50) NO NULL
server int(10) NO 0
status int(1) NO -1
last_act timestamp NO CURRENT_TIMESTAMP
user_id int(11) NO MUL NULL
created_at timestamp NO CURRENT_TIMESTAMP
disable int(11) NO 0
notify int(1) NO 1
fcm varchar(500) NO NULL
表新编号
id int(11) NO PRI NULL auto_increment
number varchar(50) NO NULL
server int(10) NO 0
表格删除编号
id int(11) NO PRI NULL auto_increment
number varchar(50) NO NULL
server int(10) NO 0
我应该清楚的是,我每隔xx分钟就会从我的基于套接字连接的PHP文件中调用这些函数,我一直在命令行中全天候运行该文件。我认为应该要求一次。如果有人能给我解决问题的提示,请告诉我。感谢
错误表示fetch_row正在获取布尔值以执行操作。更改Sql查询。
function getAllNumbers() {
global $conn;
$sql = "SELECT number from number_list WHERE server='1'";
$result = $conn->query($sql);
$data = array();
if($result) {
while($row = $result->fetch_row()) {
array_push($data, $row[0]);
}
}
$response["data"] = $data;
return $response;
}
function getNewNumbers() {
global $conn;
$sql = "SELECT number, id from new_numbers WHERE server = '1'";
$result = $conn->query($sql);
$newData = array();
if($result) {
while($row = $result->fetch_row()) {
array_push($newData, $row[0]);
$id = $row[1];
$delete = "DELETE number from new_numbers WHERE id = '$id'";
$result = $conn->query($delete);
}
}
$response["newData"] = $newData;
return $response;
}
function getDeleteNumbers() {
global $conn;
$sql = "SELECT number, id from delete_numbers WHERE server = '1'";
$result = $conn->query($sql);
$deleteData = array();
if($result) {
while($row = $result->fetch_row()) {
array_push($deleteData, $row[0]);
$id = $row[1];
$delete = "DELETE number from delete_numbers WHERE id = '$id'";
$result = $conn->query($delete);
}
}
$response["deleteData"] = $deleteData;
return $response;
}
此外,这种方法是对Sql注入的公开邀请。你应该使用准备好的报表
这是错误
$result=$conn->query($delete(;
用这个代替
<?php
require_once("includes/conf.php");
function getAllNumbers() {
global $conn;
$sql = "SELECT number from number_list WHERE server=1";
$result = $conn->query($sql);
$data = array();
if($result) {
while($row = $result->fetch_row()) {
array_push($data, $row[0]);
}
}
$response["data"] = $data;
return $response;
}
function getNewNumbers() {
global $conn;
$sql = "SELECT number, id from new_numbers WHERE server = 1";
$result = $conn->query($sql);
$newData = array();
if($result) {
while($row = $result->fetch_row()) {
array_push($newData, $row[0]);
$id = $row[1];
$delete = "DELETE number from new_numbers WHERE id = $id";
$deleted = $conn->query($delete);
}
}
$response["newData"] = $newData;
return $response;
}
function getDeleteNumbers() {
global $conn;
$sql = "SELECT number, id from delete_numbers WHERE server = 1";
$result = $conn->query($sql);
$deleteData = array();
if($result) {
while($row = $result->fetch_row()) {
array_push($deleteData, $row[0]);
$id = $row[1];
$delete = "DELETE number from delete_numbers WHERE id = $id";
$deleted = $conn->query($delete);
}
}
$response["deleteData"] = $deleteData;
return $response;
}
?>