/booka/trunk

<?php

session_start();

/*

	dbEditor.php

*/

if(!$_SESSION[logedin]){

	header('Location: ./BooKa.php');

}

$errorMsg = null; //ERRORMSG!

include "./inc/dbConnect.php";

//manipulation of DB

$newname = $_POST[name];

$newphone = $_POST[phone];

$newmail = $_POST[email];

$newadress = $_POST[adress];

$newStartDate = $_POST[StartDate];

$newEndDate = $_POST[EndDate];

$valid = true; //this will be true untill it is changed.

include "./inc/formif.php";//ifs and buts for checking if inputed data is there.

include "./inc/regex.php";//RegEX chexing of dates.

//TODO: figure out why the errorMsg is only set by regex.php ...

if( $valid ){

	$db->queryexec("BEGIN;

		INSERT INTO bookings(name, StartDate, EndDate, phone, mail, adress) VALUES('{$newname}', '{$newStartDate}', '{$newEndDate}', '{$newphone}', '{$newmail}', '{$newadress}');

	COMMIT") or die("could not insert in to table");

	sleep(.5);

	header('Location: ./dbEditor.php');

}

//end of DB manipulation.

include "./inc/head.php";

?>

	<div class="head"><img src="./img/Logo.png" alt="BooKa´s logo" /></div>

	<div class="menu2">

		 <h2> You are logedin <a href="logout.php"> [logout] </a><a href="BooKa.php"> [Return] </a> </h2>

		 <hr />

		 <?php

		 if($errorMsg!=null){

		 	echo "	<p class='warning'>".$errorMsg."</p> <!-- this paragraph is created by the php script -->";

		 }

		 ?>

		 <form action="dbEditor.php" method="post">

		 	<div class="lefta">

		 		<label for="name" <?php echo $nameunset ?>>Name</label> <input type="text" name="name" <?php echo $nameunset ?> /> <br />

		 		<label for="phone" <?php echo $phoneunset ?>>Phone number</label> <input type="text" name="phone" id="phone" <?php echo $phoneunset ?> /><br />

		 		<label for="email" <?php echo $emailunset ?>>e-mail address</label> <input type="text" name="email" id="email" <?php echo $emailunset ?> /><br />

		 	</div>

		 	<div class="righta">

		 		<label for="adress" <?php echo $adressunset ?> >adress</label> <input type="text" name="adress" id="adress" <?php echo $adressunset ?> /> <br />

		 		<label for="StartDate" <?php echo $StartDateunset ?>>Start Date </label> <input type="text" name="StartDate" id="StartDate" <?php echo $StartDateunset ?> /><br />

		 		<label for="EndDate" <?php echo $EndDateunset ?> >End Date</label> <input type="text" name="EndDate" id="EndDate" <?php echo $EndDateunset ?> /> <br />

		 		</div>

		 	<input type="hidden" name="fromadd" value="true" />

		 	<p><input type="submit" value="add" name="add" class="add" /></p>

		</form>

		<h2> current DB structure. </h2>

		<table> <!-- tabell -->

			<tr> <!-- row one -->

				<td> id </td>

				<td> Name </td>

				<td> Start Date </td>

				<td> End Date </td>

				<td> Phone Number </td>

				<td> E-mail </td>

				<td> Adress </td>

				<td> remove </td>

			</tr> <!-- end of row one -->

			<?php

			$result = $db->query("SELECT * FROM bookings") or die("could not do query!");

			foreach($result as $row){

			?>

			<tr> <!-- Row two and up -->

				<td> <?php echo $row[id]?> </td>

				<td> <?php echo $row[name]?> </td>

				<td> <?php echo $row[StartDate]?> </td>

				<td> <?php echo $row[EndDate]?> </td>

				<td> <?php echo $row[phone]?> </td>

				<td> <?php echo $row[mail]?> </td>

				<td> <?php echo $row[adress]?> </td>

				<td>

					<form action="removeFromDB.php" method="post">

						<p>

							<input type="submit" value="remove" />

							<input type="hidden" value="<? echo $row[id]?>" name="id"/>

						</p>

					</form>

				</td>

			</tr> <!-- end of row two and up -->

			<?php

			}

			?>

		</table>

	</div>

<?php

include "./inc/foot.php"

?>