Level 51
Use ->limit(10) instead.
1 like
Apr 3, 2024
10
Level 8
How can I take only 10 count from a Eloquent Query Response.
Hello everyone, I'm stuck in below code. Could you please help me to figure out the solution?
$notifications_count= Notification::where('to_userid', $user_id)
->where('is_read', 0)
->has('user')
->take(10)
->count();
I think take() is not working with count(). so how can I do this?
Level 8
@jaseofspades88 thanks for your reply, I'll check.
Level 122
you are not fetching any records so take() is irrelevant
Also, has('user') is also redundant as you already filter to matching user_id
1 like
Level 8
@Snapey okay, so how can I do that.
And I'm using has('user') because when I display notifications and any notification author is set to deactivate than user is unable to see notification author name.
Level 21
Just simply remove count with get(). ''' $notifications_count= Notification::where('to_userid', $user_id) ->where('is_read', 0) ->has('user') ->take(10) ->get(); '''
1 like
Level 8
@Shivamyadav Yes get() will work but I want only count so if I use get() it will give me all data.
Level 122
okay, so how can I do that.
Do what? Your intention is unclear. If you want count only then leave out take()
1 like
Level 8
@Snapey I want to display maximum 10 notifications count. Suppose user_id = 2678 has total 19 notifications so I want to display only 10 notifications count.
Level 8
Level 122
@amitsolanki24_ I would do this in blade
$notifications_count= Notification::where('to_userid', $user_id)
->where('is_read', 0)
->has('user')
->count();
in blade
{{ $notifications_count >10 ? '10+' : $notifications_count }}
1 like
Please or to participate in this conversation.