使用PHP函数删除MySQL数据库行失败求助

Hey there! No need to apologize—we’ve all been where you are as a new PHP developer. Let’s break down why your delete function might not be working, even when the username is correct, and fix it together.

First, Fix Your Database Connection Check #

Your current connection code doesn’t verify if the connection actually succeeded. A wrong username/password or host could be silently breaking things before you even get to the delete step. Add this check right after connecting:

$connection = mysqli_connect($host, $uname, $password, $db);
if (!$connection) {
    die("Database connection failed: " . mysqli_connect_error());
}

This will immediately tell you if the issue is with connecting to the database in the first place.

Use Prepared Statements (Critical for Security & Reliability) #

I notice your code cuts off before the delete logic, but most new developers make the mistake of directly concatenating the username into the SQL query. This causes two big problems: SQL injection risks, and syntax errors if the username has special characters (like O'Neil). Always use prepared statements instead—here’s a complete, safe example:

// Replace with your actual table name and username field name
$table_name = "users";
$username_field = "username";
$target_user = "the_username_you_want_to_delete"; // Your input variable here

// Prepare the delete query with a placeholder
$stmt = mysqli_prepare($connection, "DELETE FROM $table_name WHERE $username_field = ?");
// Bind the username to the placeholder ("s" means string type)
mysqli_stmt_bind_param($stmt, "s", $target_user);
// Execute the statement
mysqli_stmt_execute($stmt);

// Check if any rows were affected
if (mysqli_stmt_affected_rows($stmt) > 0) {
    echo "Successfully deleted the user!";
} else {
    echo "Delete failed: No matching row found, or there was an error.";
    // Print the database error to debug
    echo "Database error: " . mysqli_error($connection);
}

// Clean up
mysqli_stmt_close($stmt);
mysqli_close($connection);

Check These Common Pitfalls #

• Typos in Table/Field Names: Double-check that your table name and username field name exactly match what’s in your database (some databases are case-sensitive!).
• Permission Issues: Make sure your database user account has DELETE permissions—some hosting providers restrict this by default.
• Case/Whitespace Mismatches: If your database stores JohnDoe but you’re inputting johndoe or John Doe (with a space), the match will fail.
• Silent Errors: Turn on PHP error reporting during development to catch hidden issues:

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

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