Laravel Simple Count DB Row echo

Question

I am a Laravel Beginner and after weeks learning and trying i need some help now.

I simple want count an number from my Mysql DB Table in PHP.

My code:

SELECT category_id FROM products WHERE category_id IN (1, 2)

I only know how i can make it in PHP not Laravel with Controllers.

Theres an Simple code how i can display the result in my Laravel php page without this? (i know in laravel i dont need this):

<?php
$con=mysqli_connect("HOST","USERNAME","PASSWORD","DATABASE");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

$sql="SELECT category_id FROM products WHERE category_id IN (1, 2)";

if ($result=mysqli_query($con,$sql))
  {
  // Return the number of rows in result set
  $rowcount=mysqli_num_rows($result);
  printf("%d\n",$rowcount);
  // Free result set
  mysqli_free_result($result);
  }

mysqli_close($con);
?>

And in what files i must add some code thats work? Index,controller,web.php / routes? Because for example if i try:

{{$product->name}}

i get this error: "Undefined variable: product " Must i connect every page with an Controller?

I need some very easy explain for it with example code if possible:) Thanks

Classified · Accepted Answer · 2017-09-04 12:50:27Z

1

What you can do in Laravel to get the count of a table is

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

Which will give you the number of rows within the table 'categories'.

You would usually put this in a controller and pass it to a view.

answered Sep 4, 2017 at 12:50

Classified

5601 gold badge7 silver badges22 bronze badges

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

Collectives™ on Stack Overflow

Laravel Simple Count DB Row echo

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related