php - 无法将表单中的数据插入mysql

Question

谁能解释为什么这个插件不起作用？

if(isset($_POST['send'])){
    $query = 'INSERT INTO subsciber(data, ip, email) 
          VALUES(CURRENT_TIMESTAMP, "'.$_SERVER['REMOTE_ADDR'].'", "'.$_POST['email'].'")';
    $result =  @mysqli_query($dbc, $query);
}

表单代码如下所示:

<div class="row">
     <div class="col-md-4 col-md-offset-4 col-sm6-6 col-sm-offset-3 ">
         <form class="form-inline" role="form" method="post">
            <div class="form-group">
                <label class="sr-only" for="exampleInputEmail2">Email address</label>
                <input name='email' id="email" type="email" class="form-control transparent" placeholder="Your email here...">
            </div>
            <button type="submit" name='send' value='send' class="btn btn-danger btn-fill">Notify Me</button>
        </form>
    </div>
</div>

Answer 1

你应该包括 mysqli error function 来查看你的错误

    if(isset($_POST['send'])){
        $query = 'INSERT INTO subsciber(data, ip, email) 
              VALUES(CURRENT_TIMESTAMP, "'.$_SERVER['REMOTE_ADDR'].'", "'.$_POST['email'].'")';
//echo $query; to see query output
        $result =  mysqli_query($dbc, $query) or die(mysqli_error($dbc));
    }

此外，data 是 mysqli keyword，因此请在其周围使用 backtick

 $query = 'INSERT INTO subsciber(`data`, ip, email) 
                  VALUES(CURRENT_TIMESTAMP, "'.$_SERVER['REMOTE_ADDR'].'", "'.$_POST['email'].'")';