Count data from database on laravel

Question

On php i could use this code to get how many item on my goods db

$total = 0;
$sql = "select count(*) as total from goods";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        $total = $row['total'];
    }
}
echo $total;
// example return 5

can i do that on laravel? if i use this code on my controller

function show(Request $request){
    $c = DB::select("SELECT count(*) as total FROM goods");
    if($c > 0 ): a ? b;
}

it would get error message since it would return JSON inside array. Are there any better way to do this? Or how to get that total from $c inside controller

Jignesh Joisar · Accepted Answer · 2021-01-12 06:50:51Z

12

used laravel Aggregates methods count method

$count = DB::table('goods')->count();

if($count > 0) {
     //more than one raw
}else {
     //zero raw
}

edited Jan 12, 2021 at 6:50

answered Jan 29, 2019 at 6:47

Jignesh Joisar

15.4k6 gold badges69 silver badges61 bronze badges

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

Comments

Jignesh Joisar · Accepted Answer · 2021-03-25 05:50:44Z

3

You can use count() function like this:

$count = DB::table('goods')->count();

You can also use Laravel Eloquent on Good model like this:

$count = Good::count();

edited Mar 25, 2021 at 5:50

Jignesh Joisar

15.4k6 gold badges69 silver badges61 bronze badges

answered Jan 29, 2019 at 7:24

Naseh Badalov

4892 silver badges9 bronze badges

Comments

Jignesh Joisar · Accepted Answer · 2020-09-12 04:09:07Z

0

$count = DB::table('goods')->count();

Please refer link

edited Sep 12, 2020 at 4:09

Jignesh Joisar

15.4k6 gold badges69 silver badges61 bronze badges

answered Aug 6, 2020 at 12:30

Mohan

855 bronze badges

Comments

Emeka Okafor · Accepted Answer · 2019-01-29 07:43:04Z

-2

its much cleaner with eloquent

$c=goods::all()->count();

since the above will pull all collection and count, the more efficient way is

$c=goods::where('value',$val)->get()->count();

edited Jan 29, 2019 at 7:43

answered Jan 29, 2019 at 7:20

Emeka Okafor

4574 silver badges10 bronze badges

2 Comments

SergkeiM Over a year ago

This will fetch all goods and count collection, not good, if there are millions of records.

Emeka Okafor Over a year ago

i know its not a good practice but looking at his code, he is fetching all record

Collectives™ on Stack Overflow

Count data from database on laravel

4 Answers 4

Comments

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related