Delete row from db after certain condition has been meet in laravel

Question

My table has data id post_id description and dispose_time. I wanted to delete data from DB if current time and date is greater than the current time.

 $post = Post::delete()->where('dispose_time' > DATE_SUB(NOW())), INTERVAL 10 MINUTE));

something like this . it is giving me the error and the dispose_time in my DB is in timestamp format something like this 1555107000 . Any Help appreciated.

Surender Singh Rawat · Accepted Answer · 2019-04-12T05:15:46.193

1

Use delete clause at last , like this:

Post::where("dispose_time", ">", now()->addMinutes(-10)->toDateTimeString())->delete();

edited Apr 12 '19 at 05:15

answered Apr 12 '19 at 03:27

Surender Singh Rawat

899
4
14

it gives this error :- Invalid datetime format: 1292 Truncated incorrect datetime value: 'dispose_time' (SQL: delete from `posts` where 'dispose_time' > DATE_SUB(NOW(), INTERVAL 10 MINUTE)) – Pushpendra Pal Apr 12 '19 at 04:19
what does now refer too – Pushpendra Pal Apr 12 '19 at 04:54
now() is a helper function, return carbon object, i edited it again – Surender Singh Rawat Apr 12 '19 at 05:16
Call to undefined function App\Http\Controllers\now() – Pushpendra Pal Apr 12 '19 at 06:21

score 1 · Answer 2 · answered Apr 12 '19 at 05:03

1

Use Carbon for time in laravel.

$post = Post::where('dispose_time', '>', Carbon::now())->delete();

answered Apr 12 '19 at 05:03

Imad Ullah

929
9
17

Francinaldo Almeida · Answer 3 · 2019-04-12T04:28:48.797

0

Based on the information you provided, you should use the whereRaw method, and not where, since you are using SQL as where clause. Also, delete() should be the last method to be called. So your code would be the following:

Post::whereRaw("`dispose_time` > DATE_SUB(NOW(), INTERVAL 10 MINUTE)")->delete();

Since you are using Laravel, it comes with the Carbon package and you can also do the following

Post::whereDate('dispose_time', '>', Carbon\Carbon::now()->addMinutes(-10))->delete();

edited Apr 12 '19 at 04:28

answered Apr 12 '19 at 03:27

Francinaldo Almeida

347
1
10

Invalid datetime format: 1292 Truncated incorrect datetime value: 'dispose_time' (SQL: delete from `posts` where 'dispose_time' > DATE_SUB(NOW(), INTERVAL 10 MINUTE)) – Pushpendra Pal Apr 12 '19 at 04:19
Please try the second approach I just presented. – Francinaldo Almeida Apr 12 '19 at 04:29
i am using lumen and i dont know its defination from which package it is coming – Pushpendra Pal Apr 12 '19 at 04:42
If it does not comes out of the box with lumen, you can check it out [here](https://carbon.nesbot.com/docs/). Also, are you sure `dispose_time` is configured as timestamp? – Francinaldo Almeida Apr 12 '19 at 04:51
I take date and time in postman and apply strtotime function to it and in DB it is string – Pushpendra Pal Apr 12 '19 at 04:55
Can you place an example of a value stored on your DB? – Francinaldo Almeida Apr 12 '19 at 04:58

Delete row from db after certain condition has been meet in laravel

3 Answers3