blob: ee64f2747fc06cc0e1aeb940b145b14845310604 [file] [log] [blame]
<?php
class User{
public $id;
public $nomcomplet;
public $curs;
public $grau;
public $quimata;
public function nom() {
$noms = explode(" ", $this->nomcomplet);
return $noms[0];
}
}
function get_user($id) {
$user = new User();
// 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 WHERE id=".$id;
// Fetch the information of the user
if ($result = $conn->query($query)) {
while ($row = $result->fetch_row()) {
$user->id = $row[0];
$user->nomcomplet = $row[1];
$user->curs = $row[2];
$user->grau = $row[3];
$user->quimata = $row[4];
$user->quielmata = $row[5];
$user->requested = $row[6];
$user->mort = $row[7];
}
$result->close();
} else {
die("Wrong query: " . $query);
}
// Close connection
$conn->close();
return $user;
}
$user = get_user($_GET['user']);
$victim = get_user($user->quimata);
?>