DB update query in Laravel?

Question

I'm trying to update the hours_worked column in daiy_attendance table using in_time and out_time in same table. in_time and out_time already stored in the table.

So I'm using timediff to get the difference. Query runs and execute correctly when I try it on the phpmyadmin sql format, but when I try to run it in the program it does not update the hours_worked column. It does not gives any errors.

$sql5 = "UPDATE daily_attendances SET hours_worked = TIMEDIFF(out_time,in_time) WHERE in_time != '' AND out_time != '' ";
$result2 = DB::statement(DB::raw($sql5));

Not sure if it's relevant: did you set 'time_worked' as fillable? — hktang
– hktang, Commented Aug 1, 2017 at 3:54
@JohnDoe OP is not using a model, so $fillable attributes are irrelevant. — fubar
– fubar, Commented Aug 1, 2017 at 4:33
put your query in try.. catch() block and see if there is any error.. — Zedex7
– Zedex7, Commented Aug 1, 2017 at 5:48

sumit · Accepted Answer · 2017-08-01 03:50:12Z

4

try

DB::table('daily_attendances')
                ->whereRaw("in_time != '' AND out_time != ''")
                ->update(['hours_worked ' =>DB::raw('TIMEDIFF(out_time,in_time)')]);

OR JUST use db:statement

$sql5 = "UPDATE daily_attendances SET hours_worked = TIMEDIFF(out_time,in_time) WHERE in_time != '' AND out_time != '' ";
$result2 = DB::statement($sql5);

answered Aug 1, 2017 at 3:50

sumit

15.5k14 gold badges75 silver badges113 bronze badges

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

2 Comments

sumit Over a year ago

Check your database connection , is it connecting to same database that you tried from phpmyadmin

colombo Over a year ago

connection is fine

Collectives™ on Stack Overflow

DB update query in Laravel?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related