How to format data in specific way using html and php

Question

I have a table that contains Aspiring team for particular positions and various vote casted. The data is below

Teamtable
|   no  |   team    |   position    |   votes Cast  |
|   1   |   A       |   President   |    2          |
|   3   |   B       |   President   |    1          |
|   4   |   C       |   Secretary   |    2          |
|   6   |   D       |   Secretary   |    1          |

I want to be able to get this in an html format using php and mysql just as below

EXPECTED VIEW IN THE HTML AND PHP FORMAT

    PRESIDENT
Team    |   Total Votes |   Percentage  |
 A      |       2       |   66.67       |
 B      |       1       |   33.33       |

    SECRETARY
Team    |   Total Votes |   Percentage  |
 C      |       2       |   66.67       |
 D      |       1       |   33.33       |

This is what i have tried so far

//QUERY
$SQL=SELECT 
        `team`,
        `position`,
        `votesCast`
    FROM
        Teamtable

$Results=$db->query($SQL);

$data=array();

while($row=mysqli_fetch_assoc($Results)){

    $team=$row['team'];
    $position=$row['position'];
    $totalVote=$row['votesCast'];

    $data[$position][]=$position;
    $data1[$position][]=$team;
    $data2[$position][]=$totalVote;
}

foreach($data as $position =>$electionResults){
    $teams=$data1[$position];
    $totalVotes=$data2[$position];

    foreach($teams as $re => $teas){
        $votes=$totalVotes[$re];
        echo "
            <table>
             <tr>
                <td>$teas</td>
                <td>$votes</td>
             </tr>
            </table>";
    }

}

I have to tried up to this point, any help is appreciated.

why not using css instead of just html/php/sql

azochz
– azochz

2015-04-06 16:59:02 +00:00
Commented Apr 6, 2015 at 16:59 — azochz
– azochz, Commented Apr 6, 2015 at 16:59

user789456 · Accepted Answer · 2015-04-06 19:41:03Z

1

This could be very helpful for you

while($row = mysqli_fetch_assoc($result)) {
  $data[$row['position']]['total'][]=$row['votes'];
  $data[$row['position']][]=$row;
}
foreach($data as $k=>$v){
    echo '<p>'.$k.'</p>';
    echo '<table border="1">';
    $total_votes=array_sum($v['total']);
    foreach($v as $kk=>$vv){
        if($kk!=='total'){
            $percentage=round($vv['votes']/$total_votes*100,2);
            echo '<tr><td>'.$vv['tean'].'</td><td>'.$vv['votes'].'</td><td>'.$percentage.'%</td></tr>';
        }
    }
    echo '</table>';
}

edited Apr 6, 2015 at 19:41

answered Apr 6, 2015 at 17:30

user789456

1736 bronze badges

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

5 Comments

George Over a year ago

Thanks bros, but how would I calculate for the percentages for each position

George Over a year ago

The percentage gives an error, assuming Team C was the only team who went in for the secretary and he had just one vote but three people voted in all. How would the percentage be striked

George Over a year ago

The percentage for just one person contesting for a particular position gives 100 percent even if a person out 3 persons voted for him. I would like to no if we can just get the total number of people who voted?

user789456 Over a year ago

In my answer there is a typo: you Must correct it according to ur table field name 'team ', 'voteCast' etc.

George Over a year ago

Let us continue this discussion in chat.

Knarf · Accepted Answer · 2015-04-06 17:11:10Z

0

You wan't to have the table on the outside of the foreach.

echo "<table>";
foreach($teams as $re => $teas){
    $votes=$totalVotes[$re];
    echo "<tr>
            <td>$teas</td>
            <td>$votes</td>
         </tr>";
}
echo "</table>";

answered Apr 6, 2015 at 17:11

Knarf

1,2833 gold badges12 silver badges31 bronze badges

Collectives™ on Stack Overflow

How to format data in specific way using html and php

2 Answers 2

5 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related