How to count the number of rows in database table using MySQLi Object-oriented [duplicate]

Question

This is my code:

$sql = "SELECT count name_id, name FROM TABLE WHERE tag1 in ('$tag1') OR tag2 in ('$tag1') $andor tag2 in ('$tag2') OR tag1 in ('$tag2') ORDER BY rating desc LIMIT 5 OFFSET 0";
$result = $conn->query($sql);

And now, I want to echo the number of name_id. So, what to do?

Make new line something like this: $sql = "SELECT count(name_id)

echo $sql;

You could refer to this stackoverflow.com/questions/1893424/count-table-rows — Incognitorrrr
– Incognitorrrr, Commented May 18, 2017 at 3:39
Refer to this. stackoverflow.com/questions/6655628/…. Displaying your total number of rows. — Incognitorrrr
– Incognitorrrr, Commented May 18, 2017 at 4:27

Kuru · Accepted Answer · 2017-05-18 03:56:06Z

1

If you want count the no of rows in the results

echo  count($result);

if you want retrive it using SQL

SELECT COUNT(*) FROM table_name;

You can include your conditions to this query and get the count of filtered data. Read this for your reference on SQL count

edited May 18, 2017 at 3:56

answered May 18, 2017 at 3:44

Kuru

7385 silver badges18 bronze badges

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

2 Comments

Rahul Gupta Over a year ago

echo count($result); always echo "1". And sorry, i do not understand, where to put that 2nd code ;/

Kuru Over a year ago

@RahulGupta that mean it's retrieving only one row. check the answer for reference, DO you want retrieve only the count or the data also?

lalithkumar · Accepted Answer · 2017-05-18 03:57:23Z

0

Try below:

select count(name_id) as namecount FROM TABLE WHERE tag1 in ('$tag1') OR tag2 in ('$tag1') $andor tag2 in ('$tag2') OR tag1 in ('$tag2') group by name_id ORDER BY rating desc LIMIT 5 OFFSET 0

you need to use group by

answered May 18, 2017 at 3:57

lalithkumar

3,5404 gold badges26 silver badges45 bronze badges

1 Comment

lalithkumar Over a year ago

did you try this ?@Rahul Gupta

Collectives™ on Stack Overflow

How to count the number of rows in database table using MySQLi Object-oriented [duplicate]

2 Answers 2

2 Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Linked

Related