how to fetch data based on the value in an array laravel

Question

i have a want to update data in a column in the database according to some value in an array.here is an example of the code below

 $rmupdate=Room_name::where(['rentalhouse_id'=>2,'id'=>['110','112']])->first();
        dd($rmupdate);
        $rmupdate->update([
            $rmupdate->is_occupied=1,
        ]);

here i want to fetch all the room names that has an id of both 110 and 112 and also whose rentalhouse_id is 2.i have tried the code above but i get a null response but on the table the room names have data in them.where might i be missing a point.

gkouem · Accepted Answer · 2022-10-05 15:17:16Z

1

First of all, if you want to search for a value inside an array, you need to use whereIn instead of where. Also, since you need every room and not only the first one, you have to use ->get() instead of ->first(). So in your example, I believe that would have to be something like this.

$rmupdate=Room_name::where('rentalhouse_id', 2)->whereIn('id', [110,112])->get();

What bothers me though is that you are telling that you get null as a response, despite the fact that your code seems to not have mistakes. You should get the just one element that meets these criterias. Could it be that the ids that you are looking for do not exist?

Keep in mind that by using get() instead of first() you will get as a response a collection so you ll have to iterate through the objects using a foreach loop in order to update them.

answered Oct 5, 2022 at 15:17

gkouem

513 bronze badges

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

Comments

Nino Giovanny · Accepted Answer · 2022-10-05 14:59:23Z

0

Try somethig like:

$rmupdate = Room_name::where('rentalhouse_id', 2)
  ->whereIn('id', ['110','112'])
  ->update([ 'is_occupied' => 1]);

Look Mass updates

answered Oct 5, 2022 at 14:59

Nino Giovanny

1214 bronze badges

Collectives™ on Stack Overflow

how to fetch data based on the value in an array laravel

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related