To create a database use the mysql_query() function to execute an SQL query like this
<?php
include 'config.php';
include 'opendb.php';
$query = "CREATE DATABASE phpcake";
$result = mysql_query($query);
include 'closedb.php';
?>
Please note that the query should not end with a semicolon.
PHP also provide a function to create MySQL database, mysql_create_db(). This function is deprecated though. It is better to use mysql_query() to execute an SQL CREATE DATABASE statement instead like the above example.
If you want to create MySQL database using PHP mysql_create_db() function you can do it like this :
<?php
include 'config.php';
include 'opendb.php';
mysql_create_db('phpcake');
include 'closedb.php';
?>
If you want to create tables in the database you just created don't forget to call mysql_select_db() to access the new database.
Note: some webhosts require you to create a MySQL database and user through your website control panel (such as CPanel). If you get an error when trying to create database this might be the case.
Creating the TablesTo create tables in the new database you need to do the same thing as creating
the database. First create the SQL query to create the tables then execute the
query using mysql_query() function. <?php $query = 'CREATE DATABASE phpcake'; Of course when you need to create lots of tables it's a good idea to read the query from a file then save in $query variable instead of writing the query in your script. <?php $queryFile = 'myquery.txt'; $fp = fopen($queryFile, 'r');
|
Deleting a Database
As with creating a database, it is also preferable to use mysql_query() and to execute the SQL DROP DATABASE statement instead of using mysql_drop_db()
<?php
include 'config.php';
include 'opendb.php';
// ... do something here
$query = 'DROP DATABASE phpcake';
$result = mysql_query($query);
// ... probably do something here too
include 'closedb.php';
?>
After the database and the tables are ready it's time to put something into the database.
