<?php
include 'config.php';
include 'opendb.php';
$query = 'CREATE DATABASE phpcake';
$result = mysql_query($query);
mysql_select_db('phpcake') or die('Cannot select database');
$query = 'CREATE TABLE contact( '.
'cid INT NOT NULL AUTO_INCREMENT, '.
'cname VARCHAR(20) NOT NULL, '.
'cemail VARCHAR(50) NOT NULL, '.
'csubject VARCHAR(30) NOT NULL, '.
'cmessage TEXT NOT NULL, '.
'PRIMARY KEY(cid))';
$result = mysql_query($query);
include 'closedb.php';
?>
include 'config.php';
include 'opendb.php';
$query = 'CREATE DATABASE phpcake';
$result = mysql_query($query);
mysql_select_db('phpcake') or die('Cannot select database');
$query = 'CREATE TABLE contact( '.
'cid INT NOT NULL AUTO_INCREMENT, '.
'cname VARCHAR(20) NOT NULL, '.
'cemail VARCHAR(50) NOT NULL, '.
'csubject VARCHAR(30) NOT NULL, '.
'cmessage TEXT NOT NULL, '.
'PRIMARY KEY(cid))';
$result = mysql_query($query);
include 'closedb.php';
?>
Tentu saja ketika Anda harus membuat banyak tabel itu ide yang baik untuk membaca query dari file kemudian simpan di variabel $ query bukan menulis query di script Anda.
<?php
include 'config.php';
include 'opendb.php';
$queryFile = 'myquery.txt';
$fp = fopen($queryFile, 'r');
$query = fread($fp, filesize($queryFile));
fclose($fp);
$result = mysql_query($query);
include 'closedb.php';
?>
Anda ingin mencari refrensi dan contoh program lengkap ? Kami ada. Sekarang Anda bisa mencari PHP MySQL Tutorial di situs ini : http://www.bunafitkomputer.com. Koleksi program lengkap di sana, proyek PHP dan MySQL, juga jQuery dan Framework. Bukunya juga ada.
No comments:
Post a Comment