Adding array with MySQL inside a Multidimentional Array

Question

I am creating a json multidimentional Array for use in my jquery mobile panel and it works like a charm, but...

Now I want to make some af the panel list dynamic and get some af the data from database and I don't know how to do this?

Here is my static array:

$panels = array(
        array('list' => '<li><a href="../index.html">Start</a></li>'),
        array('list' => '<li><a href="#">My profile</a></li>'),
        array('list' => '<li><a href="#">Statistics</a></li>'),
        array('list' => '<li data-role="list-divider">My groups</li>'),
        array('list' => '<li><a href="pages/grouppage.html?groupid=1" rel="external">My first group</a></li> '),
        array('list' => '<li><a href="pages/grouppage.html?groupid=5" rel="external">I am testing again</a></li> '));

As you can see, my last 2 lists are the same and should come from my database depending on which user it is, but I don't know how to do this?

Hoping for help and thanks in advance :-)

Did you already designed a database structure. Its not clear what you already tried or what your question is. — S.Visser
– S.Visser, Commented Apr 16, 2013 at 9:05

open source guy · Accepted Answer · 2013-04-16 09:14:47Z

1

$database_data = "some data from database";
$data = array('list'=>$database_data);
$panels[] = $data ;

answered Apr 16, 2013 at 9:14

open source guy

2,78710 gold badges40 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rafee · Accepted Answer · 2013-04-16 09:13:53Z

0

This should work for you and write your query as per the requirement..

 while ($r = mysql_fetch_array($query)) {
    $arr[] = array(
                'list' => '<li><a href='" . $r['page_url'] . "'>" . $r['page_name'] . "</a></li>'
            );
 }

answered Apr 16, 2013 at 9:13

Rafee

4,0868 gold badges61 silver badges89 bronze badges

Collectives™ on Stack Overflow

Adding array with MySQL inside a Multidimentional Array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related