Question 15992 in Laravel Question posted in
The official Laravel Documentation can be found here.

How Update a data from an object of json type column in Laravel?

I have an object of json type column in my table (properties) in MySQL like:

[
    {
        "unit": "2",
        "floor": "1",
        "price": "6000000",
        "toilet": "2",
        "balcony": "2",
        "bedrooms": "2",
        "customer": "3",
        "bathrooms": "3",
        "flat_name": "1A",
        "flat_size": "1200",
        "floor_plan": "217",
        "price_per_sqft": "5000"
    },
    {
        "unit": "2",
        "floor": "1",
        "price": "5000000",
        "toilet": "2",
        "balcony": "2",
        "bedrooms": "2",
        "customer": null,
        "bathrooms": "3",
        "flat_name": "1B",
        "flat_size": "1200",
        "floor_plan": "215",
        "price_per_sqft": "5000"
    },
    {
        "unit": "1",
        "floor": "2",
        "price": "6000000",
        "toilet": "2",
        "balcony": "2",
        "bedrooms": "2",
        "customer": null,
        "bathrooms": "3",
        "flat_name": "2A",
        "flat_size": "1250",
        "floor_plan": "216",
        "price_per_sqft": "5300"
    }
]

How can I update customer id, where flat_name = 1B from this object in Laravel?

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    I have made the solution with using loop. Thank you who reply and answer

    $objectitem=Property::where("id", 1)->first();
$updatedFlatDetails= $objectitem->flat_details;

foreach ($objectitem->flat_details as $key => $singleflat){
    if($singleflat['flat_name']==$item->flat_name){
        $updatedFlatDetails[$key]['customer']=(string)$item->customer_id;
    }
}

$objectitem->flat_details = $updatedFlatDetails;
$objectitem->save();

  2. 0

    Use collection after fetch data from database :

    $target= $collection->filter(function ($item) {
    return $item->flat_name=="1B";
})->values();

    or filter before fetch data use eloquent :

    Model::where('flat_name','1B')->get();
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search