XAMPP环境下ajax/jQuery传递HTML表单值到PHP及MySQL的问题

Alright, let's walk through what you've confirmed so far and zero in on why your post() function is executing but not working as expected:

Confirmed Working Components #

• Your XAMPP setup is solid: Apache and MySQL services are running without issues
• You’ve got proven experience with similar code, so core logic isn’t the problem
• Database writes work when accessing the PHP file directly — meaning your PHP-MySQL connection and insert logic are valid
• Frontend data capture works: You can pull input values via the JS console, so no issues grabbing user input

Targeted Troubleshooting Steps #

1. Verify Post Request Parameter Matching

• Open your browser's DevTools (Network tab), trigger the post() function, and check the Form Data/Payload of the request:
  • Ensure the parameter names (e.g., firstname, lastname) exactly match what your PHP script expects (case-sensitive! FirstName ≠ firstname)
  • Since your scm table uses int types for firstname and lastname, confirm the values being sent are numbers. If your inputs are text fields, convert them to numbers in JS (e.g., Number(input.value)) or sanitize in PHP with intval().

2. Audit Your post() Function Implementation

• Native JS (fetch/XHR): Double-check the request headers. If sending form data, set Content-Type: application/x-www-form-urlencoded to match how PHP parses $_POST.
• jQuery $.post: Add an error callback to catch hidden issues:

  $.post('your-script.php', { firstname: fnVal, lastname: lnVal })
    .done(function(response) { console.log('Success:', response); })
    .fail(function(jqXHR, textStatus, errorThrown) { console.error('Error:', errorThrown); });
  

• Confirm the request URL is correct (relative paths can trip you up — e.g., using ./script.php instead of /folder/script.php if your page is in a subdirectory).

3. Add Debug Logs to Your PHP Script

• Log incoming POST data and database errors to pinpoint where things break. Add this to your PHP handler:

  // Log POST data to Apache error log
  error_log('Received POST data: ' . print_r($_POST, true));
  
  // Connect to DB with error handling
  $conn = mysqli_connect('localhost', 'root', '', 'your-db-name');
  if (!$conn) {
      error_log('DB Connection Failed: ' . mysqli_connect_error());
      echo 'Connection error: ' . mysqli_connect_error();
      exit;
  }
  
  // Use prepared statements to avoid SQL injection and catch errors
  $stmt = $conn->prepare('INSERT INTO scm (firstname, lastname) VALUES (?, ?)');
  $stmt->bind_param('ii', $fn, $ln);
  $fn = intval($_POST['firstname'] ?? 0);
  $ln = intval($_POST['lastname'] ?? 0);
  
  if (!$stmt->execute()) {
      error_log('Insert Failed: ' . $stmt->error);
      echo 'Insert error: ' . $stmt->error;
  } else {
      echo 'Success! New ID: ' . $stmt->insert_id;
  }
  

  Check XAMPP's Apache error log (xampp/apache/logs/error.log) for any logged issues.

4. Check Frontend Response Handling

• Even if the backend inserts successfully, your frontend might not be updating to reflect it. Add console logs for the post response to confirm success, and make sure you're refreshing the UI or page after a successful request.

内容的提问来源于stack exchange，提问作者J. Doe