rendered paste body function __construct()
{
parent::Model();
$taodb['database'] = APPPATH . "databases" . DIRECTORY_SEPARATOR . $this->username . ".db";
$taodb['dbdriver'] = "sqlite";
$taodb['dbprefix'] = "";
$taodb['pconnect'] = FALSE;
$taodb['db_debug'] = TRUE;
$taodb['active_r'] = TRUE;
if (!file_exists($taodb['database'])) {
$this->load->database($taodb);
//echo "<pre>\n";var_dump($foo);echo "\n</pre>\n";
$sql = "CREATE TABLE Projects (id INTEGER PRIMARY KEY, pname);";
$this->db->query($sql);
$query = $this->db->query($sql);
//$sql = "INSERT INTO projects(pname) VALUES (?);";
$query = $this->db->query("INSERT INTO projects(pname) VALUES (?);", array("Main"));
} else {
$this->load->database($taodb);
}
}