SQL count all doesn't execute in php

Question

if($sql = $db->query("Count (*) FROM post_items")){
        echo mysqli_num_rows($sql);
}

what's wrong with my code? is this the correct way to echo the total of row in a table?

Missing SELECT in your query try this SELECT Count(*) FROM post_items — M Khalid Junaid
– M Khalid Junaid, Commented Feb 19, 2014 at 6:54
Does this answer your question? MySQLi count(*) always returns 1 — Dharman
– Dharman ♦, Commented Mar 6, 2020 at 19:47

Dharman · Accepted Answer · 2020-03-06 19:46:41Z

3

Your query should be

select count(*) FROM post_items

but echoing

mysqli_num_rows($sql);

will always give 1 as the ans, because count function returns only one row.

Rather fetch the details and show the count

$row = $sql->fetch_row();
echo $row[0];

edited Mar 6, 2020 at 19:46

Dharman♦

34k27 gold badges106 silver badges158 bronze badges

answered Feb 19, 2014 at 7:00

Deepika Janiyani

1,4679 silver badges17 bronze badges

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

3 Comments

user3318525 Over a year ago

then that's not what I want. I need to know the total row in the table. like 50 customers has bought an item.

Deepika Janiyani Over a year ago

echoing the count will do that for you, mysqli_num_rows returns no of rows not the data of rows

Deepika Janiyani Over a year ago

to get data you will have to fetch the result and then display it, check updated ans

lc. · Accepted Answer · 2014-02-19 07:00:29Z

2

No it is not; you will always get a return value of 1.

Why? Because you are in essence double-counting. The query executes a COUNT aggregate on the table returning a single row with the counted number. mysqli_num_rows is then counting the number of rows in this result set - the single row - and returns 1.

Try, the following line instead, which should fetch the first (only) column returned of the first (only) row in the result set.

echo $sql->fetch_row()[0]

Note you're also missing a SELECT keyword in your SQL statement.

answered Feb 19, 2014 at 7:00

lc.

117k21 gold badges164 silver badges190 bronze badges

Comments

Akhil Sidharth · Accepted Answer · 2014-02-19 06:57:22Z

-3

It should be

if($sql = $db->query("select count(*) FROM post_items")){
        echo mysqli_num_rows($sql);
}

answered Feb 19, 2014 at 6:57

Akhil Sidharth

7461 gold badge6 silver badges16 bronze badges

Collectives™ on Stack Overflow

SQL count all doesn't execute in php

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related