我应该如何解码正确的json响应? [英] how should i decode the correct json response?

问题描述

我正在使用Laravel 5.7来构建提供JSON响应的API.我正在创建以下JSON，但需要进行一些更改.该表包含booking_pics列，其中使用分开存储了多个图像.我想在json中获取数组中的对象.我显示的是json，但只有最后一张图像显示了，其他图像则没有，需要解决.

I am using Laravel 5.7 to build an API that provides a JSON response. I am creating the following JSON but it needs some changes. Table contain booking_pics columns in which multiple images stored using , separated. I want fetch in json as object in array. i am display json but only last image is display others is not, need solution.

控制器:

$get_booking_details= DB::table('table_booking_list')
            ->join('table_booking_details', 'table_booking_list.booking_id', '=', 'table_booking_details.booking_id')
            ->select('table_booking_details.*')
            ->where('table_booking_details.booking_id',$booking_id)
            ->get();

            foreach($get_booking_details as $item)
            {
                foreach(explode(",",$item->booking_pics) as $items)
                {
                   $item->booking_pics=[["image" => $items]];
                }
            }
            return response()->json(['success' => '1','data' =>$get_booking_details]);

json响应:

{
    "success": "1",
    "data": [
        {
            "id": 1,
            "booking_list_id": 1,
            "booking_id": 1,
            "booking_name": "hockey stadium",
            "booking_area": "kolhapur",
            "booking_status": 0,
            "time": "6.00 am to 8.00pm",
            "booking_pics": [
                {
                    "image": "http://192.168.1.132:8000/images/ground_pic/2.jpg"
                }
            ],
            "available_sports": "hockey,cricket",
            "booking_amenities": "parking,toilet,water",
            "booking_rating": 4.5,
            "booking_area_address": "MSEB Ring Road, Datta Colony, Kolhapur, Maharashtra, 416008",
            "longitude": "85.501980",
            "latitude": "23.624420",
            "updated_at": "2019-06-26 16:42:02",
            "created_at": "0000-00-00 00:00:00"
        }
    ]
}

必需的json:

{
    "success": "1",
    "data": [{
        "id": 1,
        "booking_list_id": 1,
        "booking_id": 1,
        "booking_name": "hockey stadium",
        "booking_area": "kolhapur",
        "booking_status": 0,
        "time": "6.00 am to 8.00pm",
        "booking_pics": [{
                "image": "http://192.168.1.132:8000/images/ground_pic/1.jpg"
            },
            {
                "image": "http://192.168.1.132:8000/images/ground_pic/2.jpg"
            }
        ],
        "available_sports": "hockey,cricket",
        "booking_amenities": "parking,toilet,water",
        "booking_rating": 4.5,
        "booking_area_address": "MSEB Ring Road, Datta Colony, Kolhapur, Maharashtra, 416008",
        "longitude": "85.501980",
        "latitude": "23.624420",
        "updated_at": "2019-06-26 16:42:02",
        "created_at": "0000-00-00 00:00:00"
    }]
}

推荐答案

最快的方法是创建模型并将数据库中的数据转换为json

fastest way would be creating a model and casting the data from database as a json

在模型中

protected $casts = [
    'booking_pics' => 'json',
];

这篇关于我应该如何解码正确的json响应?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！