Dit is het volledige script:
PHP
<div id="wrapperbody">
<?php
if(isset($_GET["action"])){
$userid = (int)$_GET["action"];
$userid = mysqli_real_escape_string($mysqli, $userid);
if($exec = $mysqli->query("SELECT * FROM `users` WHERE id='$userid'")) {
$count = mysqli_num_rows($exec);
while($user = $exec->fetch_assoc()) {
$username = $user['username'];
$avatar = $user['avatar'];
$fouten = $user['fouten'];
$rank = $user['rank'];
$liefde = $user['liefde'];
$posts = $user['posts'];
$clan = $user['clan'];
$up = $user['up'];
$userid2 = $user['id'];
$userid2 = mysqli_real_escape_string($mysqli, $userid2);
$up = mysqli_real_escape_string($mysqli, $up);
$clan = mysqli_real_escape_string($mysqli, $clan);
$posts = mysqli_real_escape_string($mysqli, $posts);
$liefde = mysqli_real_escape_string($mysqli, $liefde);
$username = mysqli_real_escape_string($mysqli, $username);
$avatar = mysqli_real_escape_string($mysqli, $avatar);
$fouten = mysqli_real_escape_string($mysqli, $fouten);
$rank = mysqli_real_escape_string($mysqli, $rank);
if($exec2 = $mysqli->query("SELECT name FROM `rank` WHERE id='$rank'")) {
while($user = $exec2->fetch_assoc()) {
$name = $user['name'];
$name = mysqli_real_escape_string($mysqli, $name);
}
}
if ($count > 0){
//user bestaat al
?>
<div class="content">
<h2>Profiel van <?php echo $username; ?></h2>
<div class="body">
<img src="<?php echo $avatar; ?>" style="height:100px; width:100px;" >
<table>
<thead>
<tr>
<th scope="col" abbr="Starter">UP</th>
<th scope="col" abbr="Medium">Clan</th>
<th scope="col" abbr="Business">Posts</th>
<th scope="col" abbr="Deluxe">Likes</th>
<th scope="col" abbr="Deluxe">Rank</th>
<th scope="col" abbr="Deluxe">Fouten</th>
</tr>
</thead>
<tbody>
<tr>
<td><?php echo $up; ?></td>
<td><?php echo $clan; ?></td>
<td><?php echo $posts; ?></td>
<td><?php echo $liefde; ?></td>
<td><?php echo $name; ?></td>
<td><?php echo $fouten; ?></td>
</tr>
</tbody>
</table>
</div>
</div>
<div class="content">
<h2>Over mij</h2>
<div class="body">
</div>
</div>
<div class="contentprofiel">
<div class="content2" style="margin-right:20px; float:left;">
<h2>Topics</h2>
<div class="body">
<?php
if($exec = $mysqli->query("SELECT * FROM `topics` WHERE ownerid='$userid'")) {
while($rij = $exec->fetch_assoc()) {
$id = $rij['id'];
$name = $rij['name'];
$id = mysqli_real_escape_string($mysqli, $id);
$name = mysqli_real_escape_string($mysqli, $name);
echo '<li><a href="/topic/'.$id.'">'.$name.'</a></li>';
}
}
?>
</div>
</div>
<div class="content2" style="float:right;">
<h2>Reacties</h2>
<div class="body">
Deze gebruiker bestaat niet (meer).
</div>
</div>
</div>
<?php
}
else {
//user bestaat niet
echo '
<div class="content">
<h2>error</h2>
<div class="body">
Deze gebruiker bestaat niet (meer).
</div>
</div>
';
}
}
} else {
echo '
<div class="content">
<h2>error</h2>
<div class="body">
Deze gebruiker bestaat niet (meer).
</div>
</div>
';
}
} else {
echo '
<div class="content">
<h2>error</h2>
<div class="body">
Deze gebruiker2 bestaat niet (meer).
</div>
</div>
';
}
?>
</div>
