PHP-成功插入但没有数据库条目

我正在尝试将表单中的值提交到数据库中。PHP返回查询成功,但没有数据库条目。我已经尝试打印提交的查询并将其复制到MySQL工作台,查询会按预期运行并插入数据。

HTML格式:

<form action="queries/insertData.php" method="post">
  First name:<br>
  <select id="name" name="name">
  <?php 
    $sql = mysqli_query($link, "SELECT * FROM users");
    while ($row = $sql->fetch_assoc()){
      echo "<option value=". $row['name'] .">" . $row['name'] . "</option>";
    }
  ?>
  </select>
  <br><br>
  Step Number:<br>
  <input type="text" id="stepCount" name="stepCountAmount" value="">
  <br><br>
  Date:<br>
  <input type="date" id="stepCountDate" name="date" value="">
  <br><br>
  <input type="submit">
</form>

插入数据.php

<?php
  require '../database.php';
  $query = "INSERT INTO stepcount (userID, stepNumber, countDate)
  VALUES ('".$_POST["name"]."','".$_POST["stepCountAmount"]."','".$_POST["date"]."')";
    if($query) {
      echo "Query was successful ";
      echo $query;
    }
    else {
      echo "Query Unsuccessful";
    }
  mysqli_close($link);
?>

这个 echo 'd out查询:

 INSERT INTO stepcount (userID, stepNumber, countDate) VALUES ('Three','100','2018-10-01')