Lines Matching refs:stmt
169 $stmt = $this->pdo->prepare(<<<SQL
176 $stmt->execute([$principalUri]);
179 while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
261 …$stmt = $this->pdo->prepare("INSERT INTO " . $this->calendarTableName . " (synctoken, components) …
262 $stmt->execute([$components]);
278 …$stmt = $this->pdo->prepare("INSERT INTO " . $this->calendarInstancesTableName . " (" . implode(',…
280 $stmt->execute($values);
336 …$stmt = $this->pdo->prepare("UPDATE " . $this->calendarInstancesTableName . " SET " . implode(', '…
338 $stmt->execute(array_values($newValues));
361 …$stmt = $this->pdo->prepare('SELECT access FROM ' . $this->calendarInstancesTableName . ' where id…
362 $stmt->execute([$instanceId]);
363 $access = (int)$stmt->fetchColumn();
371 …$stmt = $this->pdo->prepare('DELETE FROM ' . $this->calendarObjectTableName . ' WHERE calendarid =…
372 $stmt->execute([$calendarId]);
374 …$stmt = $this->pdo->prepare('DELETE FROM ' . $this->calendarChangesTableName . ' WHERE calendarid …
375 $stmt->execute([$calendarId]);
377 …$stmt = $this->pdo->prepare('DELETE FROM ' . $this->calendarInstancesTableName . ' WHERE calendari…
378 $stmt->execute([$calendarId]);
380 … $stmt = $this->pdo->prepare('DELETE FROM ' . $this->calendarTableName . ' WHERE id = ?');
381 $stmt->execute([$calendarId]);
389 … $stmt = $this->pdo->prepare('DELETE FROM ' . $this->calendarInstancesTableName . ' WHERE id = ?');
390 $stmt->execute([$instanceId]);
435 …$stmt = $this->pdo->prepare('SELECT id, uri, lastmodified, etag, calendarid, size, componenttype F…
436 $stmt->execute([$calendarId]);
439 foreach ($stmt->fetchAll(\PDO::FETCH_ASSOC) as $row) {
477 …$stmt = $this->pdo->prepare('SELECT id, uri, lastmodified, etag, calendarid, size, calendardata, c…
478 $stmt->execute([$calendarId, $objectUri]);
479 $row = $stmt->fetch(\PDO::FETCH_ASSOC);
521 $stmt = $this->pdo->prepare($query);
522 $stmt->execute(array_merge([$calendarId], $chunk));
524 while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
570 …$stmt = $this->pdo->prepare('INSERT INTO ' . $this->calendarObjectTableName . ' (calendarid, uri, …
571 $stmt->execute([
616 …$stmt = $this->pdo->prepare('UPDATE ' . $this->calendarObjectTableName . ' SET calendardata = ?, l…
617 …$stmt->execute([$calendarData, time(), $extraData['etag'], $extraData['size'], $extraData['compone…
727 …$stmt = $this->pdo->prepare('DELETE FROM ' . $this->calendarObjectTableName . ' WHERE calendarid =…
728 $stmt->execute([$calendarId, $objectUri]);
847 $stmt = $this->pdo->prepare($query);
848 $stmt->execute($values);
851 while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
900 $stmt = $this->pdo->prepare($query);
901 $stmt->execute([$principalUri, $uid]);
903 if ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
973 …$stmt = $this->pdo->prepare('SELECT synctoken FROM ' . $this->calendarTableName . ' WHERE id = ?');
974 $stmt->execute([$calendarId]);
975 $currentToken = $stmt->fetchColumn(0);
992 $stmt = $this->pdo->prepare($query);
993 $stmt->execute([$syncToken, $currentToken, $calendarId]);
999 while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
1023 $stmt = $this->pdo->prepare($query);
1024 $stmt->execute([$calendarId]);
1026 $result['added'] = $stmt->fetchAll(\PDO::FETCH_COLUMN);
1042 …$stmt = $this->pdo->prepare('INSERT INTO ' . $this->calendarChangesTableName . ' (uri, synctoken, …
1043 $stmt->execute([
1049 …$stmt = $this->pdo->prepare('UPDATE ' . $this->calendarTableName . ' SET synctoken = synctoken + 1…
1050 $stmt->execute([
1098 …$stmt = $this->pdo->prepare("SELECT " . $fields . " FROM " . $this->calendarSubscriptionsTableName…
1099 $stmt->execute([$principalUri]);
1102 while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
1167 …$stmt = $this->pdo->prepare("INSERT INTO " . $this->calendarSubscriptionsTableName . " (" . implod…
1168 $stmt->execute($values);
1218 …$stmt = $this->pdo->prepare("UPDATE " . $this->calendarSubscriptionsTableName . " SET " . implode(…
1221 $stmt->execute(array_values($newValues));
1237 …$stmt = $this->pdo->prepare('DELETE FROM ' . $this->calendarSubscriptionsTableName . ' WHERE id = …
1238 $stmt->execute([$subscriptionId]);
1260 …$stmt = $this->pdo->prepare('SELECT uri, calendardata, lastmodified, etag, size FROM ' . $this->sc…
1261 $stmt->execute([$principalUri, $objectUri]);
1262 $row = $stmt->fetch(\PDO::FETCH_ASSOC);
1289 …$stmt = $this->pdo->prepare('SELECT id, calendardata, uri, lastmodified, etag, size FROM ' . $this…
1290 $stmt->execute([$principalUri]);
1293 foreach ($stmt->fetchAll(\PDO::FETCH_ASSOC) as $row) {
1316 …$stmt = $this->pdo->prepare('DELETE FROM ' . $this->schedulingObjectTableName . ' WHERE principalu…
1317 $stmt->execute([$principalUri, $objectUri]);
1331 …$stmt = $this->pdo->prepare('INSERT INTO ' . $this->schedulingObjectTableName . ' (principaluri, c…
1332 …$stmt->execute([$principalUri, $objectData, $objectUri, time(), md5($objectData), strlen($objectDa…
1475 $stmt = $this->pdo->prepare($query);
1476 $stmt->execute([$calendarId]);
1479 while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {