calculate total avarage Rating php

Question

how to calculate the total average (user) rating

EXAMPLE: user ratings 20 average 4.3

$result=mysqli_query($connection,"SELECT * FROM rating where to_user_id='".userid."'");

count

$rowcount=mysqli_num_rows($result);
  echo  $rowcount; // Result 20 ratings

Ratings

   while($row = mysqli_fetch_array($result)){
                    echo  $row['ratting'];// 1.0 2.0 4.0.......

                    ?>

My problem how can I calculate the total average

  example like a total average of 4.3

please help me

Mike G · Accepted Answer · 2019-11-29T06:47:38.387

1

You can achieve this all in MySQL:

SELECT to_user_id, COUNT(rating) AS total_ratings, AVG(rating) AS average_rating FROM rating WHERE to_user_id = 123 GROUP BY to_user_id

echo "{$row['to_user_id']} has an average rating of {$row['average_rating']} from a total of {$row['total_ratings']} rating(s)";

edited Nov 29 '19 at 06:47

answered Nov 29 '19 at 06:42

Mike G

score 0 · Answer 2 · answered Nov 29 '19 at 06:35

0

consider using mysql AVG function and group by user

SELECT AVG(rating) _avg from ratings group by user;

answered Nov 29 '19 at 06:35

cfv1000

results getting empty – CforCODE Nov 29 '19 at 06:42
That's not possible. AVG is an aggregator function. AS long as the SQL is correct, it will return data. – cfv1000 Nov 30 '19 at 09:03

Adrian Edy Pratama · Answer 3 · 2019-11-29T06:42:58.290

0

You can try this :

$average = array_sum($row['ratting']) / count($row['ratting']);

print_r($average);

edited Nov 29 '19 at 06:42

answered Nov 29 '19 at 06:36

getting results like this 306 305.71428571429 305.71428571429 305.85714285714 305.14285714286 305.42857142857 306.28571428571 306.28571428571 306.57142857143 306.85714285714 300.28571428571 300.42857142857 307.28571428571 307.42857142857 332.85714285714 333.14285714286 – CforCODE Nov 29 '19 at 06:39
Ah sorry, you must get the data from the `ratting`, not the row – Adrian Edy Pratama Nov 29 '19 at 06:43

score 0 · Answer 4 · answered Nov 29 '19 at 06:40

0

SELECT (sum(ratting)/count(ratting)) as average FROM rating ;

add the scores and count them, the rest takes care of SQL.

answered Nov 29 '19 at 06:40

Orlando Martínez

score -1 · Answer 5 · answered Nov 29 '19 at 06:41

-1

Hi you can be use this:-

$result=mysqli_query($connection,"SELECT AVG(rating) as average_rating FROM rating where to_user_id='".userid."'");

answered Nov 29 '19 at 06:41

Balasaheb Bhise

5 Answers5