Really simple PHP array key-value issue

Question

Let's say I have the following table in my database:

Name        | Description      | Image

App         | Some description | somefile.png
Another App | Another descript | anotherfile.png

What I want to do is create a JSON array like this:

{
    "App": {
        "name": "App",
        "description": "Some description",
        "Image": "somefile.png"
    },
    "Another App": {
        "name": "Another App",
        "description": "Another descript",
        "Image": "anotherfile.png"
    }
}

What I'm struggling with is pushing the key>value pair on. I can push just the value, with a non-keyed array, but I cannot push the key>value pair onto my array.

What I've tried:

$res = mysql_query('SELECT * FROM `apps`;');
if ($res) {
    $temp = array();
    while ($row = mysql_fetch_array($res)) {
        $name = $row['name'];
        $descript = $row['description'];
        $img = $row['image'];
        $new = array('name'=>$name,'description'=>$descript,'img'=>$img);
        array_push($temp,$new); // how do I make this push with a key?
    }
}
echo json_encode($temp);

My problem is with the array_push() function - I want it to push with the name as the key but I can't get it to.

array_push() will create a stack, not an associative array, which means it's not what you want. Just use a keyed value and set it to your keyed/associative array. — Jared Farrish
– Jared Farrish, Commented Sep 30, 2011 at 22:38
This was already answered here stackoverflow.com/questions/2121548/… — Mark
– Mark, Commented Sep 30, 2011 at 22:40

drew010 · Accepted Answer · 2011-09-30 22:38:53Z

2

Try this:

while ($row = mysql_fetch_array($res)) {
    $name     = $row['name'];
    $descript = $row['description'];
    $img      = $row['image'];

    $temp[$name] = array('name'=>$name,'description'=>$descript,'img'=>$img);
}

answered Sep 30, 2011 at 22:38

drew010

70.3k11 gold badges144 silver badges174 bronze badges

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

1 Comment

Alex Coplan Over a year ago

thank you very much - I can't believe I didn't think of that!

Collectives™ on Stack Overflow

Really simple PHP array key-value issue

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related