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
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
|
<?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>
<form method="post" action="./removedate.php">
<input type="hidden" name="user1remove" id="user1remove" value="<?php echo $lunchSuggestion[0]; ?>" />
<input type="hidden" name="user2remove" id="user2remove" value="<?php echo $_SESSION['userName']; ?>" />
<button id="remove" name="remove" value="remove">remove</button>
</form>
</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>
<form method="post" action="./removedate.php">
<input type="hidden" name="user1remove" id="user1remove" value="<?php echo $lunchSuggestion[0]; ?>" />
<input type="hidden" name="user2remove" id="user2remove" value="<?php echo $_SESSION['userName']; ?>" />
<button id="remove" name="remove" value="remove">remove</button>
</form>
</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>
<table>
<tr>
<td>
<form method="post" action="./removedate.php">
<input type="hidden" name="user1remove" id="user1remove" value="<?php echo $lunchAcception[0]; ?>" />
<input type="hidden" name="user2remove" id="user2remove" value="<?php echo $_SESSION['userName']; ?>" />
<button id="remove" name="remove" value="remove">remove</button>
</form>
</td>
<td>
<form method="POST" action="./declinedate.php">
<input type="hidden" name="otherUser" value="<?php echo $lunchAcception[0]; ?>"/>
<input type="hidden" name="user" value="<?php echo $_SESSION['userName']; ?>"/>
<input type="hidden" name="DeclineLunch" value="DeclineLunch" />
<button type="Submit" name="AcceptLunch">Avboka</button>
</form>
</td>
</tr>
</table>
</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>
<table>
<tr>
<td>
<form method="POST" action="./acceptdate.php">
<input type="hidden" name="AcceptLunch" value="AcceptLunch" />
<input type="hidden" name="user" value="<?php echo $_SESSION['userName']; ?>"/>
<input type="hidden" name="otherUser" value="<?php echo $lunchAcception[0]; ?>"/>
<button type="Submit" name="AcceptLunch">Acceptera</button>
</form>
</td>
<td>
<form method="post" action="./removedate.php">
<input type="hidden" name="user1remove" id="user1remove" value="<?php echo $_SESSION['userName']; ?>" />
<input type="hidden" name="user2remove" id="user2remove" value="<?php echo $lunchAcception[0]; ?>" />
<button id="remove" name="remove" value="remove">remove</button>
</form>
</td>
</tr>
</table>
</div>
<?php
}
}
?>
|