Lines Matching refs:stmt
81 …$stmt = $this->pdo->prepare("SELECT id, uri FROM simple_calendars WHERE principaluri = ? ORDER BY …
82 $stmt->execute([$principalUri]);
85 while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
112 … $stmt = $this->pdo->prepare("INSERT INTO simple_calendars (principaluri, uri) VALUES (?, ?)");
113 $stmt->execute([$principalUri, $calendarUri]);
127 $stmt = $this->pdo->prepare('DELETE FROM simple_calendarobjects WHERE calendarid = ?');
128 $stmt->execute([$calendarId]);
130 $stmt = $this->pdo->prepare('DELETE FROM simple_calendars WHERE id = ?');
131 $stmt->execute([$calendarId]);
168 …$stmt = $this->pdo->prepare('SELECT id, uri, calendardata FROM simple_calendarobjects WHERE calend…
169 $stmt->execute([$calendarId]);
172 foreach ($stmt->fetchAll(\PDO::FETCH_ASSOC) as $row) {
205 …$stmt = $this->pdo->prepare('SELECT id, uri, calendardata FROM simple_calendarobjects WHERE calend…
206 $stmt->execute([$calendarId, $objectUri]);
207 $row = $stmt->fetch(\PDO::FETCH_ASSOC);
242 …$stmt = $this->pdo->prepare('INSERT INTO simple_calendarobjects (calendarid, uri, calendardata) VA…
243 $stmt->execute([
273 …$stmt = $this->pdo->prepare('UPDATE simple_calendarobjects SET calendardata = ? WHERE calendarid =…
274 $stmt->execute([$calendarData, $calendarId, $objectUri]);
291 …$stmt = $this->pdo->prepare('DELETE FROM simple_calendarobjects WHERE calendarid = ? AND uri = ?');
292 $stmt->execute([$calendarId, $objectUri]);