将一个项目放入 MySQL 数据库时遇到问题


Trouble getting one item into MySQL db

我遇到了一个令人困惑的问题 - 我设法从文本框中提取了一个值,成功插入到我的表中,但另一个(也来自文本框)没有进入。在 AJAX 调用之前,我已经提醒了我的数据字符串,以确保这两个值都正确,而且它们都是正确的。但是,当我查看数据库时,只输入了名称值,电子邮件为空。

.HTML:

<div id="basic-modal-content">
    <h3>Please Alert me when this is Available</h3>

    <p>Your Name: <input type="text" id="alert_name"/></p>
    <p>Email Address: <input type="text" id="alert_email"/></p>
    <button id="alert_submit">Submit</button>
</div>

Javascript:

$('#alert_submit').click(function(){
    var datastring = 'name='+ $('#alert_name').val() + '&email=' + $('#alert_email').val();
    alert(datastring);
        $.ajax({  
          type: "POST",  
          url: "process_email.php",  
          data: datastring,  
          success: function(data) {  
          }  
        });  
      alert ("We've received your request and will alert you once the directory is available. Thank you.");
      $.modal.close();
});

.PHP:

$name = $_POST['name'];
$email = $_POST['email'];
try {
        $conn = new PDO('mysql:host=blah;dbname=blah', '-', '-');
        $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);  
        $stmt = $conn->prepare("INSERT INTO email_alerts(name, email) VALUES(':name, :email)");
        $stmt->execute(array('name' => $name, 'email' => $email));
        //$affected_rows = $stmt->rowCount();
        $conn = null;
} catch(PDOException $e) {
    echo 'ERROR: ' . $e->getMessage();
    $conn = null;
}

请尝试此代码

$('#alert_submit').click(function(){
            $.ajax({  
              type: "POST",  
              url: "process_email.php?name="+$('#alert_name').val() +"&email="+ $('#alert_email').val(),  
              success: function(data) {  
              }  
            });  
          alert ("We've received your request and will alert you once the directory is available. Thank you.");
          $.modal.close();
    });