Get posts from date to date

Do you want us to write the query ??? Why don't you show us what you have already done and we shall take it from there ? First try with plain vanilla sql in some workbench and then try convert it to eloquent.

@lifesound I will give you a small hint

whereBetween

Just google Laravel whereBetween example

@d3xt3r i don't know how to do it by elequent.

Write a regular query it's perfectly OK in laravel to do so.

With modern frameworks, the beauty is, THINK LOUD of what you want, and the method/function name will be very close to what you would have thought :)

I will try whereBetween then tell you

whereBetween will work, use it all the time :D

        $posts = \DB::table('posts')->whereBetween('created_at',[strtotime('-1 month'),strtotime('today')])->get();

does not work

may be I'm stupid

Use Carbon to create the dates $from and $to

The query is expecting some kind of format here. The best way is using the build in Carbon classes

$from = \Carbon\Carbon::today()->subMonth();
$to = \Carbon\Carbon::today();

$posts = Post::whereBetween('created_at', [$from, $to])->get();

Carbon: http://carbon.nesbot.com/docs/