What is PhpDig?
PhpDig is a PHP MySQL based
Web Spider & Search Engine.



mysql_drop_db — Drops (deletes) a MySQL database.


bool mysql_drop_db(database_name[, connection]);
string database_name: Name of the database to drop
mysql link connection (optional): Connection handle returned by mysql_connect() or mysql_pconnect()


TRUE on success; FALSE on failure


mysql_drop_db() drops/deletes a MySQL database. Every table in the database is permanently removed. Databases can also be dropped by using a SQL query such as "DROP DATABASE ..."


Dropping a database is irreversible. The only way to recover the database is by restoring from backups!


PHP 3+, PHP 4+

See also

To delete rows from a table:

Use mysql_query() with a DELETE query. See the MySQL documentation for more information.


Example 797. Delete a MySQL database

// Included code that connects to a MySQL server and sets a default database
// See the MySQL Functions chapter introduction for the source code for the file
include ('');

// Be very careful doing this!  There is no way to undo a drop!!!
mysql_drop_db ($db)
    or die ("Could not drop database '$db'.");

echo "Database '$db' was dropped.";

PHP Functions Essential Reference. Copyright © 2002 by New Riders Publishing (Authors: Zak Greant, Graeme Merrall, Torben Wilson, Brett Michlitsch). This material may be distributed only subject to the terms and conditions set forth in the Open Publication License, v1.0 or later (the latest version is presently available at The authors of this book have elected not to choose any options under the OPL. This online book was obtained from and is designed to provide information about the PHP programming language, focusing on PHP version 4.0.4 for the most part. The information is provided on an as-is basis, and no warranty or fitness is implied. All persons and entities shall have neither liability nor responsibility to any person or entity with respect to any loss or damage arising from the information contained in this book.

Powered by: vBulletin Version 3.0.7
Copyright ©2000 - 2005, Jelsoft Enterprises Ltd.
Copyright © 2001 - 2005, ThinkDing LLC. All Rights Reserved.