Lines Matching refs:query
101 … $result = $this->pdo->query('SELECT ' . implode(',', $fields) . ' FROM ' . $this->tableName);
183 $query = "UPDATE " . $this->tableName . " SET ";
193 $query .= ', ';
196 $query .= $dbField . ' = :' . $dbField;
201 $query .= " WHERE uri = :uri";
204 $stmt = $this->pdo->prepare($query);
245 $query = 'SELECT uri FROM ' . $this->tableName . ' WHERE ';
259 if (count($values) > 0) $query .= (strcmp($test, "anyof") == 0 ? " OR " : " AND ");
260 $query .= 'lower(' . $column . ') LIKE lower(?)';
264 $stmt = $this->pdo->prepare($query);
308 $query = 'SELECT uri FROM ' . $this->tableName . ' WHERE lower(email)=lower(?)';
309 $stmt = $this->pdo->prepare($query);