1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
|
<?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);
}
}
?>
|