aps developerLearning Curve- Perfect Tutorial for the beginers | Learning Curve- Perfect Tutorial for the beginers

Deleting database table

Please use the example below

<?php
$databasehost = 'localhost';
$databaseuser = 'root';
$databasepassword = '';
$connection = mysql_connect($databasehost, $databaseuser, $databasepassword);
if(! $connection )
{
  die('Could not connect: ' . mysql_error());
}
$sqlqry = 'DROP TABLE mydoubts_data';
$output = mysql_query( $sqlqry, $connection );
if(! $output )
{
  die('Could not delete table mysql_data: ' . mysql_error());
}
echo "Table deleted successfully\n";
mysql_close($connection);
?>

<?php

$databasehost = 'localhost';

$databaseuser = 'root';

$databasepassword = '';

$connection = mysql_connect($databasehost, $databaseuser, $databasepassword);

if(! $connection )

{

die('Could not connect: ' . mysql_error());

}

$sqlqry = 'DROP TABLE mydoubts_data';

$output = mysql_query( $sqlqry, $connection );

if(! $output )

{

die('Could not delete table mysql_data: ' . mysql_error());

}

echo "Table deleted successfully\n";

mysql_close($connection);

Deleting the database

Using sql query to delete mysql database using function mysql_query() here we can use drop function to delete the database Please check the below exampe to Delete the database

<?php
$databasehost = 'localhost';
$databaseuser = 'root';
$databasepassword = '';
$connection = mysql_connect($databasehost, $databaseuser, $databasepassword);
if(! $connection )
{
  die('Could not connect: ' . mysql_error());
}
$sqlqry = 'DROP DATABASE mydoubts';
$output = mysql_query( $sqlqry, $connection );
if(! $output )
{
  die('Could not delete database mydoubts: ' . mysql_error());
}
echo "Database deleted successfully\n";
mysql_close($connection);
?>