Lines Matching refs:stmt

152 …$stmt = $this->pdo->prepare("SELECT " . $fields . " FROM " . $this->calendarTableName . " WHERE pr…
153 $stmt->execute([$principalUri]);
156 while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
236 …$stmt = $this->pdo->prepare("INSERT INTO " . $this->calendarTableName . " (" . implode(', ', $fiel…
237 $stmt->execute($values);
285 …$stmt = $this->pdo->prepare("UPDATE " . $this->calendarTableName . " SET " . implode(', ', $values…
287 $stmt->execute(array_values($newValues));
305 …$stmt = $this->pdo->prepare('DELETE FROM ' . $this->calendarObjectTableName . ' WHERE calendarid =…
306 $stmt->execute([$calendarId]);
308 $stmt = $this->pdo->prepare('DELETE FROM ' . $this->calendarTableName . ' WHERE id = ?');
309 $stmt->execute([$calendarId]);
311 …$stmt = $this->pdo->prepare('DELETE FROM ' . $this->calendarChangesTableName . ' WHERE calendarid …
312 $stmt->execute([$calendarId]);
349 …$stmt = $this->pdo->prepare('SELECT id, uri, lastmodified, etag, calendarid, size, componenttype F…
350 $stmt->execute([$calendarId]);
353 foreach ($stmt->fetchAll(\PDO::FETCH_ASSOC) as $row) {
387 …$stmt = $this->pdo->prepare('SELECT id, uri, lastmodified, etag, calendarid, size, calendardata, c…
388 $stmt->execute([$calendarId, $objectUri]);
389 $row = $stmt->fetch(\PDO::FETCH_ASSOC);
425 $stmt = $this->pdo->prepare($query);
426 $stmt->execute(array_merge([$calendarId], $uris));
429 while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
470 …$stmt = $this->pdo->prepare('INSERT INTO ' . $this->calendarObjectTableName . ' (calendarid, uri, …
471 $stmt->execute([
511 …$stmt = $this->pdo->prepare('UPDATE ' . $this->calendarObjectTableName . ' SET calendardata = ?, l…
512 …$stmt->execute([$calendarData, time(), $extraData['etag'], $extraData['size'], $extraData['compone…
610 …$stmt = $this->pdo->prepare('DELETE FROM ' . $this->calendarObjectTableName . ' WHERE calendarid =…
611 $stmt->execute([$calendarId, $objectUri]);
725 $stmt = $this->pdo->prepare($query);
726 $stmt->execute($values);
729 while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
778 $stmt = $this->pdo->prepare($query);
779 $stmt->execute([$principalUri, $uid]);
781 if ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
846 …$stmt = $this->pdo->prepare('SELECT synctoken FROM ' . $this->calendarTableName . ' WHERE id = ?');
847 $stmt->execute([ $calendarId ]);
848 $currentToken = $stmt->fetchColumn(0);
865 $stmt = $this->pdo->prepare($query);
866 $stmt->execute([$syncToken, $currentToken, $calendarId]);
872 while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
896 $stmt = $this->pdo->prepare($query);
897 $stmt->execute([$calendarId]);
899 $result['added'] = $stmt->fetchAll(\PDO::FETCH_COLUMN);
915 …$stmt = $this->pdo->prepare('INSERT INTO ' . $this->calendarChangesTableName . ' (uri, synctoken, …
916 $stmt->execute([
922 …$stmt = $this->pdo->prepare('UPDATE ' . $this->calendarTableName . ' SET synctoken = synctoken + 1…
923 $stmt->execute([
971 …$stmt = $this->pdo->prepare("SELECT " . $fields . " FROM " . $this->calendarSubscriptionsTableName…
972 $stmt->execute([$principalUri]);
975 while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
1040 …$stmt = $this->pdo->prepare("INSERT INTO " . $this->calendarSubscriptionsTableName . " (" . implod…
1041 $stmt->execute($values);
1089 …$stmt = $this->pdo->prepare("UPDATE " . $this->calendarSubscriptionsTableName . " SET " . implode(…
1092 $stmt->execute(array_values($newValues));
1108 …$stmt = $this->pdo->prepare('DELETE FROM ' . $this->calendarSubscriptionsTableName . ' WHERE id = …
1109 $stmt->execute([$subscriptionId]);
1131 …$stmt = $this->pdo->prepare('SELECT uri, calendardata, lastmodified, etag, size FROM ' . $this->sc…
1132 $stmt->execute([$principalUri, $objectUri]);
1133 $row = $stmt->fetch(\PDO::FETCH_ASSOC);
1160 …$stmt = $this->pdo->prepare('SELECT id, calendardata, uri, lastmodified, etag, size FROM ' . $this…
1161 $stmt->execute([$principalUri]);
1164 foreach ($stmt->fetchAll(\PDO::FETCH_ASSOC) as $row) {
1187 …$stmt = $this->pdo->prepare('DELETE FROM ' . $this->schedulingObjectTableName . ' WHERE principalu…
1188 $stmt->execute([$principalUri, $objectUri]);
1202 …$stmt = $this->pdo->prepare('INSERT INTO ' . $this->schedulingObjectTableName . ' (principaluri, c…
1203 …$stmt->execute([$principalUri, $objectData, $objectUri, time(), md5($objectData), strlen($objectDa…