Lines Matching refs:query

117 		if (!$query = $this->mysql->query('SHOW TABLES'))
124 while ($row = $query->fetchColumn())
131 …$query = $this->mysql->exec('CREATE TABLE `' . $this->options['extras']['prefix'] . 'cache_data` (…
132 if ($query === false)
142 …$query = $this->mysql->exec('CREATE TABLE `' . $this->options['extras']['prefix'] . 'items` (`feed…
143 if ($query === false)
165 …$query = $this->mysql->prepare('DELETE i, cd FROM `' . $this->options['extras']['prefix'] . 'cache…
169 $query->bindValue(':purge_time', $this->options['extras']['cache_purge_time']);
171 if (!$query->execute())
182 …$query = $this->mysql->prepare('SELECT COUNT(*) FROM `' . $this->options['extras']['prefix'] . 'ca…
183 $query->bindValue(':feed', $this->id);
184 if ($query->execute())
186 if ($query->fetchColumn() > 0)
192 $query = $this->mysql->prepare($sql);
193 $query->bindValue(':items', $items);
198 $query = $this->mysql->prepare($sql);
201 $query->bindValue(':data', $prepared[0]);
202 $query->bindValue(':time', time());
203 $query->bindValue(':feed', $this->id);
204 if (!$query->execute())
211 …$query = $this->mysql->prepare('INSERT INTO `' . $this->options['extras']['prefix'] . 'cache_data`…
212 $query->bindValue(':feed', $this->id);
213 $query->bindValue(':count', count($prepared[1]));
214 $query->bindValue(':data', $prepared[0]);
215 $query->bindValue(':time', time());
216 if (!$query->execute())
230 …$query = $this->mysql->prepare('SELECT `id` FROM `' . $this->options['extras']['prefix'] . 'items`…
231 $query->bindValue(':feed', $this->id);
233 if ($query->execute())
236 while ($row = $query->fetchColumn())
250 …$query = $this->mysql->prepare('INSERT INTO `' . $this->options['extras']['prefix'] . 'items` (`fe…
251 $query->bindValue(':feed', $this->id);
252 $query->bindValue(':id', $new_id);
253 $query->bindValue(':data', serialize($prepared[1][$new_id]->data));
254 $query->bindValue(':date', $date);
255 if (!$query->execute())
271 …$query = $this->mysql->prepare('SELECT `id` FROM `' . $this->options['extras']['prefix'] . 'cache_…
272 $query->bindValue(':feed', $this->id);
273 if ($query->execute())
275 if ($query->rowCount() > 0)
277 …$query = $this->mysql->prepare('UPDATE `' . $this->options['extras']['prefix'] . 'cache_data` SET …
278 $query->bindValue(':data', serialize($data));
279 $query->bindValue(':time', time());
280 $query->bindValue(':feed', $this->id);
288 …$query = $this->mysql->prepare('INSERT INTO `' . $this->options['extras']['prefix'] . 'cache_data`…
289 $query->bindValue(':id', $this->id);
290 $query->bindValue(':data', serialize($data));
291 $query->bindValue(':time', time());
292 if ($query->execute())
314 …$query = $this->mysql->prepare('SELECT `items`, `data` FROM `' . $this->options['extras']['prefix'…
315 $query->bindValue(':id', $this->id);
316 if ($query->execute() && ($row = $query->fetch()))
360 $query = $this->mysql->prepare($sql);
361 $query->bindValue(':feed', $this->id);
362 if ($query->execute())
364 while ($row = $query->fetchColumn())
392 …$query = $this->mysql->prepare('SELECT `mtime` FROM `' . $this->options['extras']['prefix'] . 'cac…
393 $query->bindValue(':id', $this->id);
394 if ($query->execute() && ($time = $query->fetchColumn()))
414 …$query = $this->mysql->prepare('UPDATE `' . $this->options['extras']['prefix'] . 'cache_data` SET …
415 $query->bindValue(':time', time());
416 $query->bindValue(':id', $this->id);
418 return $query->execute() && $query->rowCount() > 0;
433 …$query = $this->mysql->prepare('DELETE FROM `' . $this->options['extras']['prefix'] . 'cache_data`…
434 $query->bindValue(':id', $this->id);
438 return $query->execute() && $query2->execute();