php - 使用 PHP 连接 MySQL 数据库

Question

任何人都可以帮我解决这个问题，这个 php 代码有什么问题吗？

根据“http://phpcodechecker.com/”:

解析错误:语法错误，第 7 行代码中出现意外的“$response”(T_VARIABLE)
$response["产品"] = array();

get_all_products.php

<?php
$response = array();
require_once __DIR__ . '/db_connect.php';
$db = new DB_CONNECT();
$result = mysql_query("SELECT *FROM products") or die(mysql_error());
if (mysql_num_rows($result) > 0) {
    $response["products"] = array();
 
    while ($row = mysql_fetch_array($result)){
        $product = array();
        $product["pid"] = $row["pid"];
        $product["name"] = $row["name"];
        $product["price"] = $row["price"];
        $product["created_at"] = $row["created_at"];
        $product["updated_at"] = $row["updated_at"];
        array_push($response["products"], $product);
    }
    // success
    $response["success"] = 1;
    echo json_encode($response);
} else {
    // no products found
    $response["success"] = 0;
    $response["message"] = "No products found";
    echo json_encode($response);
}
?>

Answer 1

http://ua2.php.net/mysql_query

尝试这样的事情:

$db = new DB_CONNECT();
$result = mysql_query("SELECT * FROM products", $db);