Count the amount of values in a Mysql table with php

Question

I made a school voting with 10 questions. There you can check one teacher for every question (in total there are 80 teachers). When someone has voted for all questions, a new row in my mysql table will be inserted.

My Mysql Table has 10 fields (for every question one(q1,q2,q3)). The name of the teacher for one question will be an integer (every teachers has an id from 1 - 82).

That is what the table looks like

Now I want to find out for which teacher is how often voted for each question. That should do a php script. It should echo something like this:

The result should be something like this

How to do this?

You might want to look at group by and sum http://www.w3resource.com/sql/aggregate-functions/sum-with-group-by.php — Jan B, Dec 15 '16 at 14:46

jophab · Accepted Answer · 2016-12-30T14:24:15.697

1

This query will give number of times each teacher is voted for question q1.

$sql = "SELECT q1, COUNT(*) AS votes FROM table1 GROUP BY q1 ORDER BY votes";
$ref = $result->query($sql);
while($row = mysqli_fetch_assoc($ref))
{
  echo "$row[votes] times $row[q1]</br>";

}

You can do the same for other questions, just by changing the column name for question number

edited Dec 30 '16 at 14:24

answered Dec 15 '16 at 14:54

jophab

5,356
14
41
60

it does not alert somethign :/ ? – Tim Jansen Dec 15 '16 at 14:58
You can process it using php – jophab Dec 15 '16 at 14:59
when i do your above code in an echo and do the query it givess me Resource id #4 ? – Tim Jansen Dec 15 '16 at 15:04
i got his when i use your code: Fatal error: Call to a member function query() on a non-object in /users/marien-ranking/www/auswertung.php on line 12 – Tim Jansen Dec 15 '16 at 15:09
what is $result – Tim Jansen Dec 15 '16 at 15:12
$result = mysqli_connect("localhost","usernmae","password","dbname"); – jophab Dec 15 '16 at 15:13
Change result to your connetion variable – jophab Dec 15 '16 at 15:13
$verbindung = mysql_connect("localhost","xxx","xxx"); $db = mysql_select_db("xxx"); – Tim Jansen Dec 15 '16 at 15:14
Replace $result with $verbindung. Also use mysqli_ functions instead of mysql_ functions() – jophab Dec 15 '16 at 15:16
http://stackoverflow.com/questions/14151458/difference-between-mysql-mysqli – jophab Dec 15 '16 at 15:18
you dont need anything extra to use mysqli_functions. Just change mysql_ functions to mysqli_functions – jophab Dec 15 '16 at 15:19
oh sry another one, how to sort the output? – Tim Jansen Dec 15 '16 at 15:22
based on what ? – jophab Dec 15 '16 at 15:23
You can use order by votes in the sql query. Check the edited code. Now the rows will be in sorted order – jophab Dec 15 '16 at 15:24

Count the amount of values in a Mysql table with php

1 Answers1