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