Lines Matching refs:query

163 …$query = "SELECT calendardata, calendarid, componenttype, etag, uri FROM calendarobjects WHERE uid…
164       $res = $sqlite->query($query, $uid);
181 …$query = "SELECT calendardata, calendarid, componenttype, etag, uri, uid FROM calendarobjects WHER…
182       $res = $sqlite->query($query, $connectionId, $uri);
199 …$query = "SELECT contactdata, addressbookid, etag, uri, formattedname, structuredname FROM address…
200       $res = $sqlite->query($query, $connectionId, $uri);
221           $query = "DELETE FROM calendarobjects WHERE calendarid = ?";
222           $sqlite->query($query, $connectionId);
226           $query = "DELETE FROM addressbookobjects WHERE addressbookid = ?";
227           $sqlite->query($query, $connectionId);
229       $query = "DELETE FROM connections WHERE id = ?";
230       $res = $sqlite->query($query, $connectionId);
254       $query = "SELECT calendardata, componenttype, uid FROM calendarobjects WHERE calendarid = ?";
260         $query .= " AND lastoccurence > ".$sqlite->quote_string($startTs->getTimestamp());
265         $query .= " AND firstoccurence < ".$sqlite->quote_string($endTs->getTimestamp());
267       $res = $sqlite->query($query, $connectionId);
370 …$query = "SELECT contactdata, uri, formattedname, structuredname FROM addressbookobjects WHERE add…
371       $res = $sqlite->query($query, $connectionId);
422 …$query = "INSERT INTO connections (uri, displayname, description, username, password, dwuser, type…
424 …$res = $sqlite->query($query, $uri, $displayname, $description, $username, $password, $dwuser, $ty…
432 …$query = "SELECT id FROM connections WHERE uri = ? AND displayname = ? AND description = ? AND use…
433 …$res = $sqlite->query($query, $uri, $displayname, $description, $username, $password, $dwuser, $ty…
460 …$query = "UPDATE connections SET permission = ?, displayname = ?, syncinterval = ?, write = ?, act…
461 … $res = $sqlite->query($query, $permission, $displayname, $syncinterval, $write, $active, $connId);
479 …$query = "SELECT id, uri, displayname, description, synctoken, dwuser, type, syncinterval, lastsyn…
480       $res = $sqlite->query($query);
496 …$query = "SELECT id, uri, displayname, description, synctoken, dwuser, type, syncinterval, lastsyn…
497       $res = $sqlite->query($query, $connectionId);
513       $query = "SELECT username, password FROM connections WHERE id = ?";
514       $res = $sqlite->query($query, $connectionId);
860     $sqlite->query("BEGIN TRANSACTION");
862     $query = "DELETE FROM calendarobjects WHERE calendarid = ?";
863     $sqlite->query($query, $conn['id']);
879     $sqlite->query("COMMIT TRANSACTION");
930           $query = "DELETE FROM calendarobjects WHERE calendarid = ?";
931           $sqlite->query($query, $conn['id']);
935           $query = "DELETE FROM addressbookobjects WHERE addressbookid = ?";
936           $sqlite->query($query, $conn['id']);
951       $sqlite->query("BEGIN TRANSACTION");
960           $sqlite->query("ROLLBACK TRANSACTION");
973       $sqlite->query("COMMIT TRANSACTION");
1040         $query = "DELETE FROM " . $table . " WHERE etag = ? AND " . $filter . " = ?";
1041         $sqlite->query($query, $etag, $conn['id']);
1168       $query = "SELECT uri, etag FROM " . $table . " WHERE " . $id . " = ?";
1169       $res = $sqlite->query($query, $conn['id']);
1388 …$query = "INSERT INTO calendarobjects (calendardata, uri, calendarid, lastmodified, etag, size, co…
1390 …$res = $sqlite->query($query, $calendarobject['calendar-data'], $calendarobject['href'], $connecti…