Lines Matching refs:query
67 $query = 'SELECT tag
71 $resid = $this->sqlitehelper->getDB()->query($query, $this->pid);
104 $query = 'SELECT COUNT(tag) AS tagcount
108 $resid = $this->sqlitehelper->getDB()->query($query, $pid);
127 $query = 'SELECT tags.tag AS tag, tags.pid AS pid
133 $resid = $this->sqlitehelper->getDB()->query($query);
146 $query = 'BEGIN TRANSACTION';
147 if (!$this->sqlitehelper->getDB()->query($query)) {
148 $this->sqlitehelper->getDB()->query('ROLLBACK TRANSACTION');
151 $query = 'DELETE FROM tags WHERE pid = ?';
152 if (!$this->sqlitehelper->getDB()->query($query, $this->pid)) {
153 $this->sqlitehelper->getDB()->query('ROLLBACK TRANSACTION');
157 $query = 'INSERT INTO tags (pid, tag) VALUES (?, ?)';
158 if (!$this->sqlitehelper->getDB()->query($query, $this->pid, $tag)) {
159 $this->sqlitehelper->getDB()->query('ROLLBACK TRANSACTION');
163 $query = 'END TRANSACTION';
164 if (!$this->sqlitehelper->getDB()->query($query)) {
165 $this->sqlitehelper->getDB()->query('ROLLBACK TRANSACTION');