show_officials_stats.php

<?php
include("include/visitorheader.php");
?>
<h1>Leaderboard</h1>
<ul class="nav nav-tabs">
  <li ><a href="show_best_player_stat.php">Best Player</a></li>
  <li ><a href="show_stadium_stat.php">Popular Venue</a></li>
  <li ><a href="show_goal.php">Top Scorer</a></li>
  <li ><a href="show_assist.php">Top Assist</a></li>
  <li><a href="show_card.php">Most Indisciplined</a></li>
  <li class="active"><a href="show_officials_stats.php">Best Officials </a></li>
  
</ul>



<?php
echo("<h1 style= \"text-align: center\">Most Matches Conduction</h1><br><br><br>");


            $db = oci_connect('system','1234','xe');
            $sql="select official_id,count(*) from match_officials group by official_id order by count(*) desc";
                        $result=oci_parse($db,$sql);			                             		                              
                        oci_execute($result);
                        
                        
                        echo ("<table class = \"table table-bordered\" style= \"text-align:center; background: black;color:white; border-radius:10px\" >");
                        echo " <tr>
                               <th>Official Name</a></th>
                               <th>Nationality</a></th>
                               <th>Matches Conducted</a></th>
                               <th>Qualification</a></th>
                               </tr>";                               
                        while($row=oci_fetch_array($result))
                        {
                            $off=$row[0];
                            $mtc=$row[1];
                            
                            $sql1="select first_name,last_name,nationality,qualification from officials where official_id={$off}";
                            $result1=oci_parse($db,$sql1);
                            oci_execute($result1);
                            while($row1=oci_fetch_array($result1))
                            {
                        echo "<tr>
                                
                                <td>  {$row1[0]} {$row1[1]} </td>
                                <td>  {$row1[2]} </td>
                                <td>  {$mtc} </td>
                                <td>  {$row1[3]} </td>
                                            
                            </tr>";
                            }
                        
                        }
            
            echo "</table>";
                        
                                
        ?>













<?php
include("include/visitorfooter.php");
?>