blob: ee64f2747fc06cc0e1aeb940b145b14845310604 [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
19 $servername = "fdb22.awardspace.net";
20 $username = "3155560_users";
21 $password = "btechnoro@fox4news.info";
Andreu0d72bd62019-09-17 23:31:14 +020022
Andreu66ad5cf2019-09-18 17:15:44 +020023 // Create connection
24 $conn = new mysqli($servername, $username, $password, "3155560_users");
25 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];
39 $user->quielmata = $row[5];
40 $user->requested = $row[6];
41 $user->mort = $row[7];
42 }
43 $result->close();
44 } else {
45 die("Wrong query: " . $query);
46 }
47
48 // Close connection
49 $conn->close();
50
51 return $user;
52 }
53
54 $user = get_user($_GET['user']);
55 $victim = get_user($user->quimata);
Andreu0d72bd62019-09-17 23:31:14 +020056?>