How to count rows form mysql with PHP

Question

Trying to get total count of rows using variable in sql query but not able to get that can anyone here help me with this ?

<?php

    $business = $value['business_name'];

    //echo $business;

    $sql = "SELECT COUNT(*) FROM listings_reviews WHERE business_name = '$business'";

    $result = $conn-> query($sql);

    $row = $result -> fetch_assoc();

    //print_r ($row) ;

    $rating = implode($row);

    echo $rating;
    ?>

Format your code properly and explain what you want to do. Count the amount of Rows? Count the Amount of the Values of the Rows or what do you want to do? — Bernhard
– Bernhard, Commented Jul 2, 2017 at 10:51
@Vikas Temgire you question is half clear do you want to count rows WHERE business_name = '$business'" or you want to count the amount. Edit the question again — Pavan Baddi
– Pavan Baddi, Commented Jul 2, 2017 at 10:58
Yes bro, But I got that solution but thank you for your interest.... — Vikas Temgire
– Vikas Temgire, Commented Jul 2, 2017 at 11:42

localheinz · Accepted Answer · 2017-07-02 13:59:49Z

2

Give an alias to your COUNT(*) in the SQL, for example, here I have aliased it to cnt.

Then in PHP you can identify clearly the variable of the $row array

$business = $value['business_name'];

//echo $business;

$sql = "SELECT COUNT(*) AS cnt FROM listings_reviews WHERE business_name = '$business'";

$result = $conn->query($sql);

while ($row = $result->fetch_assoc()) {
    $rating = $row["cnt"];
}

echo $rating;

edited Jul 2, 2017 at 13:59

localheinz

9,6422 gold badges37 silver badges44 bronze badges

answered Jul 2, 2017 at 11:00

Thomas G

10.3k7 gold badges33 silver badges45 bronze badges

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

Comments

Just Vlad · Accepted Answer · 2017-07-02 11:12:39Z

0

Like this:

$q = 'SELECT COUNT(*) AS `all_lines` FROM `table_name`';
$record = $db->query_first($q);

$all_lines = $record['all_lines'];

answered Jul 2, 2017 at 11:12

Just Vlad

991 silver badge2 bronze badges

2 Comments

RiggsFolly Over a year ago

Where is query_first() in any standard php mysql extension

Just Vlad Over a year ago

It is just example based on php mysql class from ricocheting.com. If you want to use plain php replace function query_first() to mysql_query().

localheinz · Accepted Answer · 2017-07-02 11:20:46Z

0

Group by business name:

$business = $value['business_name'];

$sql = "SELECT COUNT(*) AS c FROM listings_reviews WHERE business_name = '$business' GROUP BY business_name";

$result = $conn->query($sql);

$row = $result ->fetch_assoc();

$listingsByBusiness = $row['c'];

For reference, see

https://dev.mysql.com/doc/refman/5.7/en/counting-rows.html

edited Jul 2, 2017 at 11:20

answered Jul 2, 2017 at 11:15

localheinz

9,6422 gold badges37 silver badges44 bronze badges

Collectives™ on Stack Overflow

How to count rows form mysql with PHP

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related