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);
195 … $stmt = $this->pdo->prepare('DELETE FROM ' . $this->cardsTableName . ' WHERE addressbookid = ?');
196 $stmt->execute([$addressBookId]);
198 … $stmt = $this->pdo->prepare('DELETE FROM ' . $this->addressBooksTableName . ' WHERE id = ?');
199 $stmt->execute([$addressBookId]);
201 …$stmt = $this->pdo->prepare('DELETE FROM ' . $this->addressBookChangesTableName . ' WHERE id = ?');
202 $stmt->execute([$addressBookId]);
227 …$stmt = $this->pdo->prepare('SELECT id, uri, lastmodified, etag, size FROM ' . $this->cardsTableNa…
228 $stmt->execute([$addressbookId]);
231 while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
253 …$stmt = $this->pdo->prepare('SELECT id, carddata, uri, lastmodified, etag, size FROM ' . $this->ca…
254 $stmt->execute([$addressBookId, $cardUri]);
256 $result = $stmt->fetch(\PDO::FETCH_ASSOC);
284 $stmt = $this->pdo->prepare($query);
285 $stmt->execute(array_merge([$addressBookId], $uris));
287 while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
322 …$stmt = $this->pdo->prepare('INSERT INTO ' . $this->cardsTableName . ' (carddata, uri, lastmodifie…
326 $stmt->execute([
368 …$stmt = $this->pdo->prepare('UPDATE ' . $this->cardsTableName . ' SET carddata = ?, lastmodified =…
371 $stmt->execute([
395 …$stmt = $this->pdo->prepare('DELETE FROM ' . $this->cardsTableName . ' WHERE addressbookid = ? AND…
396 $stmt->execute([$addressBookId, $cardUri]);
400 return $stmt->rowCount() === 1;
463 …$stmt = $this->pdo->prepare('SELECT synctoken FROM ' . $this->addressBooksTableName . ' WHERE id =…
464 $stmt->execute([ $addressBookId ]);
465 $currentToken = $stmt->fetchColumn(0);
482 $stmt = $this->pdo->prepare($query);
483 $stmt->execute([$syncToken, $currentToken, $addressBookId]);
489 while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
513 $stmt = $this->pdo->prepare($query);
514 $stmt->execute([$addressBookId]);
516 $result['added'] = $stmt->fetchAll(\PDO::FETCH_COLUMN);
532 …$stmt = $this->pdo->prepare('INSERT INTO ' . $this->addressBookChangesTableName . ' (uri, synctoke…
533 $stmt->execute([
539 …$stmt = $this->pdo->prepare('UPDATE ' . $this->addressBooksTableName . ' SET synctoken = synctoken…
540 $stmt->execute([