合并由php中的while循环创建的json数组，从数据库中获取值

Question

I am getting two JSON arrays that I need merged each time a while loop runs a fetch from my database. This is the structure array result I am getting as of now:

{id=1,cid=1,fname=Lorna,vorname=King,gender=female,dob=1985,company=helsana,monthly_amount=150},
{id=2,cid=1,fname=Brian,vorname=King,gender=male,dob=2007,company=helsana,monthly_amount=100}

I need it to look like this:

{id={1,2},cid={1,1},fname={Lorna,Brian},vorname={King,King},gender={female,male},dob={1985,2007},company={helsana,helsana},monthly_amount={150,100}}

Here is the PHP code that I am using:

<?php
include_once "conn.php";
$show= $mysqli->query("SELECT id,cid,fname,vorname,gender,dob,company,monthly_amount FROM family where cid = '1' ");
$arr = array();
while($row = $show->fetch_assoc()){
    $arr[] = $row;
}
$json_response = json_encode($arr, JSON_HEX_TAG | JSON_HEX_APOS | JSON_HEX_QUOT | JSON_HEX_AMP);
echo $str = substr($json_response, 1,-1);
?>

Am kinda new to this please someone help me out.

Answer 1

I would seriously recommend against what you're asking. There's a good reason why those results are separate.

Anyway to answer your question here's a way - but again unless there's a specific reason why you want to so this I'd think instead about how you are handling the JSON instead.

Here, I'm just using the first row to set up the array and then manually concatenating the data.

<?php
include_once "conn.php";
$show= $mysqli->query("SELECT id,cid,fname,vorname,gender,dob,company,monthly_amount FROM           family where cid = '1' ");
$arr = array();
$arr[] = $show->fetch_assoc();
while($row = $show->fetch_assoc()){
  $arr['id'] .= ',' . $row['id'];
  $arr['cid'] .= ',' . $row['cid'];
  $arr['dob'] .= ',' . $row['dob'];
  $arr['company'] = ',' . $row['company'];
  $arr['monthly_amount'] = ',' . $row['monthly_amount'];
  $arr['vorname'] = ',' . $row['vorname'];
  $arr['fname'] = ',' . $row['fname'];
} 
$json_response = json_encode($arr, JSON_HEX_TAG | JSON_HEX_APOS | JSON_HEX_QUOT | JSON_HEX_AMP);
echo $str = substr($json_response, 1,-1);