How to know if a query fails in Laravel 4?

Question

Im using Laravel 4 with MySQL and I want to know how to control possible errors when a record is inserted, updated or deleted in DB. For example, if I do an update as follows:

DB::table('user')->where('id', $id)->update($userdata);

How could I know if that query fails? I thought of using a try-catch block to catch the exception and deal with it but I want to know whether there exists a Laravel specific method.

Answer 1

put it in a try catch block.

try {

    DB::table('user')->where('id', $id)->update($userdata);
}catch(\Exception $e){
    //Do something when query fails. 
}

moreover,

DB::insert() returns boolean.

DB::update() returns boolean

DB::delete() returns boolean

DB::insertGetId() return the last inserted id.

You can write your follow up codes depending upon the value.

P.S. The above are not for errors but just to know whether your query affected some rows or not.