laravel查询重复的数据_laravel防止重复记录

How to properly check if a data already exist in DB and return message into view

$check = PropertyReservation::where('res_id', Auth::user()->res_id)->where('property_no',$reservation->property_no)->first();

if($check){

return redirect('/reservations')->with('success','You have an existing reservation for this item ' );

}

else{

$reservation->reservation_name = $resident->resident_fname;

$reservation->reservation_type = $request->input('reservation_type');

$reservation->reservation_quantity = $request->input('reservation_quantity');

$reservation->save();

}

return redirect('/reservations');

解决方案

Your check will work as well, as if there is no reservation for your query it returns null which means your else block will execute. But there is a better method on the query builder called exists. So you can try this as well:

if(PropertyReservation::where('res_id', Auth::user()->res_id)->where('property_no',$reservation->property_no)->exists();

{

// redirect back

}

// no need for else block as this will execute if the condition above is false

// save the reservation