Lines Matching refs:res
67 $res = $sqlite->query("SELECT id FROM user WHERE user = ?", $user);
68 $db_user_id = (int) $sqlite->res2single($res);
69 $sqlite->res_close($res);
74 $res = $sqlite->query("SELECT id FROM user WHERE user = ?", $user);
75 $db_user_id = (int) $sqlite->res2single($res);
76 $sqlite->res_close($res);
91 $res = $sqlite->query("SELECT id FROM page WHERE page = ?", $page);
92 $page_id = (int) $sqlite->res2single($res);
102 $res = $sqlite->query("SELECT id FROM page WHERE page = ?", $page);
103 $page_id = (int) $sqlite->res2single($res);
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);
129 $project_id = (int) $sqlite->res2single($res);
130 $sqlite->res_close($res);
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);
160 $task_id = (int) $sqlite->res2single($res);
161 $sqlite->res_close($res);
246 $res = $sqlite->query("SELECT id FROM project WHERE page_id = ? AND abbr = ?", $page_id, $abbr);
247 $project_id = (int) $sqlite->res2single($res);
248 $sqlite->res_close($res);
260 $res = $sqlite->query("SELECT
267 $data = $sqlite->res2single($res);
275 $res = $sqlite->query("SELECT
287 $data = $sqlite->res2arr($res);
295 $res = $sqlite->query("SELECT pr.id
301 $data = $sqlite->res2arr($res);
311 $res = $sqlite->query("SELECT
317 $data = $sqlite->res2row($res);
328 $res = $sqlite->query("SELECT
344 $data = $sqlite->res2arr($res);
358 $res = $sqlite->query('SELECT
365 $db_id = (int) $sqlite->res2single($res);
366 $sqlite->res_close($res);
380 $res = $sqlite->query("SELECT u.id
384 $db_user_id = (int) $sqlite->res2single($res);
385 $sqlite->res_close($res);
394 $res = $sqlite->query("SELECT
413 $data = $sqlite->res2arr($res);
423 $res = $sqlite->query("SELECT
435 $data = $sqlite->res2arr($res);
449 $res = $sqlite->query("SELECT
458 $data = $sqlite->res2row($res);
466 $res = $sqlite->query("SELECT
475 $data = $sqlite->res2single($res);
506 $res = $sqlite->query("SELECT
526 $data = $sqlite->res2arr($res);
550 $res = $sqlite->query("SELECT
562 $taskdata = $sqlite->res2arr($res);
579 $res = $sqlite->query("SELECT
597 $data = $sqlite->res2arr($res);
606 $res = $sqlite->query("SELECT
621 $data = $sqlite->res2arr($res);
634 $res = $sqlite->query("SELECT
648 $data = $sqlite->res2arr($res);
660 $res = $sqlite->query("SELECT
669 $data = $sqlite->res2row($res);
678 $res = $sqlite->query("SELECT
687 $data = $sqlite->res2single($res);
695 $res = $sqlite->query("SELECT
704 $data = $sqlite->res2single($res);
989 …$res['start'] = date('N', $dt)==1 ? date('Y-m-d', $dt) : date('Y-m-d', strtotime('last monday', $d…
990 …$res['end'] = date('N', $dt)==7 ? date('Y-m-d', $dt) : date('Y-m-d', strtotime('next sunday', $dt)…
991 return $res;