之前做项目的时候,从网上抄的时候,发现几乎所有的例子都是使用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 连接。
?>