How do I add an array to a multidimensional array?

Question

How do I append arrays to a multidimensional array? When it goes through the loop, it needs to add the data as an array to create multiple arrays. It encodes to json and sends to an Android phone.

Relevant code:

$data = array(
    "articles" => array(
        array(
            'id'=> "4335",
            'cat'=> "Lifestyle",
            'title'=> "Welcome to field and rural life",
            'url'=> "http://www.fieldandrurallife.com"

        ),
        array(
            'id'=> "4336",
            'cat'=> "Lifestyle",
            'title'=> "Thank You",
            'url'=> "www.thankyou.com"

        )
    )
);

while($row = mysql_fetch_array($sql))
{
    $id = $row["id"]; 
    $cat = $row["category"];
    $title = $row["title"];  
    $url = $row["url"];

    // HOW DO I ADD THIS INTO THE ARTICLES ARRAY??
//    array(
//       'id'=> $id,
//        'cat'=> $cat,
//        'title'=> $title,
//        'url'=> $url
//      )

}

$data['articles'][] = array('id'=> $id, 'cat'=> $cat, 'title'=> $title, 'url'=> $url); — user20232359723568423357842364
– user20232359723568423357842364, Commented Jul 9, 2013 at 13:57

pirs · Accepted Answer · 2016-02-20 20:44:54Z

2

Simply:

while($row = mysql_fetch_array($sql)){
    $id = $row["id"]; 
    $cat = $row["category"];
    $title = $row["title"];  
    $url = $row["url"];

    $data['articles'][] = array(
                          'id'=> $id,
                          'cat'=> $cat,
                          'title'=> $title,
                          'url'=> $url
    )

}

edited Feb 20, 2016 at 20:44

answered Jul 9, 2013 at 14:01

pirs

2,4612 gold badges20 silver badges25 bronze badges

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

Comments

koerbcm · Accepted Answer · 2013-07-09 14:02:51Z

1

Try using array_push with json_encode

When you pull from the database, if you only pull the columns you need, then just push the row directly onto the array, since it's already an array.

while($row = mysql_fetch_array($sql))
{
    // Add your new array to the array
    array_push($data['articles'], $row);
}

// Then you can encode your array to JSON like so.
$json_version = json_encode($data);

answered Jul 9, 2013 at 14:02

koerbcm

3401 gold badge2 silver badges13 bronze badges

Comments

Casey · Accepted Answer · 2013-07-09 14:19:37Z

0

Use php's method:

array_push($data["article"], $row);

edited Jul 9, 2013 at 14:19

Casey

42.9k7 gold badges101 silver badges127 bronze badges

answered Jul 9, 2013 at 14:00

Ashish Chopra

1,4599 silver badges24 bronze badges

Collectives™ on Stack Overflow

How do I add an array to a multidimensional array?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related