如何在php中拆分JSON数组

Question

I manage to get the data I want from database using array_push and encode it into JSON in PHP. The results I get are like below,

{
"name":[
    "Lucky Draw Ticket",
    "KIP Voucher RM10",
    "KIP Voucher RM20",
    "KIP Voucher RM50"
],
"image":[
    "\/l\/u\/lucky_draw_ticket_1.jpg",
    "\/c\/a\/cash-voucher.jpg",
    "\/c\/a\/cash-voucher2.jpg",
    "\/c\/a\/cash-voucher50_1.jpg"
],
"price":[
    "50.0000",
    "1500.0000",
    "2500.0000",
    "5000.0000"
]}

But now I want to separate it into something like below, but I don't know how to do.

{
"catalog":[
   {
   "name": "Lucky Draw Ticket",
   "image": "\/l\/u\/lucky_draw_ticket_1.jpg",
   "price": "50.0000"
   },
   {
   "name": "KIP Voucher RM10",
   "image": "\/c\/a\/cash-voucher.jpg",
   "price": "1500.0000"
   },
   {
   "name": "KIP Voucher RM20",
   "image": "\/c\/a\/cash-voucher2.jpg",
   "price": "2500.0000"
   },
   {
   "name": "KIP Voucher RM20",
   "image": "\/c\/a\/cash-voucher50_1.jpg"
   "price": "5000.0000"
   }
]}

Answer 1

Try this:

• create a Json object from the Json string,
• reorganize the object into a temporary PHP array,
• create a Json object (string) from the PHP arrray.

Code

<?php
    $sjson='{
"name":[
    "Lucky Draw Ticket",
    "KIP Voucher RM10",
    "KIP Voucher RM20",
    "KIP Voucher RM50"
],
"image":[
    "\/l\/u\/lucky_draw_ticket_1.jpg",
    "\/c\/a\/cash-voucher.jpg",
    "\/c\/a\/cash-voucher2.jpg",
    "\/c\/a\/cash-voucher50_1.jpg"
],
"price":[
    "50.0000",
    "1500.0000",
    "2500.0000",
    "5000.0000"
]}';
$tarray = json_decode($sjson);
$newarray = array('catalog'=>array());
foreach($tarray->name as $ix => $name) {
    $newarray['catalog'][]=array(
        'name'  => $tarray->name[$ix],
        'image' => $tarray->image[$ix],
        'price' => $tarray->price[$ix],
    );
}
$sjson = json_encode($newarray);
// echo '<pre>'; var_dump($sjson); echo '</pre>';
?>

Result

{
    "catalog":[
        {
            "name":"Lucky Draw Ticket",
            "image":"\/l\/u\/lucky_draw_ticket_1.jpg",
            "price":"50.0000"
        },
        {
            "name":"KIP Voucher RM10",
            "image":"\/c\/a\/cash-voucher.jpg",
            "price":"1500.0000"
        },
        {
            "name":"KIP Voucher RM20",
            "image":"\/c\/a\/cash-voucher2.jpg",
            "price":"2500.0000"
        },
        {
            "name":"KIP Voucher RM50",
            "image":"\/c\/a\/cash-voucher50_1.jpg",
            "price":"5000.0000"
        }
    ]
}