<?php
include ("connect.php"); //verbinding maken
if ($_GET['edit_id']<>"") {
$eid=$_GET['edit_id'];
}
$result = mysql_query("SELECT datum, lat, lon, naam, email FROM test WHERE id = $eid ")or die(mysql_error($dbc));  
$row = mysql_fetch_array( $result );
echo "Laatst bewerkt op: ".$row['datum'];
//echo " Opmerkingen: ".$row['opm'];
//echo "$op";
//echo " dikte: ".$row['dikte'];
$datum = date("Y-m-d"); 
$dank = "<b><font color='#c71585'>Dank u voor het invullen.</font></b>";
?>
<link href="css.css" rel="stylesheet" type="text/css" />


<?php
//============================================================================================
// formulier verzenden controle of alles is ingevuld. Zo ja, database updaten.

if (isset($_POST['submitted'])) 
{ // Handle the form.

    $errors = array();
    $trimmed = array_map('trim', $_POST);           
    if (preg_match ("/^[- a-zA-Z0-9.,]{2,250}$/", $trimmed['opm'])) 
    {
        $op = mysql_real_escape_string(trim($_POST['opm'])); 
    } 
    else     
    {
        $errors[] = "<b><font color='#ff0000'>Vul alle velden in en  gebruik geen leestekens AUB!</font></b>";
    }
    //echo $op;
    if (empty($errors)) 
    { // If everything's OK.
    echo $dank;
        if  ((($_POST['dikte']) == "none") || (empty($_POST['opm'])) || (($_POST['kwa']) == "none"))
        {
            echo "<b><font color='#ff0000'>U heeft iets niet goed ingevuld</font></b>";
        } 
        else 
        {
            $query = "UPDATE test SET dikte='".$_POST['dikte']."',kwa='".$_POST['kwa']."',opm='$op',datum='$datum' WHERE id=$eid";
            $sql = mysql_query($query,$dbc) or die(mysql_error($dbc) );       
        }
    }
    else
    {
        foreach ($errors as $msg) 
        { // Print each error.
			echo " - $msg<br />\n";
		}   
    }
}
//*********************************************************************************************************
echo '
  <table width="40%" border="0" class="greenbox">
    <tr>
      <td width="1"><div id= " eid " style="width: 11px; height: 11px">

</div> </td>
      <td width="277" valign="top"><div id="formDiv"><span class="">

        <table cellpadding="2" cellspacing="0" class="bluebox">
          <form method="post">
            <tr>
              <td colspan="2" align="center">Welkom terug, IJsmeester</td>
            </tr>
		<tr>
              <td>Breedtegraad*</td>
              <td><input id="lat" name="lat" value="' . $row['lat'] . '" disabled=true/></td>
            </tr>
            <tr>
              <td>Lengtegraad*</td>
              <td><input id="lon" value="' . $row['lon'] . '" disabled=true/></td>
            </tr>
		<tr>
              <td>Uw naam*</td>
              <td><input id="naam" value="' . $row['naam'] . '" disabled=true/></td>
            </tr>
		<tr>
              <td>E-mailadres*</td>
              <td><input id="email" value="' . $row['email'] . '" disabled=true/></td>
            </tr>
		              <td>IJsdikte*</td>
              <td>
			<form name="IJsdikte">
			<select name="dikte" size="1" />
			<option value="none" selected="selected">Selecteer ijsdikte</option>
			<option value="nul">0-1 cm<name="dikte"/></option>
			<option value="1">1 cm<name="dikte"/></option>
			<option value="2">2 cm<name="dikte"/></option>
			<option value="3">3 cm<name="dikte"/></option>
			<option value="4">4 cm<name="dikte"/></option>
			<option value="5">5 cm<name="dikte"/></option>
			<option value="6">6 cm<name="dikte"/></option>
			<option value="7">7 cm<name="dikte"/></option>
			<option value="8">8 cm<name="dikte"/></option>
			<option value="9">9 cm<name="dikte"/></option>
			<option value="10">10 cm<name="dikte"/></option>
			<option value="11">11 cm<name="dikte"/></option>
			<option value="12">12 cm<name="dikte"/></option>
			<option value="13">13 cm<name="dikte"/></option>
			<option value="14">14 cm<name="dikte"/></option>
			<option value="15">15 cm<name="dikte"/></option>
			<option value="15">15+cm<name="dikte"/></option>
			</select>
           </td>
            </tr>
		<tr>
              <td>IJskwaliteit*</td>
              <td><form name="IJskwaliteit">
			<select name="kwa" size="1" />
			<option value="none" selected="selected">Selecteer kwaliteit</option>
			<option value="Open water">Open water<name="kwa"/></option>
			<option value="Groot wak">Groot wak<name="kwa"/></option>
			<option value="Zeer dun ijs">Zeer dun ijs<name="kwa"/></option>
			<option value="Bom ijs">Bom ijs<name="kwa"/></option>
			<option value="Slecht ijs">Slecht ijs<name="kwa"/></option>
			<option value="Redelijk ijs">Redelijk ijs<name="kwa"/></option>
			<option value="Mooi ijs">Mooi ijs<name="kwa"/></option>
			<option value="Perfect ijs">Perfect ijs<name="kwa"/></option>
			<option value="Sneeuw ijs">Sneeuw op ijs<name="kwa"/></option>
			</select></td>
            </tr>
		<tr>
              <td>Opmerkingen:*</td>
              <td><input type="text" name="opm"/></td>
            </tr>
		
            <tr>
               <td colspan="2" align="left">
               <input name="submit" type="submit" value="Vervang uw gegevens";/>
               <input name="submit" type="submit" value="Sluit" onclick="window.opener.document.location.reload(); window.close()";/>
               <input type="hidden" name="submitted" value="TRUE" />
</td>
            </tr>
  
          </form>
</table>';


?> 