· 10 years ago · Apr 24, 2016, 01:30 AM
1<!DOCTYPE html>
2<html>
3<head>
4 <meta charset="utf-8">
5 <meta http-equiv="X-UA-Compatible" content="IE=edge">
6 <meta name="viewport" content="width=device-width, initial-scale=1">
7 <title>Cosmic Game of Thrones</title>
8 <link rel="stylesheet" href="styles.css">
9</head>
10<body>
11
12<?php
13$servername = "cosmicgot.dev";
14$username = "root";
15$password = "root";
16$dbname = "gameofthrones";
17
18// Create connection
19$conn = new mysqli($servername, $username, $password, $dbname);
20// Check connection
21if ($conn->connect_error) {
22 die("Connection failed: " . $conn->connect_error);
23}
24
25$sql = "SELECT a.name,a.active,a.survived,a.dead,a.killer,b.playername, a.player_id FROM characters AS a LEFT JOIN player AS b ON a.player_id = b.player_id";
26$result = $conn->query($sql);
27
28#Andrew
29echo "<h1>". "Andrew". "</h1>";
30echo "<table border='1' cellpadding='5' cellspacing='0'>";
31echo "<tr><td>Character</td><td>Active</td><td>Survivor</td><td>Dead</td><td>Murderer</td><td>Total</td></tr>";
32
33while ($row = mysqli_fetch_array($result)) {
34
35 $row["killer"] = $row["killer"] * 10;
36 $row["survived"] = $row["survived"] * 10;
37
38 if($row['player_id'] == 1) {
39 echo "<tr>";
40 echo "<td>" . $row["name"] . "</td>";
41
42 if ($row['active'] == 1) {
43 echo "<td>" . "Active" . "</td>";
44 }
45 if ($row['active'] == 0){
46 echo "<td>" . "Not Active" . "</td>";
47 }
48
49 echo "<td>" . $row["survived"] . "</td>";
50
51 if ($row['dead'] == 0) {
52 echo "<td>" . $row['dead'] . "</td>";
53 }
54 if ($row['dead'] == 1) {
55 $row['dead'] = $row['dead'] - 11;
56 echo "<td>" . $row['dead'] . "</td>";
57 }
58
59 echo "<td>" . $row["killer"] . "</td>";
60
61 $totals = $row["killer"] + $row["survived"] + $row["dead"];
62 echo "<td>" . $totals . "</td>";
63
64 echo "</tr>";
65 }
66}
67 echo "</table>";
68
69 mysqli_data_seek($result, 0);
70
71?>
72
73</body>
74</html>
75
76USE gameofthrones;
77
78DROP TABLE IF EXISTS player;
79CREATE TABLE player
80(
81 player_id int unsigned NOT NULL auto_increment, #unique player id
82 playername varchar(40) NOT NULL, #player name
83
84 PRIMARY KEY (player_id)
85);
86
87DROP TABLE IF EXISTS characters;
88CREATE TABLE characters
89(
90 name varchar(40) NOT NULL, #character name
91 active tinyint(1) unsigned NOT NULL, #char active status
92 survived smallint unsigned NOT NULL, #char alive status
93 dead smallint unsigned NOT NULL, #char dead status
94 killer smallint unsigned NOT NULL, #char killed amount
95 player_id int unsigned NOT NULL, #assign player id to character
96
97 PRIMARY KEY (name)
98);