PHP按Team名称删除表数据无报错但未生效问题求助

Hey there! Let's dig into why your "Löschen" button isn't actually removing data from your table, even without throwing errors. Since your table has Name and Spiel fields, here are the most common issues and fixes to check:

1. Verify Form Submission & Parameter Handling #

First, make sure your form is properly sending the team name to your PHP script:

• Check if your form uses the correct method (preferably POST instead of GET for delete actions):

  <form method="POST" action="your-delete-script.php">
      <input type="text" name="teamName" placeholder="Team Name">
      <button type="submit" name="deleteBtn">Löschen</button>
  </form>
  

• In your PHP code, confirm you're actually retrieving the submitted value and checking if the button was clicked:

  if (isset($_POST['deleteBtn']) && !empty($_POST['teamName'])) {
      $teamName = trim($_POST['teamName']); // Trim whitespace to avoid mismatches
      // ... rest of your delete logic
  }
  

  Missing the isset($_POST['deleteBtn']) check might mean your delete code isn't even running when the button is clicked.

2. Fix Your SQL Delete Query #

The most likely culprit is a mismatched or unsafe SQL query. Avoid string concatenation (it's prone to SQL injection and matching issues) and use prepared statements instead:

// Assuming you're using PDO (mysqli works similarly with prepared statements)
$dbHost = 'your-host';
$dbName = 'your-db';
$dbUser = 'your-user';
$dbPass = 'your-pass';

try {
    $pdo = new PDO("mysql:host=$dbHost;dbname=$dbName;charset=utf8mb4", $dbUser, $dbPass);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    if (isset($_POST['deleteBtn']) && !empty($_POST['teamName'])) {
        $teamName = trim($_POST['teamName']);
        
        // First, check if the team exists (helps debug missing matches)
        $checkStmt = $pdo->prepare("SELECT * FROM your_table_name WHERE Name = ?");
        $checkStmt->execute([$teamName]);
        
        if ($checkStmt->rowCount() === 0) {
            echo "Team with that name doesn't exist!";
        } else {
            // Execute delete
            $deleteStmt = $pdo->prepare("DELETE FROM your_table_name WHERE Name = ?");
            $deleteStmt->execute([$teamName]);
            
            echo "Team deleted successfully!";
        }
    }
} catch(PDOException $e) {
    echo "Error: " . $e->getMessage();
}

• Double-check your table name and field name (case sensitivity matters on Linux-based databases! If your field is lowercase name but you wrote Name, the query won't match anything).
• Using trim() on the input removes accidental leading/trailing spaces that might cause mismatches with database values.

3. Check for Hidden Errors #

Even if you don't see errors, enable PHP error reporting to catch hidden issues:

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

This will show you if there's a database connection issue, invalid syntax, or other problems that aren't being displayed by default.

4. Confirm You're Working With the Correct Database #

It sounds silly, but sometimes we accidentally connect to a test database instead of the production one. Double-check your database credentials to ensure you're modifying the right table.

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