All pastes #509499 Raw Edit

Stuff

public text v1 · immutable
·published 2007-05-25 14:16 UTC
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);
		}

	}