PHP4 and MySQL database operation function detailed explanation (four)

<6&gt. Database-level operation functions (2):

1, mysql_create_db ()
Format: int mysql_create_db (string database name, int link_identifier);

Through the program to build 1 database databases, of course, you can also use the mysql_query () or mysql_db_query () function to create or delete db

But we can use this function more easily to build 1 database.
1 true values were successfully returned, and 1 false were returned for failure.

Example:

<?php

$connect = mysql_connect ("$hostname", "$user", "$pwd");
$create = mysql_create_db ("dbtest", $connect);
if ($create) echo "CREATE Database dbtest successed!";
else echo "CREATE database dbtest failed!";

?>


2, mysql_drop_db ()
Format: int mysql_drop_db (string database name, int link_identifier);

A program to delete 1 database databases.

But we can use this function to more easily delete 1 database.
1 true values were successfully returned, and 1 false were returned for failure.

Example:

<?php

$connect = mysql_connect ("$hostname", "$user", "$pwd");
$create = mysql_drop_db ("dbtest", $connect);
if ($create) echo "drop database dbtest successed!";
else echo "drop database dbtest failed!";

?>



Note: If you use mysql_query () or Mysql_db_query (), the SQL statement should be:
(1) Create DATABASE dbtest
(2) Drop database dbtest