Replace column namne with custom name with json_encode

Question

I'm bringing json_encode data from the db.

foreach ($rslt as $val){
  $data[] = $val; 
}
echo json_encode($data);

the output is [{"column name":"dbData1"},{"column name":"dbData2"}]

Instead of the column name can I replace it to a custom name?

expected output:

[{"rec":"dbData1"},{"rec":"dbData2"}]

Federico · Accepted Answer · 2015-07-03 07:03:08Z

2

Something like this :

foreach ($rslt as $val){
    $data[] = array('rec'=>$val['column name']); 
}
echo json_encode($data);

answered Jul 3, 2015 at 7:03

Federico

1,2519 silver badges14 bronze badges

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

Comments

Cyclotron3x3 · Accepted Answer · 2015-07-03 07:06:35Z

0

<?php
$arr = array('rec' => $val["col_name"], 'rec' => $val["col_name2"]);

echo json_encode($arr);
?>

answered Jul 3, 2015 at 7:06

Cyclotron3x3

2,2491 gold badge29 silver badges41 bronze badges