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
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
|
<?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') {
?>
<div class="dinnerwraps">
<p>Du har bokat lunch med <?php echo $firstName; ?> <?php echo $surName; ?> den <?php echo $datetime; ?> </p>
<p> <?php echo $message; ?></p>
</div>
<?php
} else {
?>
<div class="dinnerwraps">
<p>Du har föreslagit lunch med <?php echo $firstName; ?> <?php echo $surName; ?> den <?php echo $datetime; ?> </p>
<p> <?php echo $message; ?></p>
</div>';
<?php
}
}
$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') {
?>
<div class="dinnerwraps">
<p>Du har bokat lunch med ' <?php echo $firstName; ?> <?php echo $surName; ?> den <?php echo $datetime; ?> </p>
<p><?php echo $message; ?> </p>
<form method="POST" action="">
<input type="hidden" name="user1_2" value="<?php echo $lunchAcception[0]; ?>"/>
<button type="Submit" name="AcceptLunch">Avboka</button>
</form>';
</div>';
<?php
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];
if($lunchquery[0] == 'true') {
$db->exec("UPDATE planLunch SET accepted='false' WHERE(user2='$username' AND user1='{$_POST['user1_2']}')");
header("Location:profile.php?uid=" . $_POST['user1_2']);
}
}
} else {
?>
<div class="dinnerwraps">
<p> <?php echo $firstName; ?> <?php echo $surName; ?> har föreslagit lunch med dig den <?php echo $datetime; ?></p>
<p> <?php $message ?> </p>
<form method="POST" action="">
<input type="hidden" name="user1" value="<?php echo $lunchAcception[0]; ?>"/>
<button type="Submit" name="AcceptLunch">Acceptera</button>
</form>';
</div>';
<?php
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']}')");
header("Location:profile.php?uid=" . $_POST['user1']);
}
}
}
}
?>
|