我用他的php mysql做错了什么 - What am I doing wrong with his php mysql

What am I doing wrong with his php mysql

本文关键字：错了什么 mysql php | 更新日期: 2023-09-27

我的目的是在我的网站上放一个表格，其中包含一些来自datbase的字段，其中包含一个ID

$con = mysqli_connect('hostname','username','password','dbname');
if (!$con) {
    die('Could not connect: ' . mysqli_error($con));
}

$sql="SELECT * FROM Orders WHERE `Student UID` = '".$id."'";
$result = mysqli_query($con,$sql);
echo 
echo "<table><tr><th>Product</th><th>Cost</th></tr>";
while($row = mysqli_fetch_array($result)) {
    echo "<tr>";
    echo "<td>" . $row['MenuItemName'] . "</td>";
    echo "<td>" . $row['Price'] . "</td>";

    echo "</tr>";
}
echo "</table>";

在我运行这个的那一刻，我正在得到这样的桌子

+---------+-------+
| Product | Price |
+---------+-------+

我的数据库看起来像这样

+--------------+-------+-------------+
| MenuItemName | Price | Student UID |
+--------------+-------+-------------+
| Foo          |    99 |       12345 |
| Foo2         |    11 |       11111 |
| Foo2         |    11 |       12345 |
+--------------+-------+-------------+

我做错了什么？

尝试更改此行：

$sql="SELECT * FROM Orders WHERE 'Student UID' = '".$id."'";

自：

$sql="SELECT * FROM Orders WHERE `Student UID` = '".$id."'";

大喊解决您的问题。