Deleting the Database using PHP

By | June 27, 2020
Deleting the Database using PHP

You can delete the database in the same manner as you created the database using the mysql_query function.

Example

Vamware
<?php
$db_host = 'localhost:3036';
$db_user = 'root';
$db_pass = 'rootpassword';
$db_conn = mysql_connect($db_host, $db_user, $db_pass);
if(! $db_conn ) {
die('Error: ' . mysql_error());
}
echo 'Success';
$db_sql = 'DROP Database demo_db';
$db_retval = mysql_query( $sql, $conn );
if(! $db_retval ) {
die('Database deletion failed: ' . mysql_error());
}
echo "Database demo_db deleted\n";
mysql_close($db_conn);
?>

Deleting table within the database using PHP

Make sure that you are deleting the right table and database else you may lose some important data.

Example

<?php
$db_host = 'localhost:3036';
$db_user = 'root';
$db_pass = 'rootpassword';
$db_conn = mysql_connect($db_host, $db_user, $db_pass);
if(! $db_conn ) {
die('Connection failed: ' . mysql_error());
}
echo 'Success';
$db_sql = 'DROP table students';
mysql_select_db('demo_db');
$db_retval = mysql_query( $db_sql, $conn );
if(! $db_retval ) {
die('Table deletion failed: ' . mysql_error());
}
echo "Table student deleted successfully\n";
mysql_close($db_conn);
?>

Leave a Reply

Your email address will not be published. Required fields are marked *