Untitled

<html>
<head><title>Mijn Account</title>
	<link href="opmaak.css" rel="stylesheet" >
	  <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
  <script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/js/bootstrap.min.js"></script>
</head>
<body><div id="header"> </div>
<div class="navbar navbar-inverse" style="margin-top:-1px">
  <div class="container-fluid">
    <div class="navbar-header">
      <a class="navbar-brand" href="index.php">Sport2Day</a>
    </div>
    <div>
      <ul class="nav navbar-nav">
        <li><a href="index.php">Home</a></li>
        <li><a href="tarieven.php">Tarieven</a></li>
        <li><a href="over.php">Over Sport2Day</a></li>
       	   <li><a href="vestigingen.php">Vestigingen</a></li><li><a href="contact.php">Contact</a></li>
		<?php
		session_start();
		if(!isset($_SESSION['username']))
			{
			echo '
		<li><a href="login2.php">Log in</a></li>';
			}

		if(isset($_SESSION['username']))
		{
			echo "<li class='active'><a href='tabel2.php'>Mijn sportgegevens</a></li>

        <li><a href='logout.php'>Log uit</a></li>
		";
		}
		if(isset($_SESSION['username']) and $_SESSION['rank'] > 0)
		{
			echo "<li><a href='mails.php'>Mailgegevens</a></li><li><a href='sportactiviteiten.php'>Sportactiviteiten</a></li>
			";
		}
		?>
	  </ul>
    </div>
  </div>
</div>


<h2>Sportgegevens</h2>
<table class="table responsive">
<tr>

	<th>Voornaam</th>
	<th>Nickname</th>
	<th>Activiteit</th>
	<th>Tijd</th>
</tr>


<?php

$connect = mysql_connect('localhost', 'sten', '') or die ('Couldn\'t Connect');
mysql_select_db("test") or die ("Couldn\'t Find your database !");
$user = $_SESSION['username'];
$query = "SELECT * FROM users WHERE username = '$user'";
$resultaat = mysql_query($query);
$rij = mysql_fetch_array($resultaat);
$testrij = $rij['id'];
if(isset($_SESSION['username']))
{
    $query = sprintf("SELECT * FROM users, sportact WHERE username='$user' AND klant_id = '$testrij'",
    mysql_real_escape_string($user));
    $rows = mysql_query($query);


    $numrows = mysql_num_rows($rows);
	if (!$numrows)
	{
		echo "<center>Er zijn geen sportgegevens gevonden</center>";
	}
}
    if($numrows)
    {
        while($row = mysql_fetch_assoc($rows))
        {
            $dbusername = $row['username'];
            $dbpassword = $row['password'];
            $dbnickname = $row['nickname'];
			$dbonderdeel = $row['onderdeel'];
			$dbonderdeel2 = $row['tijd'];
			?>


<tr>

<td><?php print($row["username"]); ?></td>
<td><?php print($row["nickname"]); ?></td>
<td><?php print($row["onderdeel"]); ?></td>
<td><?php print($row["tijd"]); ?></td>
<?php
}

            echo("<p>De gegevens van: $dbusername met nickname: $dbnickname</p>");

        $_SESSION['username']=$dbusername;
    }
    else
		echo $numrows;


?>
</tr>


<div class="footer">Sport2Day | info@sport2day.nl | &copy; 2017 - Sport2Day</div>
</body>
</html>