javascript - 在 PHP 中访问 Ajax 发送的 POST 值

Question

我正在使用 Ajax 从表单获取 POST 值。但是，当我尝试在提交时将表单值插入数据库时​​，它不会被插入。我仍然不知道为什么它不起作用。

这是我的 HTML

<form method="post" action="" id="home-sign-up-form">
    <input type="text" name="suFirstName" placeholder="First Name" class="text-input-minor" id="sign-up-first-name-text-input">
    <input type="text" name="suLastName" placeholder="Last Name" class="text-input-minor" id="sign-up-last-name-text-input">
    <input type="text" name="suEmail" placeholder="Email" class="text-input-minor" id="sign-up-email-text-input">
    <input type="password" name="suPassword" placeholder="Password" class="text-input-minor" id="sign-up-password-text-input">
    <input type="password" name="suConfirmPassword" placeholder="Confirm Password" class="text-input-minor" id="sign-up-confirm-password-text-input">
    <input type="text" name="suDisplayName" placeholder="Display Name (you can change this later)" class="text-input-minor" id="sign-up-display-name-text-input">
    <br><font class="text-error" id="sign-up-error-text"></font><br>
    <label><input type="checkbox" name="suRememberMe" value="yes" id="sign-up-remember-me-checkbox"><font id="sign-up-remember-me-text">Remember me</font></label>
    <input name="signUp" type="submit" value="Sign Up" id="sign-up-submit">
</form>

我的 JS(第一个 console.log 确实通过并工作):

if (validForm)
{
    console.log("valid form");
    console.log(JSON.stringify($('#home-sign-up-form')[0].seriaize()));
    $.ajax(
    {
        type:'POST',
        url:'form-submit.php',
        data:$('#home-sign-up-form')[0].serialize(),
        success:function(response)
        {
            $suForm.hide();
            $tosppText.hide();
            $mailSentIcon.show();
            $emailSentText.show();
            $emailSentTextEmail.text($suEmail);
            $suBox.css("padding-left", "10px");
            $suBox.css("padding-right", "10px");
        }
    });     
}

还有我的 PHP/MySQL:

<?php require 'dbconnect.php'; ?>
if (isset($_POST['suEmail']))
{
    echo "<script type='text/javascript'>alert('got');</script>";
    $suFirstName = mysqli_real_escape_string($_POST['suFirstName']); 
    $suLastName = mysqli_real_escape_string($_POST['suLastName']); 
    $suEmail = mysqli_real_escape_string($_POST['suEmail']); 
    $suPassword = mysqli_real_escape_string($_POST['suPassword']);
    $suDisplayName = mysqli_real_escape_string($_POST['suDisplayName']);
    $code = substr(md5(mt_rand()),0,15);

    $query = $connection->query("INSERT INTO users (firstName,lastName,email,password,displayName,confirmCode,verified)Values('{$suFirstName}','{$suLastName}','{$suEmail}','{$suPassword}','{$suDisplayName}','{$confirmCode},'{$verified}')");
}

PHP 代码中的警报，因此我假设它没有获取“signUp”POST 变量。非常感谢!任何帮助表示赞赏! :D

Answer 1

$("#home-sign-up-form").submit(function(event) {
  alert("Handler for .submit() called.");
  event.preventDefault();
  $.ajax({
    type: 'POST',
    url: 'form-submit.php',
    data: $('#home-sign-up-form').serialize(),
    success: function(response) {
      console.log(response);
      var data = JSON.parse(response);
      $suForm.hide();
      $tosppText.hide();
      $mailSentIcon.show();
      $emailSentText.show();
      //$emailSentTextEmail.text($suEmail);
      $emailSentTextEmail.text(data.suEmail);
      $suBox.css("padding-left", "10px");
      $suBox.css("padding-right", "10px");
    }
  });
});

<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
<form method="post" action="" id="home-sign-up-form">
  <input type="text" name="suFirstName" placeholder="First Name" class="text-input-minor" id="sign-up-first-name-text-input">
  <input type="text" name="suLastName" placeholder="Last Name" class="text-input-minor" id="sign-up-last-name-text-input">
  <input type="text" name="suEmail" placeholder="Email" class="text-input-minor" id="sign-up-email-text-input">
  <input type="password" name="suPassword" placeholder="Password" class="text-input-minor" id="sign-up-password-text-input">
  <input type="password" name="suConfirmPassword" placeholder="Confirm Password" class="text-input-minor" id="sign-up-confirm-password-text-input">
  <input type="text" name="suDisplayName" placeholder="Display Name (you can change this later)" class="text-input-minor" id="sign-up-display-name-text-input">
  <br><font class="text-error" id="sign-up-error-text"></font>
  <br>
  <label>
    <input type="checkbox" name="suRememberMe" value="yes" id="sign-up-remember-me-checkbox"><font id="sign-up-remember-me-text">Remember me</font>
  </label>
  <input name="signUp" type="submit" value="Sign Up" id="sign-up-submit">
</form>

<?php
if (isset($_POST['suEmail']))
{
  $con=mysqli_connect("localhost","root","cakpep","backoffice");

  // Check connection
  if (mysqli_connect_errno()) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
    $suFirstName = mysqli_real_escape_string($con,$_POST['suFirstName']);
    $suLastName = mysqli_real_escape_string($con,$_POST['suLastName']);
    $suEmail = mysqli_real_escape_string($con,$_POST['suEmail']);
    $suPassword = mysqli_real_escape_string($con,$_POST['suPassword']);
    $suDisplayName = mysqli_real_escape_string($con,$_POST['suDisplayName']);
    $code = substr(md5(mt_rand()),0,15);

    $query = $connection->query("INSERT INTO users (firstName,lastName,email,password,displayName,confirmCode,verified)Values('{$suFirstName}','{$suLastName}','{$suEmail}','{$suPassword}','{$suDisplayName}','{$confirmCode},'{$verified}')");
    echo json_encode($_POST);
}
?>

• 将此添加到提交表单时触发$("#home-sign-up-form").submit(function(event) {

• 然后在 php 上返回带有 json 字符串的响应回显 json_encode($_POST);

• 然后在响应中ajax将json文本解析为对象，如下所示var data = JSON.parse(response);$emailSentTextEmail.text(data.suEmail);
• 我希望这是你想要的..