how can produce json array with while in php

Question

i want return my data from mysql to json array with do while loop. when i return one record with json it is well. but i want return list of array in one json array. how can do that with index in while? my code have error and i don't know how can do it. with one record it is well but more can't.

 $json="array(";
  do{
    $json=."'$row_query['id']'=>array('fname'=>$row_query['fname'],'lname'=>$row_query['lname']),";

 } while ($row_query = mysqli_fetch_assoc($query));
 json=.")";
echo json_encode($json,JSON_UNESCAPED_UNICODE);

The do-while loop is incorrect - in the first iteration, there's no $row_query, as this var is set after the first iteration — Philipp
– Philipp, Commented Nov 12, 2017 at 10:07

u_mulder · Accepted Answer · 2017-11-12 09:54:55Z

4

There's no need to add quotes, brackets, parentheses or whatever. json_encode function will do it for you. Just provide an array to it:

$json = [];
while ($row_query = mysqli_fetch_assoc($query)) {
    $json[$row_query['id']] = [
        'fname'=>$row_query['fname'],
        'lname'=>$row_query['lname'],
    ];
}
echo json_encode($json,JSON_UNESCAPED_UNICODE);

answered Nov 12, 2017 at 9:54

u_mulder

54.8k5 gold badges54 silver badges72 bronze badges

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

Comments

Jakir Hossen · Accepted Answer · 2017-11-12 10:03:45Z

1

This is the most super easy version. You may try this.

$json = new array();
do{
array_push($json,$row_query);
} while ($row_query = mysqli_fetch_assoc($query));

or

$json = [];
do{
 $json[] = $row_query;
} while ($row_query = mysqli_fetch_assoc($query));

Atlast encode your json variable.

$json = json_encode($json);
echo $json;

answered Nov 12, 2017 at 10:03

Jakir Hossen

4614 silver badges13 bronze badges

Collectives™ on Stack Overflow

how can produce json array with while in php

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related