之前做项目的时候,从网上抄的时候,发现几乎所有的例子都是使用mysql函数,这显然已经是过时了,无法在PHP7得到支持。我改成了MySQLi函数(虽然MySQLi和mysql语法差不多,但底层运行是不一样的)

<?php
header("Content-type:application/json;charset=utf-8");
$con = mysqli_connect("localhost", "root", "123456", "test"); //MySQL配置
$goods= new \stdClass();
// 检查连接
if (!$con) {

die("连接错误: " . mysqli_connect_error());

}
mysqli_select_db($con, "goods");
$result = mysqli_query($con, "SELECT * FROM goods");
if (!$result) {

printf("Error: %s\n", mysqli_error($con));
exit();

}
while ($row = mysqli_fetch_array($result))

{

$goods->ID = $row["ID"];
    $goods->品名 = $row["品名"];
        $goods->价格 = $row["价格"];
            $goods->介绍 = $row["介绍"];
                $goods->图片链接 = $row["图片链接"];
                    $goods->库存 = $row["库存"];
echo json_encode($goods, JSON_UNESCAPED_UNICODE);

}
mysqli_close($con); // 关闭 MySQL 连接。
?>