PHP MySQL插入到表中 - PHP MySQL Insert into table

我遵循了一个关于确切代码的教程，但我似乎无法让它在中工作

当我提交表格时，没有任何东西被放入我的表格

我似乎找不到问题，我换了很多东西，但似乎找不出答案。

如果有人能看看我的代码并帮助我解决问题，我将非常感谢

代码

<form class="form" method="post" action="index.php">
            <h2>
              Post new account...
            </h2>
              <div class="form-group">
                <label for="title">Title</label>
                <input required type="text" class="form-control" name="title"  placeholder="Enter a title for the account...">
              </div>
              <div class="form-group">
                <div class="row">
                  <div class="col-md-6">
                    <label for="server">Server</label>
                    <input required type="text" class="form-control" name="server"  placeholder="Enter Server...">
                  </div>
                   <div class="col-md-6">
                      <label for="price">Price</label>
                      <input required type="number" class="form-control" name="price"  placeholder="Enter Price...">
                   </div>  
                </div>
              </div>
              <div class="form-group">  
              <div class="row">
                  <div class="col-md-6">
                    <label for="Energy">Energy</label>
                    <input required type="number" class="form-control" name="energy"  placeholder="Enter Energy...">
                  </div>
                   <div class="col-md-6">
                      <label for="Stamina">Stamina</label>
                      <input required type="number" class="form-control" name="stamina"  placeholder="Enter Stamina...">
                   </div>  
                </div>
              </div>
              <div class="form-group">  
              <div class="row">
                  <div class="col-md-6">
                    <label for="Jewels">Jewels</label>
                    <input required type="number" class="form-control" name="jewels" placeholder="Enter Jewels...">
                  </div>
                   <div class="col-md-6">
                      <label for="honor">Stamina</label>
                      <input required type="number" class="form-control" name="honor" placeholder="Enter Honor...">
                   </div>  
                </div>
              </div>
              <div class="form-group">
                <label for="image">Image URL</label>
                <input required type="text" class="form-control" name="image" placeholder="Enter the image link...">
              </div>
              <div class="form-group">
                <label for="link">Link URL</label>
                <input required type="text" class="form-control" name="link" placeholder="Enter the payment link...">
              </div>
              <div class="form-group">
                <input class="btn btn-primary btn-md" type="submit" name="submit">
              </div>
          </form>
<?php
if (isset($_POST['submit'])) {     
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("We're having problems at the moment, please come back later!");
} 
$query = "INSERT INTO accounts (title,price,energy,stamina,jewels,honor,damage,server,image,link) VALUES ('$_POST[title]','$_POST[price]','$_POST[energy]','$_POST[stamina]','$_POST[jewels]','$_POST[honor]','$_POST[damage]','$_POST[server]','$_POST[image]','$_POST[link]')";
mysql_query($query,$conn);
mysql_close($conn);
};
?>

检查您的连接：

if (!$conn) {
   die("Connection failed: " . mysqli_connect_error());
}

然后检查它是否正在插入数据库。如果有错误，它也会让你知道。

if (mysqli_query($conn, $sql)) {
   echo "New record created successfully";
} else {
   echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}

另外，不要把mysql_和mysqli_混在一起。开始使用mysqli_而不是mysql_。mysql已被弃用。