Untitled

<?php
   include('session.php');
   if(!$_SESSION['login_user']){
	header("location:../index.php");
          exit;}
?>
<html>

   <head>
      <title>Welcome</title>
	  <link rel="stylesheet" type="text/css" href="../ProdyneP.css">
   </head>

   <body>
		<div id="Header">
			<img src="../Images/Prodynelogo.gif">
		</div>
		<h1>Welcome <?php echo $login_session; ?></h1>
			<div id="Table">
			<form action="" method="POST">
					<select name="Table">
						<option value="1"> First Housing</option>
						<option value="2"> RvB </option>
						<option value="3"> Gebiedsmanagers </option>
					</select>
				</select>
				<input type="submit" name="View" value="View"></submit>
				<input type="submit" name="Aanpassen" value="Aanpassen"></submit>
			</form>
			</div>
			<?php
			$value= null;
			$mysqli = new mysqli("localhost", "root", "", "prodyne");
			$values = null;
			?>

			<?php
			If(isset($_POST['View']))
			{
				?><?php
				$value = $_POST['Table'];

				if($value == 1)
				{
					$counter = 0;
					?><div id="View"><table style="width: 50%; text-align: left;">
							<tr><th>Datum</th><th>Voor 09:00</th><th>Na 09:00</th></tr><?php

					$connection = mysqli_connect("localhost","root","");
					if ($connection)
					{
						die('Could not connect: ' . mysqli_error());
					}

					mysqli_select_db("prodyne", $connection);

					$startdate = strtotime("Now");
					$enddate = strtotime("+2 weeks", $startdate);
					$Now = date("Y-m-d");

					$result = mysqli_query("SELECT * FROM firsthousing WHERE Datum >= NOW()");
			?>

			<?php
					while ($row = mysqli_fetch_array($result)) {
						$counter ++;
					?><tr><td><?php echo date('d-m-Y', strtotime($row['Datum']));?></td><td><?php echo $row['Voor0900']; ?></td><td><?php echo $row['Na0900']; ?></td></tr><?php
					$startdate = strtotime("+1 day", $startdate);
					if($counter >= 120)
								{
									break;
								}
					}
				?></table></div><?php
				}

				elseif($value == 2)
				{
					$counter = 0;
				?><div id="View"><table style="width: 50%; text-align: left;">
							<tr><th>Datum</th><th>Voor 15:00</th><th>Na 15:00</th></tr><?php
						$connection = mysqli_connect("localhost","root","");
					if ($connection)
					{
						die('Could not connect: ' . mysqli_error());
					}

					mysqli_select_db("prodyne", $connection);

					$result = mysqli_query("SELECT * FROM rvb WHERE Datum >= NOW()");

						while($row = mysqli_fetch_array($result))

						{
							$counter ++;
							?><tr><td><?php echo date('d-m-Y', strtotime($row['Datum'])); ?>
							</td><td><?php echo $row['Voor1500']; ?></td>
							<td><?php echo $row['Na1500']; ?></td>
							</tr>
							<?php
							if($counter >= 120)
								{
									break;
								}
						}


					?></table></div><?php
				}

				else
				{
					$counter = 0;
					?><div id="View"><table style="width: 50%; text-align: left;">
							<tr><th>Datum</th><th>Voor 15:00</th><th>Na 15:00</th></tr><?php


      $connection = mysqli_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD,DB_DATABASE) or die("Error " . mysqli_error());

    //select MySQLi dabatase table
    $db = mysqli_select_db($connection, "prodyne") or die("Error " . mysqli_error($connection));

    //fetch information from your database
    $result = mysqli_query($connection, "SELECT * FROM gebiedsmanagers WHERE Datum >= NOW()");
      while($row = mysqli_fetch_array($result))

               {
                  $counter ++;

?>
<tr><td><?php echo date('d-m-Y', strtotime($row['Datum']));?></td><td>
<?php echo $row['Voor1500']; ?></td><td><?php echo $row['Na1500']; ?>
</td></tr>
<?php

             if($counter >= 120) {
                break;
          }
					?></table></div><?php
				}

			}
			?><?php
			if(isset($_POST['Aanpassen']))
			{
				$value = $_POST['Table'];
				if($value == 1)
				{
					?><div id="Aanpassen"><form action="" Method="POST">
							Voor 09:00 <select name="Voor0900">
								<option value="Arnold Lammerts">Arnold Lammerts</option>
								<option value="Petra van Son">Petra van Son</option>
								<option value="Roy Dix">Roy Dix</option>
								<option value="Joost Cuppen">Joost Cuppen</option>
								<option value="Paul Bloemendaal">Paul Bloemendaal</option>
								<option value="Bianca Koelemeijer">Bianca Koelemeijer</option>
								<option value="Jan Kramer">Jan Kramer</option>
								<option value="Vanessa Touw">Vanessa Touw</option>
								<option value="NULL">Null</option>
							</select>
							Na 09:00 <select name="Na0900">
								<option value="Arnold Lammerts">Arnold Lammerts</option>
								<option value="Petra van Son">Petra van Son</option>
								<option value="Roy Dix">Roy Dix</option>
								<option value="Joost Cuppen">Joost Cuppen</option>
								<option value="Paul Bloemendaal">Paul Bloemendaal</option>
								<option value="Bianca Koelemeijer">Bianca Koelemeijer</option>
								<option value="Jan Kramer">Jan Kramer</option>
								<option value="Vanessa Touw">Vanessa Touw</option>
								<option value="NULL">Null</option>
							</select><br>
							Datum DD-MM-YYYY <input type="text" name="Datum">
							<input type="submit" name="Pasaan" Value="Pas aan"></submit>
						</form>
						</div>
						<?php
						if(isset($_POST['Pasaan']))
						{
							$Voor = $_POST['Voor0900'];
							$Na = $_POST['Na0900'];
							$Datum = $_POST['Datum'];
							$Datum = DateTime::createFromFormat("d/m/Y" , $Datum);
							$Datum->format('Y-m-d');
							$sql = "UPDATE `firsthousing` SET
							`Voor0900` = '$Voor',
							`Na0900` = '$Na'
							where Datum = '$Datum'";
							if ($db->query($sql) === TRUE)
							{
								echo "New record created successfully";
							} else
							{
								echo "Error: " . $sql . "<br>" . $db->error;
							}
						}


				}
				elseif($value == 2)
				{
					?><div id="Aanpassen"><form action="" Method="POST">
								Voor 15:00 <select name="Voor1500">
									<option value="Rob de Jong">Rob de Jong</option>
									<option value="Rob Groenendijk">Rob Groenendijk</option>
									<option value="Naomi Tas">Naomi Tas</option>
									<option value="NULL">Null</option>
								</select>
								Na 15:00 <select name="Na1500">
									<option value="Rob de Jong">Rob de Jong</option>
									<option value="Rob Groenendijk">Rob Groenendijk</option>
									<option value="Naomi Tas">Naomi Tas</option>
									<option value="NULL">Null</option>
								</select><br>
								Datum DD-MM-YYYY<input type="text" name="Datum">
								<input type="submit" name="Pasaan" Value="Pas aan"></submit>
							</form>
						</div>
					<?php
					if(isset($_POST['Pasaan']))
					{
						$Voor = $_POST['Voor1500'];
						$Na = $_POST['Na1500'];
						$Datum = $_POST['Datum'];
						$Datum = DateTime::createFromFormat("d/m/Y" , $Datum);
						$Datum->format('Y-m-d');
						$sql = "UPDATE `rvb` SET
						`Voor1500` = '$Voor',
						`Na1500` = '$Na'
						where Datum = '$Datum'";
						if ($db->query($sql) === TRUE)
						{
							echo "New record created successfully";
						} else
						{
							echo "Error: " . $sql . "<br>" . $db->error;
						}
					}


				}
				else
				{
					?><div id="Aanpassen"><form action="" Method="POST">
								Voor 15:00 <select name="Voor1500">
									<option value="Renate Jansen">Renate Jansen</option>
									<option value="Loes Roelofs">Loes Roelofs</option>
									<option value="Linda Pastor">Linda Pastor</option>
									<option value="Renee Lamertink">Renee Lamertink</option>
									<option value="Karin Poelemeijer">Karin Poelemeijer</option>
									<option value="Nanno van Rede">Nanno van Rede</option>
									<option value="Saskia Uijtdehaage">Saskia Uijtdehaage</option>
									<option value="Kirsten Jacobs van der Werf">Kirsten Jacobs van der Werf</option>
									<option value="Ruud van der Meer">Ruud van der Meer</option>
									<option value="Esther van de Haar">Esther van de Haar</option>
									<option value="NULL">Null</option>
								</select>
								Na 15:00 <select name="Na1500">
									<option value="Renate Jansen">Renate Jansen</option>
									<option value="Loes Roelofs">Loes Roelofs</option>
									<option value="Linda Pastor">Linda Pastor</option>
									<option value="Renee Lamertink">Renee Lamertink</option>
									<option value="Karin Poelemeijer">Karin Poelemeijer</option>
									<option value="Nanno van Rede">Nanno van Rede</option>
									<option value="Saskia Uijtdehaage">Saskia Uijtdehaage</option>
									<option value="Kirsten Jacobs van der Werf">Kirsten Jacobs van der Werf</option>
									<option value="Ruud van der Meer">Ruud van der Meer</option>
									<option value="Esther van de Haar">Esther van de Haar</option>
									<option value="NULL">Null</option>
								</select><br>
								Datum DD-MM-YYYY<input type="text" name="Datum">
								<input type="submit" name="Pasaan" Value="Pas aan"></submit>
							</form>
							</div>
					<?php
					if(isset($_POST['Pasaan']))
					{
						$Voor = $_POST['Voor1500'];
						$Na = $_POST['Na1500'];
						$Datum = $_POST['Datum'];
						$Datum = DateTime::createFromFormat("d/m/Y" , $Datum);
						$Datum->format('Y-m-d');
						$sql = "UPDATE `gebiedsmanagers` SET
						`Voor1500` = '$Voor',
						`Na1500` = '$Na'
						where Datum = '$Datum'";
						if ($db->query($sql) === TRUE)
						{
							echo "New record created successfully";
						}
						else
						{
							echo "Error: " . $sql . "<br>" . $db->error;
						}
					}
				}
			}
		}?>


      <div class="Signout"><h2><a href = "logout.php">Sign Out</a></h2></div>
   </body>

 <html>