php - CodeIgniter - Create multiple databases from master SQL file -

php - CodeIgniter - Create multiple databases from master SQL file -

what best way take .sql file includes schema , table creation statements , utilize create new databases within codeigniter? want able utilize .sql file design several databases same schema, may created @ time.

i imagine need able take file, extract contents , echo out database query. there improve way it?

i need able inject custom database name statements before submitting query. how go this? have placeholder keyword , preg replace database name?

just ensure databases maintained synchronously, thought perhaps design schema should added codeigniter module. way if need alter schema, can upload new version of module updated .sql file , perform necessary migrations across databases. sound reasonable? if so, how go this?

i have done (run .sql file) before, , used this;

$sql = read_file('path/to/file.sql'); $final = ''; foreach(explode("\n", $sql) $line) { if ( isset($line[0]) && $line[0] != '#' ) { $final .= $line . "\n"; } } foreach (explode(";\n", final) $sql) { if ($sql) { $this->db->query($sql); } }

php mysql sql codeigniter