Count number of row using mysql query in laravel

Question

I trying to use Laravel count() function to get the count of row. I have below code to count the number of row of 2 join table.

Example 1:

$row = DB::table('log_user_login')
                ->select(DB::raw('log_user_login.Password as LogPassword'), 'user.*')
                ->join('user', 'log_user_login.Username', '=', 'user.Username')
                ->where('log_user_login.LoginSession', '!=', '')
                ->groupBy('user.ID')
                ->get();
$count = sizeof($row);

Example 2:

$count = DB::table('log_user_login')
            ->select(DB::raw('log_user_login.Password as LogPassword'), 'user.*')
            ->join('user', 'log_user_login.Username', '=', 'user.Username')
            ->where('log_user_login.LoginSession', '!=', '')
            ->groupBy('user.ID')
            ->count();

When I echo $count form Example 1, the number of $count is 15415. But $count of Example 2 return me 89. May I know why this happen and how can I get the number of row without using the get()?

Jyoti mishra · Accepted Answer · 2016-12-19 10:05:23Z

3

Example 1 displays the sizeof array in bytes, but example 2 displays total count returned by table.

So, best way to get total count is using ->count() as done in example 2.

Hope you got your answer.

answered Dec 19, 2016 at 10:05

Jyoti mishra

5974 silver badges16 bronze badges

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

Comments

Md.Jewel Mia · Accepted Answer · 2016-12-19 10:40:00Z

1

Please try it.
$row = DB::table('log_user_login')
                ->select(DB::raw('log_user_login.Password as LogPassword'), 'user.*')
                ->join('user', 'log_user_login.Username', '=', 'user.Username')
                ->where('log_user_login.LoginSession', '!=', '')
                ->groupBy('user.ID')
                ->get();
echo $count = count($row);

answered Dec 19, 2016 at 10:40

Md.Jewel Mia

3,4573 gold badges22 silver badges24 bronze badges

Comments

Komal · Accepted Answer · 2016-12-19 10:10:39Z

0

Do not use sizeof(). So many time its return amount of memory allocated.

Use count() instead of sizeof().

answered Dec 19, 2016 at 10:10

Komal

2,7364 gold badges26 silver badges33 bronze badges

Collectives™ on Stack Overflow

Count number of row using mysql query in laravel

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related