DROP Query using PDO

• PDO: rowCount() with INSERT, DROP & DELETE query

require "config.php"; // database connection 
$sql=$dbo->prepare("DROP TABLE  student_del ");
$sql->execute();
echo "Table dropped successfully.";

<?Php
require "config.php"; // database connection 
$sql=$dbo->prepare("DROP TABLE  student ");

if($sql->execute()){
echo " Table deleted ";
}else{
print_r($sql->errorInfo()); 
}
?>

Example 1: Error Handling in DROP

Using a try-catch block to handle errors when dropping a table.

try {
    $sql = "DROP TABLE IF EXISTS students";
    $pdo->exec($sql);
    echo "Table dropped successfully.";
} catch (PDOException $e) {
    echo "Error: " . $e->getMessage();
}

Example 2: Check if Table Exists Before Dropping

This example checks if a table exists before trying to drop it.

$result = $pdo->query("SHOW TABLES LIKE 'students'");
if($result->rowCount() > 0) {
    $pdo->exec("DROP TABLE students");
    echo "Table dropped successfully.";
} else {
    echo "Table does not exist.";
}

• DELETE:
  • Removes rows one by one.
  • Can include a WHERE clause to delete specific records.
  • Slower since it logs each row deletion.
  • Can trigger AFTER DELETE triggers.
  • rowCount() works and returns the number of rows deleted.
• TRUNCATE:
  • Removes all rows from the table.
  • Cannot include a WHERE clause.
  • Faster, as it doesn’t log individual deletions.
  • Resets the auto-increment counter.
  • Does not trigger DELETE triggers.
  • rowCount() does not work, as it doesn't return row count.
• DROP:
  • Completely removes the entire table from the database.
  • All data, structure, and indexes are removed.
  • Cannot be rolled back if not in a transaction.
  • Cannot use rowCount() as the table itself is deleted.

Transaction

try {
    $pdo->beginTransaction();
    
    $pdo->exec("DROP TABLE IF EXISTS students");
    // Any further database operations here
    
    $pdo->commit();
} catch (PDOException $e) {
    $pdo->rollBack();  // Cannot roll back DROP TABLE
    echo "Error: " . $e->getMessage();
}

Subhendu Mohapatra

Author

🎥 Join me live on YouTube

Passionate about coding and teaching, I publish practical tutorials on PHP, Python, JavaScript, SQL, and web development. My goal is to make learning simple, engaging, and project‑oriented with real examples and source code.

← Subscribe to our YouTube Channel here