function Loader($filename)
{
$this->db = new PDO("sqlite:{$filename}");
db_create_tables($this->db, false);
$this->stmt_load_task_by_id = $this->db->prepare("SELECT id, parent, name, type, auto_type, progress, auto_progress FROM tasks WHERE id = :id");
$this->stmt_load_plans = $this->db->prepare("SELECT id, name, root_id FROM plans ORDER BY id");
$this->stmt_load_commands = $this->db->prepare("SELECT id, type, current, a, b, c, d, e, f FROM commands WHERE plan_id = :plan_id ORDER BY id");
$this->stmt_load_option = $this->db->prepare("SELECT value FROM options WHERE name=:name");
}
function Saver($filename)
{
$this->db = new PDO("sqlite:{$filename}");
db_create_tables($this->db, true);
}
<?php
$config = array('dbname' => 'remindme', 'dbhost' => 'localhost', 'dbuser' => 'remindme', 'dbpass' => 'remindme');
db_create_tables($config);
$uri = uri_split();
switch ($uri[2]) {
case 'todos':
todos_request($config, $uri);
break;
case 'histories':
history_request($config, $uri);
break;
case 'historyRanges':
history_ranges_request($config, $uri);
break;
case 'onqueues':
onqueue_request($config, $uri);
break;
case 'summaries':
summary_request($config, $uri);
break;
}
function summary_request($config, $uri)
{
switch ($_SERVER['REQUEST_METHOD']) {
case 'GET':
find_summary($config, $uri);
break;
case 'POST':
//create
//create
