<?
include ('header.php');
?>


<div id='Content'>
<div class="content"> 
<div class="titel">Standen Overzicht</div> 
<p>


<?PHP
$tabel ="TMD1_standen";
$opdracht = "SELECT * FROM $tabel";
$result = mysql_query($opdracht);


	    if($_GET['standen']){
		$query = mysql_query("SELECT `id`, `stand`, `clubnr1`, `clubnr2` FROM `medailes` 
		WHERE `id` = '$id' LIMIT 1"); 
		while($row = mysql_fetch_object($query)){
		
		?>






<table>
	<tr>
		<td width="10%"><b>ID Nummer</b></td>
		<td width="10%"><b>Stand</b></td>
        <td width="10%"><b>Club Thuis</b></td>
		<td width="10%"><b>Club Uit</b></td>
		<td width="10%"><b>Gele kaarten</b></td>
		<td width="10%"><b>Rode kaarten</b></td>
	</tr>


	<tr onmouseover="this.bgColor='<?= $config['tabel_bg']; ?>'" onmouseout="this.bgColor=''">
    <td> <?=$row->id;?> </td>
	<td> <?=$row->stand;?> </td>
	<td> <?=$row->clubnr1;?> </td>.
	<td> <?=$row->clubnr2;?> </td>
	
    </tr>
</table>




    
</p>
</div>
</div>


<?PHP
include ('footer.php');
?>

<?
include ('header.php');
?>


<div id='Content'>
<div class="content"> 
<div class="titel">Standen Overzicht</div> 
<p>
<table>
	<tr>
		<td width="10%"><b>ID Nummer</b></td>
		<td width="10%"><b>Stand</b></td>
        <td width="10%"><b>Club Thuis</b></td>
		<td width="10%"><b>Club Uit</b></td>
		<td width="10%"><b>Gele kaarten</b></td>
		<td width="10%"><b>Rode kaarten</b></td>
	</tr>


<?PHP
$tabel ="TMD1_standen";
$opdracht = "SELECT * FROM $tabel";
$result = mysql_query($opdracht);




		while($row = mysql_fetch_object($result)){
		
?>




	
	<tr onmouseover="this.bgColor='#DDDDDD'" onmouseout="this.bgColor=''">
    <td> <?=$row->id;?> </td>
	<td> <?=$row->stand;?> </td>
	<td> <?=$row->clubnr1;?> </td>
	<td> <?=$row->clubnr2;?> </td>
	<td> <?=$row->geel;?> </td>
	<td> <?=$row->rood;?> </td>		
    </tr><?php }
	?>
</table>




    
</p>
</div>
</div>


<?PHP
include ('footer.php');
?>

if(isset($_POST['verzenden']))
{
	$stand = $_POST['stand'];
	if (empty($_POST['stand']))
	{
		echo'U heeft geen stand ingevoerd<br/>';
	}
	elseif (empty($_POST['clubnr1']))
	{
		echo'U heeft geen club #1 ingevoerd<br/>';
	}

<?php
include ('header.php');
if(isset($_POST['verzenden']))
{


$stand = ($_POST['stand']);
$clubnr1 = ($_POST['clubnr1']);
$clubnr2 = ($_POST['clubnr2']);
$geel = ($_POST['geel']);
$rood = ($_POST['rood']);
$tabelnaam = 'tmd1_standen';
$result = "INSERT INTO $tabelnaam values ('','$stand','$clubnr1','$clubnr2','$geel','$rood')"; 
if (mysql_query($result)) {
echo "


		<div id='Content'>
		<div class='content'> 
		<div class='titel'>Stand Verwerkt</div> 
		<p>U heeft uw lid aangemaakt en is verzonden! <a href='standen_toevoegen.php'>Voer nog een stand in</a></p> 
		</div>
		</div>
		";


} else {


echo "


		<div id='Content'>
		<div class='content'> 
		<div class='titel'>Stand niet verwerkt</div> 
		<p>het aanmaken is mislukt! <a href='standen_toevoegen.php'>Ga terug naar de homepagina</a></p> 
		</div>
		</div>
		";
echo mysql_error();
}
}


else
{
?> 






<?php if(ingelogd('id', 'wachtwoord', 'hash') == TRUE){ ?>
		<div id='Content'>
		<div class='content'> 
		<div class='titel'>Stand Toevoegen</div> 
		<p>
		
<form name="verwerken" action="standen_toevoegen.php" method='post'>
  <p>
  <table>
  <tr>
  <td width=330px;> Stand: </td>
  <td width=330px;> <input name='stand' type='text'> </td>
  </tr>


  <tr>
  <td width=330px;> Club 1: </td>
  <td width=330px;> <input name='clubnr1' type='text'> </td>
  </tr>
  
  <tr>
  <td width=330px;> Club 2: </td>
  <td width=330px;> <input name='clubnr2' type='text'> </td>
  </tr>
  
  <tr>
  <td width=330px;> Geel: </td>
  <td width=330px;> <input name='geel' type='text'> </td>
  </tr>
  
  <tr>
  <td width=330px;> Rood: </td>
  <td width=330px;> <input name='rood' type='text'> </td>
  </tr>
  
  <tr>
  <td width=330px;> Verzenden: </td>
  <td width=330px;> <input name='verzenden' type='submit' value='verzenden'> </td>
  </tr>
  </table>
  </form>      


	
		</p> 
		</div>
		</div>
		
		<?PHP } else { ?>


		<div id='Content'>
		<div class='content'> 
		<div class='titel'>Niet ingelogd</div> 
		<p>
		
		U dient voor deze pagina ingelogd te zijn.
	
		</p> 
		</div>
		</div>
		<?PHP
		}
		?>




<?PHP
}
?>








<div id='Content'>
<div class="content"> 
<div class="titel">Banners</div> 
<p>


<center>
<?
// path van de banners 
$banner[1] = "images/banners/rapifa.gif"; 
$banner[2] = "images/banners/global.png";


// de url's waaraan het plaatje gekoppeld moet worden
$url[1] = "http://www.rapifa.nl"; 
$url[2] = "http://www.globalmaffia.nl"; 


// voer alt tags in
$alt[1] = "Webhosting op maat";
$alt[2] = "Lets play the game";


// hoeveel banners zijn er?
$banners = count($banner);
$random = rand(1, $banners); 


echo "<p><a href=\"" . $url[$random] . "\" target=\"_blank\"> ";
echo "<img src=\"" . $banner[$random] . "\" border=\"1\" style=\"border-color: #000000\" width=\"468\" height=\"60\" alt=\"" . $alt[$random] . "\" title=\"" . $alt[$random] . "\"></a></p>";
?> 
</center>
</p> 
</div>
</div>










<?php
include ('footer.php');
?>

if($_SERVER['REQUEST_METHOD'] == 'POST')
    {


    if(empty($_POST['stand']))
        { 
            echo "Er is niks ingevuld";
        }


    elseif(empty($_POST['clubnr1']))
        { 
            echo "Er is niks ingevuld";
        }


    elseif(empty($_POST['clubnr2']))
        { 
            echo "Er is niks ingevuld";
        }


        






        
    if(((preg_match('')