Sending requests with PHP
diff --git a/index.php b/index.php
new file mode 100644
index 0000000..03b289d
--- /dev/null
+++ b/index.php
@@ -0,0 +1,56 @@
+<html>
+ <head>
+ <meta charset="UTF-8">
+ <title>Pàgina de benvinguda</title>
+ <link rel="stylesheet" href="./css/basic.css" />
+ <link rel="stylesheet" href="./css/login.css" />
+ </head>
+ <body>
+ <div id="outter-container">
+ <div id="inner-container">
+ <h1>Selecciona el teu nom</h1>
+ <h3>Per entrar al joc de la Pastanaga Assessina</h3>
+ <form action="main.php" method="GET">
+ <select name="user">
+ <?php
+ // Define MySQL login variables
+ $servername = "fdb22.awardspace.net";
+ $username = "3155560_users";
+ $password = "btechnoro@fox4news.info";
+
+ // Create connection
+ $conn = new mysqli($servername, $username, $password, "3155560_users");
+ if ($conn->connect_error) die("Connection failed: " . $conn->connect_error);
+ $conn->set_charset("utf8");
+
+ // Do the query
+ $query = "SELECT * FROM users";
+
+ // Fetch the information of the user
+ if ($result = $conn->query($query)) {
+ while ($row = $result->fetch_row()) {
+ $id = $row[0];
+ $nomcomplet = $row[1];
+ $curs = $row[2];
+ $grau = $row[3];
+ $quimata = $row[4];
+
+ // Echo the options
+ echo "<option value='".$id."'>".$nomcomplet."</option>\n";
+ }
+ $result->close();
+ } else {
+ die("Wrong query: " . $query);
+ }
+
+ // Close connection
+ $conn->close();
+ ?>
+ </select>
+
+ <input type="submit" value="Entrar" />
+ </form>
+ </div>
+ </div>
+ </body>
+</html>