PHP echo total number of rows from SQL query

Question

I'm not sure where I'm going wrong here. I've searched similar issues on here with no luck. Any help would be greatly appreciated. Thanks!

$check = "SELECT Number FROM advisors";
$result = mysqli_query($check);
$count = mysqi_num_rows($result);

echo $count;

If you only want the number of rows SELECT count(*) as cnt FROM advisors — AbraCadaver
– AbraCadaver, Commented Dec 7, 2017 at 19:45
Also, mysqli_query takes a mysqli object as its first parameter. — Don't Panic
– Don't Panic, Commented Dec 7, 2017 at 19:46
You have a typo, mysqi_num_rows should be mysqli_num_rows. — Barmar
– Barmar, Commented Dec 7, 2017 at 19:51

Mammadali Alizadeh · Accepted Answer · 2017-12-08 04:07:13Z

2

You should use php prepare statement like this

$count  = 0;
$mysqli = new mysqli(host, dbUser, dbPassword, dbName);
mysqli_set_charset($mysqli, "utf8");
$sql    = "select count(*)  from advisors";
if ($stmt   = mysqli_prepare($mysqli, $sql))
{
    mysqli_stmt_execute($stmt);
    mysqli_stmt_store_result($stmt);
    mysqli_stmt_bind_result($stmt, $c);
    if (mysqli_stmt_fetch($stmt))
    {
        $count = $c;
    }
    mysqli_stmt_close($stmt);
}
return $count;

For more information, here is the link for php prepare statement Documentation of php prepare statement

edited Dec 8, 2017 at 4:07

answered Dec 7, 2017 at 20:46

Mammadali Alizadeh

3253 silver badges11 bronze badges

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

1 Comment

Matt Wagner Over a year ago

It's helpful to the asker to include a link to the documentation for the method that you recommend with your answers: php.net/manual/en/mysqli.quickstart.prepared-statements.php

James Ezeh · Accepted Answer · 2017-12-07 20:03:08Z

0

You should use COUNT in query and see if it works, "SELECT COUNT (number) as number FROM advisors"; By the way, I noticed a typo in $count, it should be $count = mysqli_num_count($result).

answered Dec 7, 2017 at 20:03

James Ezeh

55 bronze badges

Collectives™ on Stack Overflow

PHP echo total number of rows from SQL query

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related