How do I know and count the number of rows in an SQL query with Laravel?

Question

 $teste = DB::table("cnaes")
                ->select("id")
                ->where("cnpj", $cnpj)
                ->where("cnae", $cnae);

How can I know how many lines were affected by this query?

Answer 1

You can use the method count()

 $teste = DB::table("cnaes")
                ->select("id")
                ->where("cnpj", $cnpj)
                ->where("cnae", $cnae)
                ->count();

Answer 2

beauty ?

I found a little bit like the codeigniter that structure there...

In this case, the sql used is num_rows... Look in the Laravel documentation to see how it applies.

If it matches the codeigniter, it would look like this:

   $teste = DB::table("cnaes")
                    ->select("id")
                    ->where("cnpj", $cnpj)
                    ->where("cnae", $cnae);


     echo $teste->num_rows();

Answer 3

The correct answer is two ways

1:

$teste = DB::table("cnaes")
                ->select("id")
                ->where("cnpj", $cnpj)
                ->where("cnae", $cnae)->get()->count();

2:

 $teste = DB::table("cnaes")
                ->select(\DB::raw("COUNT(id)" as quantidade))
                ->where("cnpj", $cnpj)
                ->where("cnae", $cnae)->get();

Take a look at the documentation that there may be ->sum() I don’t remember if there are 4 ways.