Level 50
You can do it like this, for example:
DB::table('visitor_count')->get()->groupBy('user_ip')->count()
Jan 21, 2020
1
Level 1
Unique row count based on the group by conditaion
Hi,
In my table name like visitor_count. here I store all visited user details. The table column likes user_ip, date, page, host. And finally, I want how many unique users visit on my website based on the IP address.
By getting a value in laravel query builder
Please or to participate in this conversation.