query("SELECT * from dateInterests WHERE (user1='$profilename' AND user2='$username') OR (user1='$username' AND user2='$profilename')");
$relationquery = $relationinfo->fetchAll();
if($relationquery != array()) {
echo 'Du har visat intresse för en lunchdejt med den här personen';
echo '';
} else {
echo 'Vill du gå på lunch med den här personen?';
echo '';
}
if (isset($_POST['Subscribe']))
{
$db->exec("INSERT INTO dateInterests VALUES ('$profilename', '$username')");
echo 'Du har visat intresse för lunch med personen';
}
if (isset($_POST['Unsubscribe']))
{
$db->exec("DELETE FROM dateInterests WHERE (user1='$profilename' AND user2='$username') OR (user1='$username' AND user2='$profilename')");
echo 'Du har slutat visa intresse för lunch med personen';
}
}
$userinfo = $db->query("SELECT firstName from Users WHERE loginName='$profilename'");
$self = $userinfo->fetchAll();
$firstName = $self [0]['firstName'];
$userinfo = $db->query("SELECT surName from Users WHERE loginName='$profilename'");
$self = $userinfo->fetchAll();
$surName = $self [0]['surName'];
$userinfo = $db->query("SELECT city from Users WHERE loginName='$profilename'");
$self = $userinfo->fetchAll();
$city = $self [0]['city'];
$userinfo = $db->query("SELECT eMail from Users WHERE loginName='$profilename'");
$self = $userinfo->fetchAll();
$eMail = $self [0]['eMail'];
?>
Ort:
Epost: