Zend FR

<?php
namespace Custom\Model;

use Zend\Db\TableGateway\TableGateway;
use Zend\Db\Adapter\Exception\InvalidQueryException;

class AlimentTable
{
    /**
     * @var TableGateway
     */
    protected $tableGateway;    

    public function __construct(TableGateway $tableGateway)
    {
        $this->tableGateway = $tableGateway;
    }

    public function getAdapter()
    {
        return $this->tableGateway->getAdapter();
    }
    
    public function getAll()
    {
        $select = new \Zend\Db\Sql\Select();
        $select->from($this->tableGateway->getTable());

        return $select;
    }

    public function getAliment($id)
    {
        $id  = (int)$id;
        $rowset = $this->tableGateway->select(array('id_aliment' => $id));
        $row = $rowset->current();

        if (!$row) {
            throw new \Exception("Could not find row $id");
        }

        return $row;
    }

    public function saveAliment(Aliment $aliment)
    {
        $data = array(
            'id_aliment' => $aliment->id_aliment,
            'nom_aliment'  => $aliment->nom_aliment,
            'nom_categorie' => $aliment->nom_categorie,
            'nom_sous_categorie' => $aliment->nom_sous_categorie,
            'description' => $aliment->description,
            'prix' => $aliment->prix,
        );

        $id = (int)$aliment->id_aliment;

        if ($id == 0) {
            $this->tableGateway->insert($data);
        } elseif ($this->tableGateway->getAliment($id)) {
            $this->tableGateway->update(
                $data,
                array(
                    'id_aliment' => $id,
                )
            );
        } else {
            throw new \Exception('Form id does not exist');
        }
    }

    public function deleteAliment($id)
    {
        $this->tableGateway->delete(array('id_aliment' => $id));
    }
}

<?php
namespace Front\Controller;

use Zend\View\Model\ViewModel;

use Custom\Controller\CustomController;

class CarteController extends CustomController
{
    public function indexAction()
    {
        return new ViewModel(
            array(
                'aliments' => $this->alimentTable->getAll(),
                //'cats' => $this->categorieTable->getAll(),
                //'subCats' => $this->sousCategorieTable->getAll(),
            )
        );
    }
}

<?php
print_r($aliments);
?>

Zend\Db\Sql\Select Object ( [specifications:protected] => Array ( [select] => Array ( [SELECT %1$s FROM %2$s] => Array ( [0] => Array ( [1] => %1$s [2] => %1$s AS %2$s [combinedby] => , ) [1] => ) [SELECT %1$s %2$s FROM %3$s] => Array ( [0] => [1] => Array ( [1] => %1$s [2] => %1$s AS %2$s [combinedby] => , ) [2] => ) ) [joins] => Array ( [%1$s] => Array ( [0] => Array ( [3] => %1$s JOIN %2$s ON %3$s [combinedby] => ) ) ) [where] => WHERE %1$s [group] => Array ( [GROUP BY %1$s] => Array ( [0] => Array ( [1] => %1$s [combinedby] => , ) ) ) [having] => HAVING %1$s [order] => Array ( [ORDER BY %1$s] => Array ( [0] => Array ( [1] => %1$s [2] => %1$s %2$s [combinedby] => , ) ) ) [limit] => LIMIT %1$s [offset] => OFFSET %1$s ) [tableReadOnly:protected] => [prefixColumnsWithTable:protected] => 1 [table:protected] => aliment [quantifier:protected] => [columns:protected] => Array ( [0] => * ) [joins:protected] => Array ( ) [where:protected] => Zend\Db\Sql\Where Object ( [unnest:protected] => [nextPredicateCombineOperator:protected] => [defaultCombination:protected] => AND [predicates:protected] => Array ( ) ) [order:protected] => Array ( ) [group:protected] => [having:protected] => Zend\Db\Sql\Having Object ( [unnest:protected] => [nextPredicateCombineOperator:protected] => [defaultCombination:protected] => AND [predicates:protected] => Array ( ) ) [limit:protected] => [offset:protected] => [processInfo:protected] => Array ( [paramPrefix] => [subselectCount] => 0 ) [instanceParameterIndex:protected] => Array ( ) )

foreach($aliments as aliment) {
    print_r($aliment);
}