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
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
|
<?PHP
$lunchSuggestionArray = $db->query("SELECT user2 from planLunch WHERE user1='$username'");
$lunchSuggestionQuery = $lunchSuggestionArray->fetchAll();
foreach ($lunchSuggestionQuery as $lunchSuggestion) {
$userinfo = $db->query("SELECT firstName from Users WHERE loginName='$lunchSuggestion[0]'");
$self = $userinfo->fetchAll();
$firstName = $self [0]['firstName'];
$userinfo = $db->query("SELECT surName from Users WHERE loginName='$lunchSuggestion[0]'");
$self = $userinfo->fetchAll();
$surName = $self [0]['surName'];
$userinfo = $db->query("SELECT date from planLunch WHERE user1='$username' AND user2='$lunchSuggestion[0]'");
$self = $userinfo->fetchAll();
$datetime = $self [0]['date'];
$userinfo = $db->query("SELECT message from planLunch WHERE user1='$username' AND user2='$lunchSuggestion[0]'");
$self = $userinfo->fetchAll();
$message = $self [0]['message'];
$userinfo = $db->query("SELECT accepted from planLunch WHERE user1='$username' AND user2='$lunchSuggestion[0]'");
$self = $userinfo->fetchAll();
$accepted = $self [0]['accepted'];
if ($accepted=='true') {
echo '<p>Du har bokat lunch med ' . $firstName . ' ' . $surName . ' den ' . $datetime . '</p>';
echo '<p>' . $message . '</p>';
} else {
echo '<p>Du har föreslagit lunch med ' . $firstName . ' ' . $surName . ' den ' . $datetime . '</p>';
echo '<p>' . $message . '</p>';
}
}
$lunchAcceptionArray = $db->query("SELECT user1 from planLunch WHERE user2='$username'");
$lunchAcceptionQuery = $lunchAcceptionArray->fetchAll();
foreach ($lunchAcceptionQuery as $lunchAcception) {
$userinfo = $db->query("SELECT firstName from Users WHERE loginName='$lunchAcception[0]'");
$self = $userinfo->fetchAll();
$firstName = $self [0]['firstName'];
$userinfo = $db->query("SELECT surName from Users WHERE loginName='$lunchAcception[0]'");
$self = $userinfo->fetchAll();
$surName = $self [0]['surName'];
$userinfo = $db->query("SELECT date from planLunch WHERE user2='$username' AND user1='$lunchAcception[0]'");
$self = $userinfo->fetchAll();
$datetime = $self [0]['date'];
$userinfo = $db->query("SELECT message from planLunch WHERE user2='$username' AND user1='$lunchAcception[0]'");
$self = $userinfo->fetchAll();
$message = $self [0]['message'];
$userinfo = $db->query("SELECT accepted from planLunch WHERE user2='$username' AND user1='$lunchAcception[0]'");
$self = $userinfo->fetchAll();
$accepted = $self [0]['accepted'];
if ($accepted=='true') {
echo '<p>Du har bokat lunch med ' . $firstName . ' ' . $surName . ' den ' . $datetime . '</p>';
echo '<p>' . $message . '</p>';
echo '<form method="POST" action="">';
echo '<input type="hidden" name="user1_2" value="'.$lunchAcception[0].'"/>';
echo '<button type="Submit" name="AcceptLunch">Avboka</button>';
echo '</form>';
if (isset($_POST['user1_2'])) {
$luncharray = $db->query("SELECT accepted from planLunch WHERE(user2='$username' AND user1='{$_POST['user1_2']}')");
$lunchinfo = $luncharray->fetchAll();
$lunchquery = $lunchinfo[0];
var_dump($lunchquery[0]);
if($lunchquery[0] == 'true') {
$db->exec("UPDATE planLunch SET accepted='false' WHERE(user2='$username' AND user1='{$_POST['user1_2']}')");
}
}
} else {
echo '<p>' . $firstName . ' ' . $surName . ' har föreslagit lunch med dig den ' . $datetime . '</p>';
echo '<p>' . $message . '</p>';
echo '<form method="POST" action="">';
echo '<input type="hidden" name="user1" value="'.$lunchAcception[0].'"/>';
echo '<button type="Submit" name="AcceptLunch">Acceptera</button>';
echo '</form>';
if (isset($_POST['user1'])) {
$luncharray = $db->query("SELECT accepted from planLunch WHERE(user2='$username' AND user1='{$_POST['user1']}')");
$lunchinfo = $luncharray->fetchAll();
$lunchquery = $lunchinfo[0];
if($lunchquery[0] == 'false') {
$db->exec("UPDATE planLunch SET accepted='true' WHERE(user2='$username' AND user1='{$_POST['user1']}')");
}
}
}
}
?>
|