PDO SQL INSERT语句不执行且无报错问题排查求助

Hey Joe, sorry to hear you're stuck with this frustrating silent failure—PDO's default "no news isn't good news" behavior can drive anyone crazy! Let's break down the most likely fixes to get your INSERT working:

1. Force PDO to Show Errors (Critical First Step!) #

By default, PDO doesn't throw exceptions or surface errors when something goes wrong—it just fails silently. That's almost certainly why you're seeing zero feedback. Update your database connection to enable error mode immediately:

$connString = "mysql:host=localhost;dbname=rmldb";
$uname = "root";
$pwd = "DB_PASS";

try {
    $pdo = new PDO($connString, $uname, $pwd, [
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, // This is the game-changer!
        PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC // Optional but makes later work easier
    ]);
} catch(PDOException $e) {
    die("Connection failed: " . $e->getMessage());
}

With ERRMODE_EXCEPTION enabled, PDO will spit out detailed errors for any issue—from typos in your SQL to missing table permissions.

2. Validate Your INSERT Statement & Prep Code #

Even tiny mistakes here can cause silent failures:

• Double-check table/column names for typos (e.g., user_email vs useremail—MySQL won't flag a non-existent column in a prepared statement if strict mode isn't enabled).
• Ensure your placeholder count matches the number of parameters you're binding. For example:

  // Correct named placeholders
  $stmt = $pdo->prepare("INSERT INTO your_table (col1, col2) VALUES (:val1, :val2)");
  $stmt->execute(['val1' => 'foo', 'val2' => 'bar']);
  
  // Correct question mark placeholders (order matters!)
  $stmt = $pdo->prepare("INSERT INTO your_table (col1, col2) VALUES (?, ?)");
  $stmt->execute(['foo', 'bar']);
  

• Add a check for affected rows to confirm the insert ran:

  $stmt->execute(...);
  echo "Rows inserted: " . $stmt->rowCount(); // Should return 1 if successful
  

3. Check for Uncommitted Transactions #

If you accidentally started a transaction but never committed it, your INSERT will be held in limbo and never saved to the database. Look for any $pdo->beginTransaction() calls in your code. If you're using transactions, make sure you commit on success:

$pdo->beginTransaction();
try {
    $stmt = $pdo->prepare("INSERT INTO your_table ...");
    $stmt->execute(...);
    $pdo->commit(); // Critical to save changes!
} catch(PDOException $e) {
    $pdo->rollBack(); // Undo changes on error
    echo "Error: " . $e->getMessage();
}

If you don't need transactions, remove any beginTransaction() calls—PDO defaults to auto-committing changes.

4. Rule Out Sublime 3 (You're Probably Right!) #

Sublime 3 itself won't interfere with PDO's execution. The only edge case would be if your file was saved with an odd encoding that broke your SQL, but that's extremely rare. Focus on the PDO configuration and SQL first.

5. Test Your SQL Manually #

Take the exact SQL you're trying to run, replace placeholders with real values, and execute it directly in phpMyAdmin, MySQL Workbench, or the command line. If it fails there, you'll know the issue is with the SQL itself (not your PDO code)—like missing permissions, a duplicate unique key, or invalid data types.

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