Snippet Name: Create mySQL table with PHP
Description: Good for install scripts or automated table building.
Comment: (none)
Language: PHP, MYSQL
Highlight Mode: PHP
Last Modified: March 01st, 2009
|
<?PHP
$table_def = "id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,";
$table_def .= "student_id INT(11) NOT NULL,";
$table_def .= "f_name TINYTEXT NOT NULL,";
$table_def .= "l_name TINYTEXT NOT NULL,";
$table_def .= "supervisor TINYTEXT NOT NULL,";
$table_def .= "building TINYTEXT NOT NULL,";
$table_def .= "email TINYTEXT NOT NULL,";
$table_def .= "score SMALLINT(6) NULL,";
$table_def .= "stamp DATETIME NOT NULL,";
$table_def .= "UNIQUE KEY id (id)";
IF (!@mysql_query ("CREATE TABLE $tablename ($table_def)")) {
ECHO "The database table, '$tablename', could not be created.";
} ELSE {
ECHO "Successfully created the '$tablename' table.";
}
?>
|
