update query with two conditions

I want a query with two conditions to update but it should be an and conditions. my code is below. it does not work.

DB::table('attendence') ->where([['name',$name] ,['type',null] ]) ->update([ 'checkedout' => $this->data->checkedout, 'type'=> $this->data->type, ]);

Cinek

8 years ago

Best Answer

Level 6

DB::table('attendence') 
->where('name',$name)
->whereNull('type')
->update([ 'checkedout' => $this->data->checkedout, 'type'=> $this->data->type, ]);

1 like

esperanza

8 years ago

Level 1

it worked.

DB::table('attendence') ->where('name',$name) ->whereNull('checkedout') ->update([ 'checkedout' => $this->data->checkedout, 'type'=> $this->data->type, ]);

Please or to participate in this conversation.