EDITED: From the oldest 5 posts, I want to get one row from those in random.
I tried these below:
Post::oldest(5)->random()->first();
But return me an error:
Call to undefined method Illumi nate\Database\Eloquent\Builder::random()
Someone knows how to do it in simple and neatest way?
The Builder class doesn't have a random() method, but a Collection does. Also, oldest() doesn't take an integer as it's argument, it's looking for a column to use (uses created_at as a default).
Use the following query instead:
$posts = Post::inRandomOrder()->limit(5)->get();
Note: Don't use ->first() if you want multiple rows; ->first() returns the first row from the database, ->get() returns rows in a Collection.
Edit: Misread the question. See the query below:
$randomPost = Post::oldest()->limit(5)->get()->random();
Use the initial Post::oldest()->limit(5)->get() to get 5 Posts ordered by created_at, then use Collection logic to return a single entry via random().
As @Tim Lewis said, don't use first but instead, you can write take + the number of items you want to display
return Post::inRandomOrder()->limit(5)->get()->take(1);
//or
return Post::oldest()->take(5)->get()->random();
The take method returns a new collection with the specified number of items:
in this case, we took only one item, more info visit the docs
Hope it helps