我在页面上有这个错误,我已经检查了大量的线程,但我不能找出它。
我有一个Sqlite数据库,我正在尝试读取表中的数据。class Construction{
private $conn;
private $table_name = "Site";
public $CNID;
public $CNDESCR;
public $CNADDRESS;
public $CNCITY;
public function __construct($db){
$this->conn = $db;
}
function read(){
$query = "SELECT
c.CNID as CNID, p.CNDESCR, p.CNADDRESS, p.CNCITY
FROM
" . $this->table_name . "";
$stmt = $this->conn->prepare($query);
$stmt->execute();
}
}
然后我有一个文件read.php,我在其中循环并打印所有数据$site = Construction($db);
$stmt = $site ->read();
$num = $stmt->rowCount();
if($num>0){
$construction_site=array();
$construction_site["records"]=array();
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
extract($row);
$site_item=array(
"id" => $CNID,
"description" => $CNDESCR,
"address" => $CNADDRESS,
"city" => $CNCITY,
)
array_push($construction_site["records"], $site_item);
}
http_response_code(200);
echo json_encode($construction_site);
}