/extremedating/trunk

<?php ?>

<form method="POST" action="">

  <div id="datetimepicker" class="input-append date">

    <input data-format="yyyy-MM-dd hh:mm:ss" type="datetime" name="date"> </input>

    <span class="add-on">

      <i data-time-icon="icon-time" data-date-icon="icon-calendar"></i>

    </span>

  </div>

  </script>

    <script type="text/javascript">

      $('#datetimepicker').datetimepicker({

     });

  </script>

  </body>

  <input type="text" name="message">

  <button type="Submit" name="SuggestLunch">Föreslå lunch</button>

	</form>

	<?php

	$user2 = htmlspecialchars($_GET['uid']);

	if (isset($_POST['SuggestLunch'])) {

		$query = "INSERT INTO planLunch (

		user1,

		user2,

		message,

		date,

		accepted

		)

		VALUES(

		'{$username}',

		'{$user2}',

		'{$_POST['message']}',

		'{$_POST['date']}',

		'false'

		);";

		try {

		$lunchinfo = $db->query("SELECT * from planLunch WHERE(user1='$username' AND user2='$user2')");

			$lunchquery = $lunchinfo->fetchAll();

			if($lunchquery == array()) {

				$db->exec($query);

			}

		} catch (PDOException $err) {

			var_dump($err);

		}

	}

?>