Im trying to get exception if update method failed i just check this try catch block it dont return any exception because this project id do not exist in my database i have only about hundred records.
try {
$project = DB::table('project')
->where('prj_id', '987654' )
->update([
'prj_status' => 'open',
'prj_updated_date' => Carbon::now()
]);
}catch(\Exception $e){
dd($e);
}
An update on none-existing row do not fail in SQL. If you run a query like UPDATE foo SET bar = 'foobar' WHERE 1 = 2; your database would be happy to do the job and report back 0 rows updated.
You will have to check the value of $project to see if the update did update any rows
$project = DB::table('project') ->where('prj_id', '987654' ) ->update([ 'prj_status' => 'open', 'prj_updated_date' => Carbon::now() ]); if ( !$project) { return " project update have error "; 
If you're using Laravel 5, use the model to dictate what will be stored in the DB eventually.
So, using your project model, you'll have something like:
$project = Project::findOrFail('987654')
->update([
'prj_status' => 'open',
'prj_updated_date' => Carbon::now()
]);
You'll get a not found exception if the id of what you're looking for doesn't exist.
null. So you need to check the value of $project and throw an exception based on that.$projects_updated = DB::table('project')
->where('prj_id', '987654' )
->update([
'prj_status' => 'open',
'prj_updated_date' => Carbon::now()
]);
if($projects_updated) {
// n rows updated, do something
}
else {
// nothing updated
}
