返回字符串json编码的php文件没有用

Question

I have an php file that gives me the response i need as a string, i need it to be an array encoded in json, im not that good with php, can any one help ? this is how it works fine as a string - printf("user: \"%s\" \"%s\" email: \"%s\" ", $row['firstname'], $row['lastname'],$row['email']);

But i need it as an array in json that is how i tried to do it -array_push($mynewArray,array("firstname \%s"=>$row['firstname'],"lastname \%s"=>$row['lastname'],"email \%s"=>$row['email'])); echo json_encode($mynewArray);

this is the screen shot that shows how i tried to do it

Answer 1

I think you could try like this assuming the recordset is generated correctly and available in the var $row

$mynewArray=array();
foreach($result as $row){
    $mynewArray[]=$row;
}
echo json_encode($mynewArray);


Or

$mynewArray=array();
foreach( $result as $row ){
    $mynewArray[]=array(
        'firstname'=>$row['firstname'],
        'lastname'=>$row['lastname'],
        'email'=>$row['email'],
    );
}
echo json_encode($mynewArray);