Web | This Site

Learning PHP
Advanced PHP
PHP Function Reference
PHP Useful Resources
Selected Reading
© 2011 TutorialsPoint.COM

| Home |  | References |  | Discussion Forums |  | About TP

# Deleting MySQL Database Using PHP

## Deleting a Database:

If a database is no longer required then it can be deleted forever. You can use pass an SQL command to mysql_query to delete a database.

### Example:

Try out following example to drop a database.

    <?php
    $dbhost = 'localhost:3036';
    $dbuser = 'root';
    $dbpass = 'rootpassword';
    $conn = mysql_connect($dbhost, $dbuser, $dbpass);
    if(! $conn )
    {
      die('Could not connect: ' . mysql_error());
    }
    $sql = 'DROP DATABASE test_db';
    $retval = mysql_query( $sql, $conn );
    if(! $retval )
    {
      die('Could not delete database db_test: ' . mysql_error());
    }
    echo "Database deleted successfully\n";
    mysql_close($conn);
    ?>

WARNING: its very dangerous to delete a database and any table. So before deleting any table or database you should make sure you are doing everything intentionally.

## Deleting a Table:

Its again a matter of issuing one SQL command through mysql_query function to delete any database table. But be very careful while using this command because by doing so you can delete some important information you have in your table.

### Example:

Try out following example to drop a table:

    <?php
    $dbhost = 'localhost:3036';
    $dbuser = 'root';
    $dbpass = 'rootpassword';
    $conn = mysql_connect($dbhost, $dbuser, $dbpass);
    if(! $conn )
    {
      die('Could not connect: ' . mysql_error());
    }
    $sql = 'DROP TABLE employee';
    $retval = mysql_query( $sql, $conn );
    if(! $retval )
    {
      die('Could not delete table employee: ' . mysql_error());
    }
    echo "Table deleted successfully\n";
    mysql_close($conn);
    ?>

Advertisement

Online Image Processing

Indian Baby Names