插入 MySQL 不起作用

Question

>我正在尝试使用 PHP 将数据放入 MySQL 中，但没有显示任何错误，但值也没有输入到数据库中。

$query = "INSERT INTO orders (username, servicename, link, quantity, cost, date)
          VALUES('$username', '$service_name', '$link', '$quanitiy', '$cost', '$date')";
$insert=mysqli_query($db, $query);

Answer 1

我认为

您的查询应该看起来像这样：

$conn = mysqli_connect($servername, $username, $password, $database);
// Check connection
if (!$conn) {
  die("Connection failed: " . mysqli_connect_error());
}
// create the query
$query = "INSERT INTO orders (username, servicename, link, quantity, cost, date)
          VALUES('$username', '$service_name', '$link', '$quanitiy','$cost', '$date')";
// preform the query
$insert=mysqli_query($conn, $query);
// you need to check if the insert succeeded before closing the connection
// close connection to DB
mysqli_close($conn);