表单未提交到数据库[已关闭]

Question

因此，当我在表单上输入信息后，它会用新表单刷新new.php页面，但不会提交任何信息。我没有错误，就像我在页面上点击刷新一样。我觉得我做的一切都是对的，但我似乎不明白为什么这不起作用。我刚刚从mysql过渡到mysqli，所以我有点像新手。它也没有回到home.php.

new.php

<?php include_once('header.php'); ?>
<?php include_once('config/db.php'); ?>




<div id="newform">
    <form role="form">
        <div class="form-group">
            <label for="user">User</label>
            <input type="text" class="form-control" id="user" placeholder="Username"> 
        </div>
        <div class="form-group">
            <label for="rank">Rank</label>
            <select class="form-control" name="rank">
                <option value="1">Noob</option>
                <option value="2">Semi-Noob</option>
            </select>
        </div>
        <div class="form-group">
            <label for="date">Date</label>
            <input type="text" class="form-control" id="date" placeholder="<?php echo date('d M y'); ?>">
        </div>
        <div class="form-group">
            <label for="tag">Tag</label>
            <input type="text" class="form-control" id="tag" placeholder="Tag">
        </div>      
        <center>
        <button type="submit" class="btn btn-default">Submit</button>
        </center>
    </form>
</div>

<?php
if(isset($_POST['submit'])){
//Values to be inserted into the DB
$user = $_POST['user'];
$rank = $_POST['rank'];
$date = $_POST['date'];
$tag  = $_POST['tag'];

//Preparing the statement
$query = "INSERT INTO players (user, rank, date, tag) VALUES(?, ?, ?)";
$statement = $mysqli->prepare($query);

//Binding Parameters for markers, where (s = string, i = integer, d = double, b = blob)
$statement->bind_param('siss', $user, $rank, $date, $tag);

//Execution
if($statement->execute()){
    header('Location: home.php');
}else{
    die('Error : ('.$mysqli->errno .') '. $mysqli->error);
}
$statement->close();
}
?>

<?php include_once('footer.php'); ?>

Answer 1

在中添加name="提交"后检查

<button type="submit" class="btn btn-default" name="submit">Submit</button>