Get specific formatted JSON from PHP Query

Question

I want to get an array like this:

{
    "version": "1397992135_1932",
    "list": {
        "20514072":["John Carter","FiExJGIpsek.jpg",1],
        "7247045":["Joe Satriani","KzvE54Z4rlA.jpg",0],
        "91120813":["Mikel Arteta","JnPwkLKGeCA.jpg",1]
    }
}

In database I have simple rows:

id | name | photo | vip

How can I format result from query to what I want?

Update

I don't truly understand how to code this to fetch the data from DB if I have 100 records.

you should post your solution as answer and accept it

Joshua
– Joshua

2014-04-24 06:31:51 +00:00
Commented Apr 24, 2014 at 6:31 — Joshua
– Joshua, Commented Apr 24, 2014 at 6:31

Skewled · Accepted Answer · 2014-04-24 04:24:38Z

1

This would be the array setup required to achieve the JSON string you are looking for:

$data = array(
        "version" => "1397992135_1932",
        "list" =>
    array(
        "20514072" => array(
        "John Carter",
        "iExJGIpsek.jpg",
         "1"
         ),
        "7247045" => array(
        "Joe Satriani",
        "KzvE54Z4rlA.jpg",
        "0"
        ),
        "91120813" => array(
        "Mikel Arteta",
        "JnPwkLKGeCA.jpg",
        "1"
    ))
);

echo "<pre>";   
echo json_encode($data);
echo "</pre>";
?>

OUTPUTS:

{
    "version":"1397992135_1932",
    "list":{
        "20514072":["John Carter","iExJGIpsek.jpg","1"],
        "7247045":["Joe Satriani","KzvE54Z4rlA.jpg","0"],
        "91120813":["Mikel Arteta","JnPwkLKGeCA.jpg","1"]
    }
}

answered Apr 24, 2014 at 4:24

Skewled

7834 silver badges12 bronze badges

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

3 Comments

user711227 Over a year ago

Yes, sure. My fault. My answer is not correct. How can I get it through PHP (fetch..?) if I have 100 records?

Skewled Over a year ago

I see you want the PHP code to fetch the data and than restructure the array for the format I posted in my answer? Your question was not clear on that part.

user711227 Over a year ago

Yes, you're right! And my question was not clear, right again(

user711227 · Accepted Answer · 2014-04-24 13:44:42Z

1

OK, I found the solution for dynamic array =)

$list = array();
while ($row = $result->fetch_array()) {
    $list[$row['id']] = array($name,$photo,$vip);
}

answered Apr 24, 2014 at 13:44

user711227

135 bronze badges

Collectives™ on Stack Overflow

Get specific formatted JSON from PHP Query

2 Answers 2

3 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Related