I dont understand why my variable is NULL

Asked Nov 19 '18 at 09:00

Active Nov 19 '18 at 14:19

Viewed 105 times

First of all, sorry my english isnt so good. So i have a problem, when i display my variable, he return me NULL and i dont know why :(

Label.php

class Services_Label extends Services_Abstract
{
    public function getlibelle()
    {
        $sRequest = 'SELECT NAME FROM menu WHERE id_application = 2';
        $this->executeQueries($sRequest);
        $aResult = $this->getAllRows();
        $this->freeStatement();
        return $aResult;
    }
}

IndexController.php

public function indexAction()
{
    $oMessage = new Services_Label();
    $toto = $oMessage->getlibelle();
    $this->view->newMenu12 = $toto;

    foreach ($toto as $data) {
        foreach($data as $key => $value) {
            echo $value[2] . '<br>';
        }
    }

Layout.php

<?php
echo $this->partial('/common/header.phtml', array(
    'notshowlogout' => (isset($this->notshowlogout) ? true : false),
    'profils' => $this->profils,
    'listeHabiUti' => $this->listeHabiUti,
    'libmenu' => $this->libmenu,
    'userName' => $this->userName,
    'siteName' => $this->siteName,
    'envName' => $this->envName,
    'newMenu12' => $this->newMenu12,
));
?>

header.php

<?php var_dump($this->newMenu12); ?>

Answer : NULL

edited Nov 19 '18 at 10:04

Vaios P.

asked Nov 19 '18 at 09:00

Nico

Maybe your query is failing? Does your mysql throws any error messages? – Andrea Golin Nov 19 '18 at 09:04
What's the value inside this: `$toto = $oMessage->getlibelle();`? – Praveen Kumar Purushothaman Nov 19 '18 at 09:07
Does `SELECT NAME FROM menu WHERE id_application = 2` return 0 rows? – Salman A Nov 19 '18 at 09:10
the query is working, normally it return me 13 row – Nico Nov 19 '18 at 09:13
the query is inside the value $toto – Nico Nov 19 '18 at 09:14
In ZF, you also need to pass a variable to the layout from the controller. They are not global variables: See answer from @Timothy Perez [here](https://stackoverflow.com/questions/18439364/how-to-pass-variables-to-layout-phtml-globally-in-zf2) – Jamie_D Nov 19 '18 at 11:05
`var_dump($toto = $oMessage->getlibelle());` – Kagiso Marvin Molekwa Nov 19 '18 at 14:04

I dont understand why my variable is NULL

0 Answers0

Linked

Related