Created
December 15, 2014 15:10
-
-
Save johnmorris/9834dc846f1027d568e8 to your computer and use it in GitHub Desktop.
Create MySQL tables dynamically using PHP
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
// Be sure to input YOUR database details below | |
// Watch the associated videos here: https://www.youtube.com/playlist?list=PLLs69n7Q4dCx5_7ZwnxTymH8X0iRP_2vw | |
$db_user = 'DB USERNAME HERE'; | |
$db_pass = 'DB PASSWORD HERE'; | |
$db_name = 'DB NAME HERE'; | |
$db_host = 'localhost'; | |
$mysqli = new mysqli($db_host, $db_user, $db_pass, $db_name); | |
if ($mysqli->connect_errno) { | |
printf("Connect failed: %s\n", $mysqli->connect_error); | |
exit(); | |
} | |
$objects_table = | |
"CREATE TABLE IF NOT EXISTS objects ( | |
ID bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, | |
post_title text NOT NULL, | |
post_content longtext NOT NULL, | |
post_name varchar(20) NOT NULL, | |
post_date datetime NOT NULL, | |
PRIMARY KEY (ID) | |
)"; | |
if ($mysqli->query($objects_table) === TRUE) { | |
printf("Table objects successfully created.\n"); | |
} | |
$objects_meta_table = | |
"CREATE TABLE IF NOT EXISTS object_meta ( | |
meta_id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, | |
object_id bigint(20) UNSIGNED NOT NULL, | |
meta_key varchar (255), | |
meta_value longtext, | |
PRIMARY KEY (meta_id) | |
)"; | |
if ($mysqli->query($objects_meta_table) === TRUE) { | |
printf("Table object_meta successfully created.\n"); | |
} | |
$objects_tags_table = | |
"CREATE TABLE IF NOT EXISTS object_tag_relationships ( | |
ID bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, | |
object_id bigint(20) UNSIGNED NOT NULL, | |
tag_id bigint(20) UNSIGNED NOT NULL, | |
PRIMARY KEY (ID) | |
)"; | |
if ($mysqli->query($objects_tags_table) === TRUE) { | |
printf("Table object_tag_relationships successfully created.\n"); | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment