adding tables
Posted: Sat Feb 20, 2016 9:54 am
How can I add tables to database from array? db connect code not given.
Code: Select all
$arr = array("baker", "benton", "clackamas", "clatsop", "columbia", "coos", "crook", "curry", "deschutes", "douglas", "gilliam", "grant", "harney", "hoodriver", "jackson", "jeffeson", "joesphine", "klamath", "lake", "lincoln", "linn", "malheur", "marion", "morrow", "multnomah", "polk", "sherman", "tillamook", "umatilla", "union", "wallowa", "wasco", "washington", "wheeler", "yamhill");
reset($arr);
foreach ($arr as $value) {
$sql = "CREATE TABLE $value (
id INT(1) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
reg_date TIMESTAMP
)";
}