Create Database/Table With PHP
include 'config.php';
include 'opendb.php';
$query = "CREATE DATABASE rajdb";
$result = mysql_query($query);
include 'closedb.php';
?>
OR
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.
include 'config.php';
include 'opendb.php';
mysql_create_db('rajdb');
include 'closedb.php';
?>
Creating Table using PHP Code
include 'config.php';
include 'opendb.php';
$query = 'CREATE DATABASE rajdb';
$result = mysql_query($query);
mysql_select_db('rajdb') or die('Cannot select database');
$query = 'CREATE TABLE info( '.
'infoid INT NOT NULL AUTO_INCREMENT, '.
'name VARCHAR(20) NOT NULL, '.
'PRIMARY KEY(infoid))';
$result = mysql_query($query);
include 'closedb.php';
?>
Deleting a Database:
$query = 'DROP DATABASE rajdb';
$result = mysql_query($query);


0 Comments:
Post a Comment
<< Home