$outp = "";
while($rs = $result->fetch_array(MYSQLI_ASSOC)) {
if ($outp != "") {$outp .= "";}
$outp .= '{"Portrait":"' . $rs["Portrait"] . '",';
$outp .= '"First Name":"' . $rs["FName"] . '",';
$outp .= '"Last Name":"' . $rs["LName"] . '",';
$outp .= '"DOI":"'. $rs["DOI"] . '",';
$outp .= '"MOI":"'. $rs["MOI"] . '",';
$outp .= '"YOI":"'. $rs["YOI"] . '",';
$outp .= '"ID":"'. $rs["id"] . '"}';
}
$outp ='{"records":['.$outp.']}';
Hi for the above PHP code the output looks like this JSON format
{
"records": [{
"Portrait": "image1.png",
"First Name": "Dave",
"Last Name": "Smith",
"DOI": "20",
"MOI": "0",
"YOI": "2017",
"ID": "1"
} {
"Portrait": "image2.png",
"First Name": "Sally",
"Last Name": "Jones",
"DOI": "20",
"MOI": "0",
"YOI": "2009",
"ID": "2"
}]
}
and this doesn't validate because there should be comma in between records like this:
{
"records": [{
"Portrait": "image1.png",
"First Name": "Dave",
"Last Name": "Smith",
"DOI": "20",
"MOI": "0",
"YOI": "2017",
"ID": "1"
}, {
"Portrait": "image2.png",
"First Name": "Sally",
"Last Name": "Jones",
"DOI": "20",
"MOI": "0",
"YOI": "2009",
"ID": "2"
}]
}
I am trying to figure out how to get a comma added between records without also adding it at the end, b/c that is invalid also.
Any ideas?