i'm trying to display data from the database in the admin dashboard
i used this:
<?php
use Illuminate\Support\Facades\DB;
$users = DB::table('users')->count();
echo $users;
?>
and i have successfully get the correct data from the database
but what if i want to display a specific data
for example in this user table there is "usertype" that specify if the user is normal user or admin i want to user the same code above but to display a specific usertype
i tried this:
<?php
use Illuminate\Support\Facades\DB;
$users = DB::table('users')->count()->WHERE usertype =admin;
echo $users;
?>
but it didn't work, what am i doing wrong?
source https://stackoverflow.com/questions/68199726/how-to-show-number-of-registered-users-in-laravel-based-on-usertype
Comments
Post a Comment