Merging two json in PHP
Something like json_encode(array_merge(json_decode($a, true),json_decode($b, true)))
should work.
array_merge in official PHP documentation
json_decode in official PHP documentation
EDIT: try adding true
as second parameter to json_decode. That'll convert objects to associative arrays.
EDIT 2: try array-merge-recursive
and see my comment below. Sorry have to log out now :(This looks like a full correct solution: https://stackoverflow.com/a/20286594/1466341
Managed to throw this together. There is most likely a better solution, but this is the closest I got.
$a = '[{"COLUMN_NAME":"ORDER_NO","COLUMN_TITLE":"Order Number"},{"COLUMN_NAME":"CUSTOMER_NO","COLUMN_TITLE":"Customer Number"}]';$b = '[{"COLUMN_NAME":"ORDER_NO","DEFAULT_VALUE":"1521"},{"COLUMN_NAME":"CUSTOMER_NO","DEFAULT_VALUEE":"C1435"}]';$r = [];foreach(json_decode($a, true) as $key => $array){ $r[$key] = array_merge(json_decode($b, true)[$key],$array);}echo json_encode($r);
returns,
[{"COLUMN_NAME":"ORDER_NO","DEFAULT_VALUE":"1521","COLUMN_TITLE":"Order Number"},{"COLUMN_NAME":"CUSTOMER_NO","DEFAULT_VALUEE":"C1435","COLUMN_TITLE":"Customer Number"}]
This works like a charm for me
json_encode(array_merge(json_decode($a, true),json_decode($b, true)))
here is a full example
$query="SELECT * FROM `customer` where patient_id='1111118'";$mysql_result = mysql_query($query);$rows = array();while($r = mysql_fetch_assoc($mysql_result)) { $rows[] = $r;}$json_personal_information=json_encode($rows);//echo $json_personal_information;$query="SELECT * FROM `doctor` where patient_id='1111118'";$mysql_result = mysql_query($query);$rows = array();while($r = mysql_fetch_assoc($mysql_result)) { $rows[] = $r;}$json_doctor_information=json_encode($rows);//echo $json_doctor_information;echo $merger=json_encode(array_merge(json_decode($json_personal_information, true),json_decode($json_doctor_information, true)));