Step down at my blog with your ideas,comments,suggestions on Ruby on Rails, PHP or Web2.0 Technology.

Tuesday, August 22, 2006

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