Counting records using SQL and returning in PHP

Question

I am trying to count the number of records I have in a certain. This is the SQL query I have been using and I have tried to echo $result, but nothing would print.

$result = $mysqli->query("SELECT COUNT(*) FROM barber_queue ");
echo $result;

I have also tried this code which managed to return something, however not in the format I would like

$result = $mysqli->query("SELECT COUNT(*) FROM barber_queue ");
$row = mysqli_fetch_row($result);
print_r($row);

This returns:Array ( [0] => 6 ) While 6 is the correct amount of rows, I would just like the integer on its own as I want to use this amongst HTML to relay some information back to visitors.

Also this piece of code

$result = $mysqli->query("SELECT COUNT(*) FROM barber_queue ");
    print_r($result);

returns on the screen. :

mysqli_result Object ( )

Any Help is appreciated.

$rowcount=mysqli_num_rows($result);// try this

Saty
– Saty

2015-04-12 16:56:54 +00:00
Commented Apr 12, 2015 at 16:56 — Saty
– Saty, Commented Apr 12, 2015 at 16:56

Chibuzo · Accepted Answer · 2015-04-12 16:58:10Z

1

I added an alias "num" to the COUNT() keyword, the accessed the $row variable as an array();

$result = $mysqli->query("SELECT COUNT(*) num FROM barber_queue ");
$row = mysqli_fetch_assoc($result);
echo $row['num'];

answered Apr 12, 2015 at 16:58

Chibuzo

6,1133 gold badges33 silver badges54 bronze badges

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

3 Comments

MR KHAN COMUTI Leader Over a year ago

Perfect, worked wonders, but Im sure Ive seen somewhere that you can just print count directly from the result of the query?

Chibuzo Over a year ago

No you can't. The query returns a resource. You need to fetch the result from that resource.

Reflective Over a year ago

You can execute queries returning no result ... ex: $mysqli->query("insert into table .....") ... then you get the inserted id by calling extra function mysql_insert_id ... but if you want to get a rowset you have to fetch it first by calling mysqli_fetch_row($query)

Reflective · Accepted Answer · 2015-04-12 16:58:02Z

0

you are missed mysqli_fetch_row(...);. you are dumping the system mysql_query object, which can not be access by print_r so you have this dump

answered Apr 12, 2015 at 16:58

Reflective

3,9371 gold badge17 silver badges25 bronze badges

2 Comments

MR KHAN COMUTI Leader Over a year ago

Im sure I used fetch row in the middle example

Reflective Over a year ago

of course, that's why you have result there ... if you want to count result rows mysqli_num_rows is the function you should use ... if you want to substitude the name of the field ... the clean SQl syntax is field as newfieldname - in your case count(*) as count for example ... but you need to fetch your result first. The $mysqli->query won't start fetching the result and because it is low level object it can not be dumpped successfuly by print_r or var_dump

Collectives™ on Stack Overflow

Counting records using SQL and returning in PHP

2 Answers 2

3 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related