---
title: "Query mit foreach auslesen"
url: "https://www.typo3.net/d/128311-query-mit-foreach-auslesen"
source: "typo3.net"
tags: ["Extensions","Entwicklung","Datenbank","Extbase","Frage","TYPO3 8"]
created: "2020-09-21"
last_reply: "2020-09-24"
replies: 1
solved: false
page: 1
pages: 1
lang: "de"
---

# Query mit foreach auslesen

Extensions › Entwicklung · 1 Antwort · gestartet 2020-09-21

## Eröffnungsbeitrag

**sanktusm** · 2020-09-21 · [Beitrag #1](https://www.typo3.net/d/128311-query-mit-foreach-auslesen/1)

Hallo,
ich möchte eine Abfrage aus der Datenbank (eine Tabelle) mit foreach auslesen.
Mein Controller sieht so aus:

```php
public function listAction()
    {




        if($this->request->hasArgument('search')) {

        $search = $this->request->getArgument('search');



        $coSmartSearches = $this->coSmartSearchRepository->findAll();

        $explode_res = Array();

        foreach($coSmartSearches as $key => $value) {

          $explode_res[$key] = explode('\n',$value);

        }

die(print_r($explode_res)); //gibt Array ( [0] => Array ( [0] => Covisionmedia\CoSmartsearch\Domain\Model\CoSmartSearch:0 ) ) aus 

        $field = 'SQL_NO_CACHE tt_content.uid, tt_content.tx_mask_searchkeys, tt_content.tx_mask_zubehoer_list, tt_content.header';
        $from  = 'tt_content';
        $where  = 'tt_content.header LIKE '."'" . '%' . $search . '%' ."'" . '';
        $groub_by = '';
        $order_by = 'tt_content.header ASC';
        $limit = '';


        $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery($field, $from, $where, $groub_by, $order_by, $limit);

        $this->view->assign('coSmartSearches', $res);

        }

    }
```

meine Repository so:

```php
<?php
namespace Covisionmedia\CoSmartsearch\Domain\Repository;




/***
 *
 * This file is part of the "covision smart search" Extension for TYPO3 CMS.
 *
 * For the full copyright and license information, please read the
 * LICENSE.txt file that was distributed with this source code.
 *
 *  (c) 2020
 *
 ***/

/**
 * The repository for CoSmartSearches
 */


use \TYPO3\CMS\Extbase\Persistence\Repository;


class CoSmartSearchRepository extends \TYPO3\CMS\Extbase\Persistence\Repository
{

public function findAll() {

$query = $this -> createQuery();

$query->statement('SELECT table_names, table_columns, table_joins FROM tx_cosmartsearch_domain_model_cosmartsearch');

return $query->execute();

}

}
```

## Antworten

### [#2](https://www.typo3.net/d/128311-query-mit-foreach-auslesen/2) · sanktusm · 2020-09-24

So geht es:

public function findAll() {

$query = $this -> createQuery();

$query->statement('SELECT tx_cosmartsearch_domain_model_cosmartsearch.table_names, tx_cosmartsearch_domain_model_cosmartsearch.table_columns, tx_cosmartsearch_domain_model_cosmartsearch.table_joins FROM tx_cosmartsearch_domain_model_cosmartsearch');

return $query->execute(true);

mit execute (true)

---

Quelle: „Query mit foreach auslesen“, typo3.net, https://www.typo3.net/d/128311-query-mit-foreach-auslesen
Beiträge von Mitgliedern des Forums. Bitte mit Link auf die Diskussion zitieren.