';
$sql = 'SELECT user_id, user_name, user_date FROM users WHERE user_id=?';
$stmt = mysqli_stmt_init($dbc);
if (!mysqli_stmt_prepare($stmt, $sql)) {
die('Could not create thread due to internal error: ' . mysqli_error($dbc));
}
mysqli_stmt_bind_param($stmt, 'i', $_GET['id']);
mysqli_stmt_execute($stmt);
$res = mysqli_stmt_get_result($stmt);
$user = mysqli_fetch_assoc($res);
if (!$user) {
nobody_is_here();
} else {
echo 'User: '. $user['user_name'] .'ID#'. $user['user_id'] .'
';
echo 'Registered since '. date('M d, Y', strtotime($user['user_date']));
}
}
?>