在数组中使用foreach

Question

im currently trying to generate a dynamic subnavigation. Therefor i pull data off of the database and store some of it an an array. Now i want to do an foreach in this array. Well as far as I know, this isn't possible.

But maybe I'm wrong. I would like to know if it would be possible, and if so how do i do it?

This is my code, which wont work since it hands out an syntax error.

$this->subnav = array(
                        '' => array(
                            'Test Link'     => 'login.php',
                            'Badged Link'   => array('warning',10023,'check.php')
                        ),
                        'benutzer'      => array(
                            'Benutzer suchen'       => '/mother/index.php?page=benutzer&subpage=serach_user',
                            'Benutzer hinzufügen'   => '/mother/index.php?page=benutzer&subpage=add_user',
                            'Rechtevergabe'         => '/mother/index.php?page=benutzer&subpage=user_rights'
                        ),
                        'logout'        => array(
                            'Login'     => '/mother/login.php',
                            'Logout'    => '/mother/index.php?page=logout'
                        ),
                        'datenbank'        => array(
                             (foreach($this->system->get_databases() as $db){array($db->name => $db->url)}),
                            'Deutschland'           => '/mother/login.php',
                            'Polen'                 => '/mother/index.php',
                            'Spanien'               => '/mother/index.php',
                            'Datenbank hinzufügen'  => '/mother/index.php?page=datenbank&subpage=add_database'
                        )
                    );
}

Answer 1

You can't place foreach loop inside an array like this. You can do something like this though.

foreach($this->system->get_databases() as $db)
{
    $this->subnav['datenbank'][$db->name] = $db->url;
}