php-mysql/fifa.php at master · gituman/php-mysql · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
<?php include 'controllers/authController.php'?>
<?php require 'head.php'; ?>
<!DOCTYPE html>
<html>
<head>
<title> fifa leaderboard</title>
<style>
{
    background-image: linear-gradient(rgba(0,0,0,0.3),transparent),url(esport.jpg);
    background-size: cover;
    background-position: center;
}
table {
border: 1px solid black;
width: 80%;
color: #588c7e;
font-family: monospace;
font-size: 25px;
text-align: left;
}
th {
background-color: #588c7e;
color: white;
}
tr:nth-child(even) {background-color: #f2f2f2}
ul{
   margin: 0px;
   padding: 0px;
   list-style: none;
}
ul li{
    float: right;
    width: 200px;
    height: 40px;
    line-height: 40px;
    text-align: center;
    font-size: 20px;
}
ul li a{
     text-decoration: none;
     color: black;
     display: block;
    }
    .h2{
        position: absolute;
    }
</style>
</head>
<body>
    <ul>
    <li><a href="index.php">home</a></li>
  <li><a href="cod.php">callofduty</a>
  <li><a href="mk.php">mortalkombat</a>
</ul>
<table>
<h2>fifa leaderboard</h2>
<tr>

<th>username</th>
<th>points</th>

</tr>
<?php
 $conn = new mysqli('localhost','root','','user-verification');
 if($conn-> connect_error){
     die("connection failed:". $conn-> connect_error);
 }
 $sql = "SELECT users.username,game.fifa,game.fpoints
 from users,game
where users.username=game.username and game.fifa='yes' and users.region='kenya'
order by game.fpoints DESC";

 $result = $conn-> query($sql);

 if($result-> num_rows> 0){
     while($row = $result-> fetch_assoc()){
         echo"<tr>

         <td>". $row["username"]."</td>
         <td>". $row["fpoints"]."</td>
         </tr>";
     }
     echo "</table>";
 }
 else{
     echo "0 result";
 }

 $conn-> close();
?>

</body>
</html>