Convert PHP array from mysql to JSON format

Question

I'm trying to convert the result array from Mysql to JSON format, the format doesn't seems to be correct, a comma is missing between each object. Please advice, thank you.

I'm aware that im using the deprecated version of php here.

$result = mysql_query("SELECT * FROM patientvaccinedetail")or 
die(mysql_error());

while($row = mysql_fetch_array( $result,MYSQL_ASSOC)) {


 $specific = ["message" => $row["message"],
              "mobile" => $row["mobile"]];

             print_r (json_encode($specific)); 
}

Current Result:

{"message":"hello","mobile":"12345678"}{"message":"hi","mobile":"87878965"}

Desired Result:

{"message":"hello","mobile":"12345678"}, {"message":"hi","mobile":"87878965"}

Your Desired Result: is not a valid json check here.

Jaydeep Mor
– Jaydeep Mor

2017-07-01 10:40:45 +00:00
Commented Jul 1, 2017 at 10:40 — Jaydeep Mor
– Jaydeep Mor, Commented Jul 1, 2017 at 10:40

Rajdeep Paul · Accepted Answer · 2017-07-01 10:38:58Z

4

You have to use array and at end of loop you have to echo result

$specific = array();
while($row = mysql_fetch_array( $result,MYSQL_ASSOC)) {
     $specific[] = ["message" => $row["message"],
                  "mobile" => $row["mobile"]];
}
echo json_encode($specific);

edited Jul 1, 2017 at 10:38

Rajdeep Paul

16.9k3 gold badges21 silver badges39 bronze badges

answered Jul 1, 2017 at 10:36

B. Desai

16.4k5 gold badges28 silver badges48 bronze badges

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

4 Comments

epiphany Over a year ago

And may i ask one more thing, can i remove $specific = array(); , as remove it will get the same result, so i'm just wondering whether it could be removed, thanks

B. Desai Over a year ago

Yes you can its only for array declaration. But its good practice to initialize array before you concate it.

epiphany Over a year ago

sorry , one more Can I still use print_r instead of echo?

B. Desai Over a year ago

Yes but preferable to use echo because the result is string.

Mayur Vora · Accepted Answer · 2017-07-01 19:34:31Z

0

Please moved json_encode() to outside of while loop.

$specific = array();
while($row = mysql_fetch_array( $result,MYSQL_ASSOC)) {
 $specific = ["message" => $row["message"],
              "mobile" => $row["mobile"]];          
}
print_r(json_encode($specific));

edited Jul 1, 2017 at 19:34

Mayur Vora

9822 gold badges14 silver badges25 bronze badges

answered Jul 1, 2017 at 10:43

yekyawaung

2112 silver badges7 bronze badges

Collectives™ on Stack Overflow

Convert PHP array from mysql to JSON format

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related