blob: 2dd713e7e8ddc9391a4cf678c56f09df75030c74 [file] [log] [blame]
Andreu0d72bd62019-09-17 23:31:14 +02001<?php
Andreu66ad5cf2019-09-18 17:15:44 +02002 class User{
3 public $id;
4 public $nomcomplet;
5 public $curs;
6 public $grau;
7 public $quimata;
8
9 public function nom() {
10 $noms = explode(" ", $this->nomcomplet);
11 return $noms[0];
12 }
13 }
14
15 function get_user($id) {
16 $user = new User();
17
18 // Define MySQL login variables
Andreued8e1f92019-09-18 22:26:04 +020019 $servername = "localhost"; // "fdb22.awardspace.net";
20 $username = "root"; // "3155560_users";
21 $password = ""; // "btechnoro@fox4news.info";
Andreu0d72bd62019-09-17 23:31:14 +020022
Andreu66ad5cf2019-09-18 17:15:44 +020023 // Create connection
Andreued8e1f92019-09-18 22:26:04 +020024 $conn = new mysqli($servername, $username, $password, "pastanaga");
Andreu66ad5cf2019-09-18 17:15:44 +020025 if ($conn->connect_error) die("Connection failed: " . $conn->connect_error);
26 $conn->set_charset("utf8");
27
28 // Do the query
29 $query = "SELECT * FROM users WHERE id=".$id;
Andreu0d72bd62019-09-17 23:31:14 +020030
Andreu66ad5cf2019-09-18 17:15:44 +020031 // Fetch the information of the user
32 if ($result = $conn->query($query)) {
33 while ($row = $result->fetch_row()) {
34 $user->id = $row[0];
35 $user->nomcomplet = $row[1];
36 $user->curs = $row[2];
37 $user->grau = $row[3];
38 $user->quimata = $row[4];
Andreuffefd222019-09-19 11:09:44 +020039 $user->requested = $row[5];
40 $user->mort = $row[6];
Andreu66ad5cf2019-09-18 17:15:44 +020041 }
42 $result->close();
43 } else {
44 die("Wrong query: " . $query);
45 }
46
47 // Close connection
48 $conn->close();
49
50 return $user;
51 }
52
53 $user = get_user($_GET['user']);
54 $victim = get_user($user->quimata);
Andreu0d72bd62019-09-17 23:31:14 +020055?>