Mapping Mysql Result to Custom Json Format

Question

I am trying to mapping the mysql result into json encode, but the result is not as i want.

Results From the Mysql Query

print_r($data)

If I use echo json_encode($data); The Result like This:

[
  {
    "Bulan": "Januari",
    "Total": "1",
    "Langsung": "0",
    "Delivery": "1",
    "Dropship": "0"
  },
  {
    "Bulan": "Februari",
    "Total": "24",
    "Langsung": "19",
    "Delivery": "4",
    "Dropship": "1"
  },
  {
    "Bulan": "Maret",
    "Total": "0",
    "Langsung": "0",
    "Delivery": "0",
    "Dropship": "0"
  },
  {
    "Bulan": "April",
    "Total": "0",
    "Langsung": "0",
    "Delivery": "0",
    "Dropship": "0"
  },
  {
    "Bulan": "Mei",
    "Total": "0",
    "Langsung": "0",
    "Delivery": "0",
    "Dropship": "0"
  },
  {
    "Bulan": "Juni",
    "Total": "0",
    "Langsung": "0",
    "Delivery": "0",
    "Dropship": "0"
  },
  {
    "Bulan": "Juli",
    "Total": "0",
    "Langsung": "0",
    "Delivery": "0",
    "Dropship": "0"
  },
  {
    "Bulan": "Agustus",
    "Total": "0",
    "Langsung": "0",
    "Delivery": "0",
    "Dropship": "0"
  },
  {
    "Bulan": "September",
    "Total": "0",
    "Langsung": "0",
    "Delivery": "0",
    "Dropship": "0"
  },
  {
    "Bulan": "Oktober",
    "Total": "0",
    "Langsung": "0",
    "Delivery": "0",
    "Dropship": "0"
  },
  {
    "Bulan": "November",
    "Total": "0",
    "Langsung": "0",
    "Delivery": "0",
    "Dropship": "0"
  },
  {
    "Bulan": "Desember",
    "Total": "0",
    "Langsung": "0",
    "Delivery": "0",
    "Dropship": "0"
  }
]

My Expected Like This:

{
        "Bulan"     : ["Januari", "Februari", "Maret", "April","Mei","Juni","Juli","Agustus","September","Oktober","November","Desember"],
        "Total"     : [1,24,0,0,0,0,0,0,0,0,0,0,0],
        "Langsung"  : [0,19,0,0,0,0,0,0,0,0,0,0,0],
        "Delivery"  : [1,4,0,0,0,0,0,0,0,0,0,0,0],
        "Dropship"  : [0,1,0,0,0,0,0,0,0,0,0,0,0]
      }

Is possible to do that?

Thanks in advance

can u explain to me, how to do that?

Abu Ayyub
– Abu Ayyub

2017-02-07 15:57:49 +00:00
Commented Feb 7, 2017 at 15:57 — Abu Ayyub
– Abu Ayyub, Commented Feb 7, 2017 at 15:57
Do your while and add values to array.

u_mulder
– u_mulder

2017-02-07 15:58:54 +00:00
Commented Feb 7, 2017 at 15:58 — u_mulder
– u_mulder, Commented Feb 7, 2017 at 15:58

Dimi · Accepted Answer · 2017-02-07 16:10:58Z

1

there are many ways.. without testing anything i think it should look something like this

$output=array();
foreach($data as $entry)
foreach($entry as $k=>$v)
{
if(!is_array($output[$k]))
$output[$k]=array();
$output[$k][]=$v;
}

print_r($output);
echo json_encode($output);

the output that i get is the following

{"Bulan":["Januari","Februari","Maret","April","Mei","Juni","Juli","Agustus","September","Oktober","November","Desember"],
"Total":["1","24","0","0","0","0","0","0","0","0","0","0"],
"Langsung":["0","19","0","0","0","0","0","0","0","0","0","0"],
"Delivery":["1","4","0","0","0","0","0","0","0","0","0","0"],
"Dropship":["0","1","0","0","0","0","0","0","0","0","0","0"]}.

full code used:

<?php

$data=json_decode('[
  {
    "Bulan": "Januari",
    "Total": "1",
    "Langsung": "0",
    "Delivery": "1",
    "Dropship": "0"
  },
  {
    "Bulan": "Februari",
    "Total": "24",
    "Langsung": "19",
    "Delivery": "4",
    "Dropship": "1"
  },
  {
    "Bulan": "Maret",
    "Total": "0",
    "Langsung": "0",
    "Delivery": "0",
    "Dropship": "0"
  },
  {
    "Bulan": "April",
    "Total": "0",
    "Langsung": "0",
    "Delivery": "0",
    "Dropship": "0"
  },
  {
    "Bulan": "Mei",
    "Total": "0",
    "Langsung": "0",
    "Delivery": "0",
    "Dropship": "0"
  },
  {
    "Bulan": "Juni",
    "Total": "0",
    "Langsung": "0",
    "Delivery": "0",
    "Dropship": "0"
  },
  {
    "Bulan": "Juli",
    "Total": "0",
    "Langsung": "0",
    "Delivery": "0",
    "Dropship": "0"
  },
  {
    "Bulan": "Agustus",
    "Total": "0",
    "Langsung": "0",
    "Delivery": "0",
    "Dropship": "0"
  },
  {
    "Bulan": "September",
    "Total": "0",
    "Langsung": "0",
    "Delivery": "0",
    "Dropship": "0"
  },
  {
    "Bulan": "Oktober",
    "Total": "0",
    "Langsung": "0",
    "Delivery": "0",
    "Dropship": "0"
  },
  {
    "Bulan": "November",
    "Total": "0",
    "Langsung": "0",
    "Delivery": "0",
    "Dropship": "0"
  },
  {
    "Bulan": "Desember",
    "Total": "0",
    "Langsung": "0",
    "Delivery": "0",
    "Dropship": "0"
  }
]',true);

$output=array();
foreach($data as $entry)
foreach($entry as $k=>$v)
{
if(!is_array($output[$k]))
$output[$k]=array();
$output[$k][]=$v;
}

print_r($output);
echo str_replace('],',"],\n",json_encode($output));

edited Feb 7, 2017 at 16:10

answered Feb 7, 2017 at 15:59

Dimi

1,27711 silver badges21 bronze badges

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

1 Comment

Abu Ayyub Over a year ago

the result like this {"":["Januari","1","0","1","0","Februari","24","19","4","1","Maret","0","0","0","0","April","0","0","0" ,"0","Mei","0","0","0","0","Juni","0","0","0","0","Juli","0","0","0","0","Agustus","0","0","0","0","September" ,"0","0","0","0","Oktober","0","0","0","0","November","0","0","0","0","Desember","0","0","0","0"]}

Collectives™ on Stack Overflow

Mapping Mysql Result to Custom Json Format

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related