Storing data from MySQL to PHP Array to return with JSON

Question

I am trying to get the data in the table to a php array and then return via JSON so the array can be used in the JS document requesting the PHP/MySQL Data. Respective of row and columns/index.

So far i have:

$sql = 'SELECT *
         FROM btn_color_presets
         ';

$result = mysqli_query($sql);

$array = array(); // 

while($row = mysql_fetch_assoc($result)) // 
{
     $array[] = $row;
     $index++;
}

Q. Now i wish to return a JSON Array made from the array of data. How do i proceed here?

Note: I am horrible with arrays and not entirely sure i have the correct method above for my requirements, but i think it is correct.

You don't need $index, just use $array[] = $row to add a new element to an array. — Barmar
– Barmar, Commented Jul 13, 2014 at 19:03

Barmar · Accepted Answer · 2014-07-13 19:04:58Z

2

Call json_encode after the loop:

header("Content-type: application/json");
echo json_encode($array);

answered Jul 13, 2014 at 19:04

Barmar

789k57 gold badges554 silver badges669 bronze badges

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

1 Comment

Derple Over a year ago

Ah brilliant so i was along the right lines. Thanks Barmar!

Collectives™ on Stack Overflow

Storing data from MySQL to PHP Array to return with JSON

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related