Lines Matching refs:stmt
62 …$stmt = $this->pdo->prepare('SELECT id, uri, displayname, principaluri, description, synctoken FRO…
63 $stmt->execute([$principalUri]);
67 foreach ($stmt->fetchAll() as $row) {
135 $stmt = $this->pdo->prepare($query);
138 $stmt->execute($updates);
181 $stmt = $this->pdo->prepare($query);
182 $stmt->execute($values);
197 … $stmt = $this->pdo->prepare('DELETE FROM ' . $this->cardsTableName . ' WHERE addressbookid = ?');
198 $stmt->execute([$addressBookId]);
200 … $stmt = $this->pdo->prepare('DELETE FROM ' . $this->addressBooksTableName . ' WHERE id = ?');
201 $stmt->execute([$addressBookId]);
203 …$stmt = $this->pdo->prepare('DELETE FROM ' . $this->addressBookChangesTableName . ' WHERE addressb…
204 $stmt->execute([$addressBookId]);
229 …$stmt = $this->pdo->prepare('SELECT id, uri, lastmodified, etag, size FROM ' . $this->cardsTableNa…
230 $stmt->execute([$addressbookId]);
233 while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
256 …$stmt = $this->pdo->prepare('SELECT id, carddata, uri, lastmodified, etag, size FROM ' . $this->ca…
257 $stmt->execute([$addressBookId, $cardUri]);
259 $result = $stmt->fetch(\PDO::FETCH_ASSOC);
288 $stmt = $this->pdo->prepare($query);
289 $stmt->execute(array_merge([$addressBookId], $uris));
291 while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
327 …$stmt = $this->pdo->prepare('INSERT INTO ' . $this->cardsTableName . ' (carddata, uri, lastmodifie…
331 $stmt->execute([
373 …$stmt = $this->pdo->prepare('UPDATE ' . $this->cardsTableName . ' SET carddata = ?, lastmodified =…
376 $stmt->execute([
400 …$stmt = $this->pdo->prepare('DELETE FROM ' . $this->cardsTableName . ' WHERE addressbookid = ? AND…
401 $stmt->execute([$addressBookId, $cardUri]);
405 return $stmt->rowCount() === 1;
468 …$stmt = $this->pdo->prepare('SELECT synctoken FROM ' . $this->addressBooksTableName . ' WHERE id =…
469 $stmt->execute([$addressBookId]);
470 $currentToken = $stmt->fetchColumn(0);
487 $stmt = $this->pdo->prepare($query);
488 $stmt->execute([$syncToken, $currentToken, $addressBookId]);
494 while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
518 $stmt = $this->pdo->prepare($query);
519 $stmt->execute([$addressBookId]);
521 $result['added'] = $stmt->fetchAll(\PDO::FETCH_COLUMN);
537 …$stmt = $this->pdo->prepare('INSERT INTO ' . $this->addressBookChangesTableName . ' (uri, synctoke…
538 $stmt->execute([
544 …$stmt = $this->pdo->prepare('UPDATE ' . $this->addressBooksTableName . ' SET synctoken = synctoken…
545 $stmt->execute([