<?php
$data = new mysqli('localhost', 'root', '', '');
if ($data->connect_error) { die("Connection failed: " . $data->connect_error); }
$username = $data->real_escape_string($_GET['username']);
$exe = $data->query("SELECT look FROM users WHERE username = '$username'");
if ($exe->num_rows > 0) {
while($row = $exe->fetch_assoc()) {
print "<img src=\"http://habbo.nl/habbo-imaging/avatarimage?figure={$row['look']}&direction=3&head_direction=3&action=wav&size=s\">";
}
} else {
echo 'Username not found';
}
$data->close();
?>