Mysql how to get the total of feedbacks?

Question

I'm making a feedback stars rating system for products using Laravel with MySQL, how can I make MySQL count all rates and get the average of 5 stars?

So by laravel I am going to just use get() to get the average.

//sample data:

id | rate
1     4
2     2

//expected output:

3

Put some sample data with expected output. – mkRabbani Aug 10 '19 at 09:10 — mkRabbani, Aug 10 '19 at 09:10

codewarrior · Accepted Answer · 2019-08-10T09:28:56.173

1

In order to answer more precisely, the structure of the table should be known. You can group the desired lines and then divide by the number. something like this:

SELECT SUM(rate)/COUNT(1) FROM table GROUP BY 1

or with AVG function

SELECT AVG(rate) AS avgRate
FROM table
GROUP BY xyz;

see https://dev.mysql.com/doc/refman/8.0/en/group-by-functions.html#function_avg

DB::table('your_table')
                ->avg('star');

edited Aug 10 '19 at 09:28

answered Aug 10 '19 at 09:13

codewarrior

28
4

where can I store this line in phpmyadmin? – Wail Hayaly Aug 10 '19 at 09:16
@wailhayaly this isn't what phpmyadmin is for. – Strawberry Aug 10 '19 at 09:20
I do not understand the question. The sql statement can be executed directly in the SQL window. – codewarrior Aug 10 '19 at 09:22
you can test this stament in phpMyAdmin, but you must integrate this in your php-code. – codewarrior Aug 10 '19 at 09:23
@Strawberry I guess I can use `avg` function with laravel for retrieving the average, thanks. – Wail Hayaly Aug 10 '19 at 09:25

score 0 · Answer 2 · answered Aug 10 '19 at 09:32

0

You can do something like this,

$rateAvg = Model::avg('rate');

Check this links for more

How to get average of column values in laravel

Aggregates in laravel

answered Aug 10 '19 at 09:32

Maulik Shah

1,040
1
7
17

Mysql how to get the total of feedbacks?

2 Answers2