Creating an associative array in PHP from sql results, for json

Question

I'm trying to create an associative array from sql results for json_encode.

here's my code:

$timelineQuery = "SELECT * FROM timeline_table";
$contentQuery = "SELECT * FROM content_table";
$picQuery = "SELECT * FROM pic_table";

$sql = mysql_query($timelineQuery) or die(mysql_error()); 
$sql2 = mysql_query($contentQuery) or die(mysql_error());
$sql3 = mysql_query($picQuery) or die(mysql_error());   

$mainArray = array(
    'timeline' => $timelineArray = array(
        'content' => $contentArray = array(
            'pictures' => $picArray = array(),
        ),
    ),
);

while($row = mysql_fetch_assoc($sql)) { 
    $timelineArray[] = $row;            
}
while($row2 = mysql_fetch_assoc($sql2)) {
    $contentArray[] = $row2;
}
while($row3 = mysql_fetch_assoc($sql3)) {
    $picArray[] = $row3;
}
echo stripslashes(json_encode($mainArray));

If I json_encode my $mainArray as it is, the returned json has the syntax I'm looking for, but I've not been able to fill the array without adding it to the end of my array.

{"timeline":{"content":{"pictures":[]}}}

Andrej Bestuzhev · Accepted Answer · 2013-01-30 13:41:49Z

4

first:

while($row = mysql_fetch_assoc($sql)) { 
    $timelineArray[] = $row;            
}
while($row2 = mysql_fetch_assoc($sql2)) {
    $contentArray[] = $row2;
}
while($row3 = mysql_fetch_assoc($sql3)) {
    $picArray[] = $row3;
}

then:

    $mainArray = array(
        'timeline' => $timelineArray = array(
            'content' => $contentArray = array(
                'pictures' => $picArray = array(),
            ),
        ),
    );
echo stripslashes(json_encode($mainArray));

you defined your array with empty arrays and didn't renew it's states.

answered Jan 30, 2013 at 13:41

Andrej Bestuzhev

6746 silver badges10 bronze badges

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

3 Comments

Peon Over a year ago

And why do you propose to reset the array at the end?

Andrej Bestuzhev Over a year ago

sorry, mistake: timeline = array('content' => array('pictures' => $picArray())); it will coresponds to you structure: {"timeline":{"content":{"pictures":[]}}}, so you really don't need to do first two queries.

user2025462 Over a year ago

Thank you for your answer! However, I might have formulated my question too vaguely. What I'm struggling with, is how to build a three-dimensional array from my 3 arrays, or 3 sql-queries. I am able to create an empty 3-dimensional array in PHP and encoding it to json, which then gives me the structure I want.

Collectives™ on Stack Overflow

Creating an associative array in PHP from sql results, for json

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related