how to hide post automatically

@vincent15000 it does not hide the post.

@Jeyziii Probably because your expired_at field is null ?

Can you show the content of your articles table in the database with an example of article that should not be shown ?

@vincent15000 https://pasteboard.co/H5LHI9rZB8Hu.png

@Jeyziii Sorry I just noticed that I had something wrong in my proposition of code.

You need to hide the articles which have an expiration date.

$latest_article=Article::whereDate('published_at', '<=', Carbon::now())
	->whereNull('expired_at') // so you show only where the expiration date is null
	->latest('published_at')
	->limit(5)
	->get();

If you need to check the expiration date to be less than the actual date, you need to add a condition around the expiration date.

@vincent15000 Sorry, my construction of sentence is wrong. What I mean is, I want the article to be hidden at the date and time set in the expired_at. Like after the article is posted, it will not shown in the front end when the date and time comes.

@Jeyziii That's totally different.

use Carbon\Carbon;
...
$latest_article=Article::whereDate('published_at', '<=', Carbon::now())
	->whereDate('expired_at', '>', Carbon::now())
	->latest('published_at')
	->limit(5)
	->get();

@vincent15000 Yes, I'm sorry I hadn't slept yet when I composed the question. Thank you very much. I will try this

@vincent15000

->whereDate('expired_at', '>', Carbon::now())

not

->whereDate('expired_at', '<', Carbon::now())

@saedyousef Yes that's true, I've updated my previous comment ;).