Contao\Database::query PHP Метод

query() публичный Метод

Execute a raw query and return a Database\Result object
public query ( string $strQuery ) : Result | object
$strQuery string The query string
Результат Contao\Database\Result | object The Database\Result object
    public function query($strQuery)
    {
        $objStatement = new \Database\Statement($this->resConnection, $this->blnDisableAutocommit);
        return $objStatement->query($strQuery);
    }

Usage Example

Пример #1
0
 /**
  * Convert iso_filterFields configuration for new cumulative filter
  */
 private function updateCumulativeFilterFields()
 {
     if ($this->createDatabaseField('iso_cumulativeFields', 'tl_module')) {
         $modules = $this->db->query("SELECT id, iso_filterFields FROM tl_module WHERE type='iso_cumulativefilter'");
         while ($modules->next()) {
             $fields = deserialize($modules->iso_filterFields);
             if (!empty($fields) && is_array($fields)) {
                 $config = array();
                 foreach ($fields as $field) {
                     $config[] = array('attribute' => $field, 'queryType' => 'and', 'matchCount' => 'none');
                 }
                 $this->db->prepare("UPDATE tl_module SET iso_cumulativeFields=? WHERE id=?")->execute(serialize($config), $modules->id);
             }
         }
     }
 }
All Usage Examples Of Contao\Database::query