Lines Matching refs:query

67 		$res = $sqlite->query("SELECT id FROM user WHERE user = ?", $user);
72 			$sqlite->query('INSERT OR IGNORE INTO user (user) VALUES (?)', $user);
74 			$res = $sqlite->query("SELECT id FROM user WHERE user = ?", $user);
91 		$res = $sqlite->query("SELECT id FROM page WHERE page = ?", $page);
95 			$sqlite->query('INSERT OR IGNORE INTO page(page) VALUES (?)',$page);
102 		$res = $sqlite->query("SELECT id FROM page WHERE page = ?", $page);
125 …$res = $sqlite->query('INSERT OR IGNORE INTO project (page_id, abbr) VALUES (?,?)', $page_id, $abb…
128 		$res = $sqlite->query("SELECT id FROM project WHERE page_id = ? AND abbr = ?", $page_id, $abbr);
137 …$sqlite->query("UPDATE project SET name = ?, `from` = ?, `to` = ? WHERE id = ?", $name, $from, $to…
157 …$res = $sqlite->query('INSERT OR IGNORE INTO task (project_id,abbr,active) VALUES (?,?,1)',$projec…
159 		$res = $sqlite->query("SELECT id FROM task WHERE project_id = ? AND abbr = ?", $project_id,$abbr);
168 		$sqlite->query("UPDATE task SET name = ?, active = 1 WHERE id = ?",	$name, $task_id);
185 		$sqlite->query("UPDATE task SET active = 0 
201 …$sqlite->query('UPDATE user_time SET value = ?, update_time = ? WHERE id = ?', $value, time(), $us…
216 …$sqlite->query('INSERT INTO user_time (update_time,user_id,task_id, date, value) VALUES (?,?,?,?,?…
246 		$res = $sqlite->query("SELECT id FROM project WHERE page_id = ? AND abbr = ?", $page_id, $abbr);
260 		$res = $sqlite->query("SELECT 
275 		$res = $sqlite->query("SELECT 
295 		$res = $sqlite->query("SELECT pr.id
311 		$res = $sqlite->query("SELECT
328 		$res = $sqlite->query("SELECT 
358 		$res = $sqlite->query('SELECT 
380 		$res = $sqlite->query("SELECT u.id 
394 		$res = $sqlite->query("SELECT 
423 		$res = $sqlite->query("SELECT 
449 		$res = $sqlite->query("SELECT 
466 		$res = $sqlite->query("SELECT
506 		$res = $sqlite->query("SELECT
550 		$res = $sqlite->query("SELECT 
579 		$res = $sqlite->query("SELECT
606 		$res = $sqlite->query("SELECT
634 		$res = $sqlite->query("SELECT
660 		$res = $sqlite->query("SELECT
678 		$res = $sqlite->query("SELECT
695 		$res = $sqlite->query("SELECT