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') {
?>
Du har bokat lunch med den
Du har föreslagit lunch med den
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') {
?>
Du har bokat lunch med ' den
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 {
?>
har föreslagit lunch med dig den