Fetch only few data from database in Laravel

Question

I want to fetch only 4 rows from my database's table.

$data=table::all();

Returns all data/rows from my table. How can I get only 4 rows instead of all?

Thanks

Welcome to SO. Please try searching before posting a new question. — Don't Panic, Sep 21 '21 at 07:06
Does this answer your question? [Select the first 10 rows - Laravel Eloquent](https://stackoverflow.com/questions/21255508/select-the-first-10-rows-laravel-eloquent) — Don't Panic, Sep 21 '21 at 07:06
Please provide enough code so others can better understand or reproduce the problem. — Community, Sep 27 '21 at 21:41

Mtxz · Accepted Answer · 2021-09-21T02:25:47.000

1

Try $data=table::take(4); that will only retrieve the 4 first records.

You also have the limit() method. See details in the Laravel Limit & Offset docs.

edited Sep 21 '21 at 02:25

answered Sep 21 '21 at 02:24

Mtxz

1

My pleasure, please consider accepting my post as the answer if it suits you. Still, for a simple query like yours, a quick google search about "Laravel limit query" would have been enough :) – Mtxz Sep 21 '21 at 02:27

1 Answers1