计算Laravel 4数据库中的行数

Question

Hi I am trying to get the current count of my statement below , but I am getting only the count not the whole result:

 $admins = DB::table('users')
    ->select(DB::raw('count(users.id) as admin_count'))
     ->where('users_roles.role_id', '=' ,0)
    ->join('users_roles', 'users.id', '=', 'users_roles.user_id')
     ->orderBy('first_name', 'asc')
    ->get();

Could you tell me what I am doing wrong?

Thanks

Answer 1

Just use * in your SELECT clause, and you get entire resultset. Then, $admins is an array, and you can get its count using count method.

$admins = DB::table('users')
    ->select('users.*')
    ->join('users_roles', 'users.id', '=', 'users_roles.user_id')
    ->where('users_roles.role_id', '=' ,0)
    ->get();

I assume you have users_roles.role_id = 0 for exactly once for a user. There are no multiple entries for role_id = 0 for one user right?

I hope this helps.