$servername = "localhost"; $username = "username"; $password = "password"; $dbname = "myDB"; $conn = mysqli_connect($servername, $username, $password, $dbname); if (!$conn) { die("Connection failed: " . mysqli_connect_error()); } $sql = "DROP TABLE customers"; if (mysqli_query($conn, $sql)) { echo "Table customers dropped successfully"; } else { echo "Error dropping table: " . mysqli_error($conn); } mysqli_close($conn);
$host = "localhost"; $port = "5432"; $dbname = "mydb"; $user = "postgres"; $password = "password"; $conn = pg_connect("host=$host port=$port dbname=$dbname user=$user password=$password"); if (!$conn) { echo "Connection failed."; exit; } $sql = "DROP TABLE users"; if (pg_query($conn, $sql)) { echo "Table users dropped successfully"; } else { echo "Error dropping table: " . pg_last_error($conn); } pg_close($conn);Package library for the above code examples would be MySQLi and PostgreSQL extensions of PHP.