How to count rows in database table?

Question

I want to make a variable

{{ $countEvents }}

which can count the number of rows from table Events...Now I have 18 rows( https://i.sstatic.net/ZUJoY.jpg ), I want to use this variable to my view. How can I be able to count the number of rows?

I've tried this

$events = Event::count();

but I got all data with all columns from my database, not the number of it!

Try finding all Events and then count() on the results then pass to the view — Cyprien Aubry
– Cyprien Aubry, Commented Jun 25, 2019 at 12:33
Could you post your Event model code? Event::count() should work without any problems and return only the count of rows, when Event::all()->count() will first receive all the rows from the table and then count the results (not the best way of doing it). — Thepeanut
– Thepeanut, Commented Jun 25, 2019 at 12:36

CodeBoyCode · Accepted Answer · 2019-06-25 12:36:50Z

3

Controller:

$countEvents = Event::count();

return view('view-name-here', compact('countEvents'));

this will allow you to use {{ $countEvents }} in your view

answered Jun 25, 2019 at 12:36

CodeBoyCode

2,27715 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

CodeBoyCode Over a year ago

check this solution my man - nice and simple - you were on the right lines

CodeBoyCode Over a year ago

you don't need to do $events::all() you can just do this above

CodeBoyCode Over a year ago

no worries man glad you got there! - if you could please accept my answer that would be great

Andrei Nagy Over a year ago

the countEvents worked for EventController. But can I add a countNews in EventController? I used $countNews = News::count(); but I've got undefined variable $countNews. the return is this return view('event.view_all_event',$data, compact('countEvents'), compact('countNews'));

CodeBoyCode Over a year ago

yeah you can do that like this - Controller: $countNews = \App\News::count(); and then return view('view-name-here', compact('countEvents', 'countNews')); - let me know how you get on

|

Sheikh Muzammil Askari · Accepted Answer · 2019-06-25 12:37:47Z

1

count is a Collection method. The query builder returns an array. So in order to get the count, you would just count it like you normally would with an array:

$eventCount = count($events);

If you have a Event model, then you can use Eloquent to get a Collection and then use the Collection's count method. Example:

$eventlist = Event::all();
$eventCount = $eventlist->count();

answered Jun 25, 2019 at 12:37

Sheikh Muzammil Askari

211 bronze badge

Comments

Rahul · Accepted Answer · 2019-06-25 12:42:38Z

1

You can use DB query builder facade.

$data['countEvents'] = DB::table('events')->count();

Now in blade you can check integer value of $countEvents

edited Jun 25, 2019 at 12:42

answered Jun 25, 2019 at 12:37

Rahul

18.6k7 gold badges43 silver badges64 bronze badges

Collectives™ on Stack Overflow

How to count rows in database table?

3 Answers 3

6 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related