Monday, December 1, 2008

Membuat table

Table dibuat dengan query:

<?php
include 'config.php';

$query = 'CREATE DATABASE dbase';
$result = mysql_query($query);

mysql_select_db('dbase') or die('Cannot select database');

$query = 'CREATE TABLE user ( '.
'cid INT NOT NULL AUTO_INCREMENT, '.
'nama VARCHAR(20) NOT NULL, '.
'alamat VARCHAR(50) NOT NULL, '.
'PRIMARY KEY(cid))';

$result = mysql_query($query);


?>

atau:

<?php
include 'config.php';

$query = 'CREATE DATABASE dbase';
$result = mysql_query($query);

mysql_select_db('dbase') or die('Cannot select database');

mysql_query(”CREATE TABLE user (
cid INT NOT NULL AUTO_INCREMENT,
nama VARCHAR(20) NOT NULL,
alamat VARCHAR(50) NOT NULL,
PRIMARY KEY(cid))”);


?>