无法将数据保存至MySQL数据库：考勤系统提交问题求助

Hey there, let's work through why your attendance data isn't saving to MySQL when you hit that "Submit Attendance" button. Since your student registration via register.php works, we can start by narrowing down common issues specific to your attendance submission file:

1. Double-Check Database Connection Setup #

Since register.php can interact with the DB successfully, your core DB credentials (host, username, password, DB name) are likely correct—but make sure your attendance submission file is using the exact same connection logic.

• Did you properly include your DB connection file (like db_connect.php) in the attendance script? Sometimes a missing require_once('db_connect.php'); is the silent culprit.
• Add error checking to your connection to confirm it's working:

  $conn = mysqli_connect('localhost', 'your_user', 'your_pass', 'your_db');
  if (!$conn) {
      die("Connection failed: " . mysqli_connect_error());
  }
  

2. Audit Your SQL INSERT Statement #

Even a tiny typo here can break the entire insertion:

• Verify that all column names in your INSERT query match the exact names in your attendance table (case-sensitive depending on your MySQL setup).
• Ensure you're passing the correct data types (e.g., don't send a string for a numeric student_id column, or an invalid date format for a date field).
• Always use prepared statements to avoid SQL injection and syntax errors from user input. Here's a reliable example:

  // Assume you're receiving these values from your form
  $student_id = $_POST['student_id'];
  $attendance_status = $_POST['attendance_status'];
  $recorded_by = $_POST['teacher_id'];
  $attendance_date = date('Y-m-d');
  
  // Prepare and bind the query
  $stmt = mysqli_prepare($conn, "INSERT INTO attendance (student_id, status, recorded_by, date) VALUES (?, ?, ?, ?)");
  mysqli_stmt_bind_param($stmt, "isis", $student_id, $attendance_status, $recorded_by, $attendance_date);
  
  // Execute and check for success
  if (mysqli_stmt_execute($stmt)) {
      echo "Attendance recorded successfully!";
  } else {
      echo "Error: " . mysqli_error($conn); // This will show you the exact DB error message
  }
  

3. Validate Form Data & Parameter Handling #

• Confirm your form uses the correct method (most likely POST), and your script is using $_POST to retrieve values (not $_GET unless you intentionally set it that way).
• Check if required fields are actually being sent: add var_dump($_POST); at the top of your submission script to see exactly what data is coming through. If a key is missing, your form input's name attribute might be misspelled.
• Add checks for empty values where necessary—e.g., don't try to insert a blank student_id.

4. Enable Error Reporting to Catch Hidden Issues #

Turn on PHP error display to see any runtime issues you might be missing:

ini_set('display_errors', 1);
error_reporting(E_ALL);

This will reveal things like undefined variables, missing functions, or connection problems that might be silently failing without feedback.

5. Verify MySQL User Permissions #

While your registration works, double-check that your MySQL user has the INSERT permission on the attendance table. You can run this query in your MySQL client to confirm:

SHOW GRANTS FOR 'your_db_user'@'localhost';

If you can share a snippet of your actual attendance submission code (including the DB connection and INSERT logic), we can pinpoint the exact issue even faster!

内容的提问来源于stack exchange，提问作者Dirie