Code: Select all
<?php
$connect = mysql_connect("localhost","root","");
$dbconn = mysql_select_db("jae_guestbook");
$queryget = mysql_query("SELECT * FROM userposts ORDER BY id ASC");
$checkdb = $dbconn;
if($checkdb){
echo "<meta http-equiv='refresh' content='1;../index.php'>";
} else {
$install = mysql_query("CREATE DATABASE `jae_guestbook` ;
CREATE TABLE `jae_guestbook`.`userposts` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`name` VARCHAR( 64 ) NOT NULL ,
`email` VARCHAR( 64 ) NOT NULL ,
`message` TEXT NOT NULL ,
`date` DATE NOT NULL ,
`time` TIME NOT NULL
) ENGINE = MYISAM ;
");
}
?>