Lines Matching defs:query
126 $db->query('BEGIN TRANSACTION');
132 foreach ($queries as $query) {
133 if (!call_user_func_array(array($db, 'query'), $query)) {
134 $db->query('ROLLBACK TRANSACTION');
140 return $db->query('COMMIT TRANSACTION');
393 $query = 'SELECT "pid",
402 $query .= $having;
403 $query .= 'ORDER BY ' . $order_by;
405 $query .= ' DESC';
409 $res = $db->query($query, $params);
420 $query = '
426 $res = $db->query($query);
472 $db->query('BEGIN TRANSACTION');
482 $res = $db->query($insertQuery . $where, $params);
484 $db->query('ROLLBACK TRANSACTION');
495 if ($db->query($deleteQuery . $where, $params) === false) {
496 $db->query('ROLLBACK TRANSACTION');
501 $db->query('COMMIT TRANSACTION');
521 $res = $db->query(
533 $res = $db->query(
539 $res = $db->query(
578 $resAffectedPages = $db->query($affectedPagesQuery, $args);
582 $db->query($deleteQuery, $args);
593 $query = 'DELETE FROM "taggings"
596 $res = $db->query($query);
608 $db->query('UPDATE taggings SET pid = ? WHERE pid = ?', $newName, $oldName);
612 * Extracts tags from search query
688 $res = $db->query($sql, $tid);
909 * Returns all tagging parameters from the query string
958 * Executes the query and returns the results as array
960 * @param array $query
963 protected function queryDb($query)
970 $res = $db->query($query[0], $query[1]);
981 * Construct the HAVING part of the search query
1011 $query = 'SELECT "pid",
1017 $res = $db->query($query);