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
|
<img class="profilepic" src="./get_image.php?userName=<?PHP echo $username;?>"/>
<a href="profile.php?uid=<?php echo $username; ?>" class="profilename"><?php echo $firstName . " " . $surName;?></a>
<p class="smallheader">Personer jag vill träffa:</p>
<?PHP
/*
ExtremeDating - a Hackathon 2013 project.
Copyright (C) 2013 Gustav Hartvigsson <gustav.hartvigsson@gmail.com>
Copyright (C) 2013 Daniel Johansson <maila@danieljohansson.nu>
This program is free software: you can redistribute it and/or modify
it under the terms of the GNU Affero General Public License as
published by the Free Software Foundation, either version 3 of the
License, or (at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU Affero General Public License for more details.
You should have received a copy of the GNU Affero General Public License
along with this program. If not, see <http://www.gnu.org/licenses/>.
*/
$relationinfo = $db->query("SELECT user2 from dateInterests WHERE(user1='$username')");
$relationstring = $relationinfo->fetchAll();
echo '<UL>';
foreach ($relationstring as $relationquery) {
$userinfo = $db->query("SELECT firstName from Users WHERE loginName='$relationquery[0]'");
$self = $userinfo->fetchAll();
$firstName = $self [0]['firstName'];
$userinfo = $db->query("SELECT surName from Users WHERE loginName='$relationquery[0]'");
$self = $userinfo->fetchAll();
$surName = $self [0]['surName'];
echo '<li><a href="./profile.php?uid=' . $relationquery[0] . '">' . $firstName . ' ' . $surName . '</a></li>';
}
echo '</UL>';
echo '<p class="smallheader">Personer som vill träffa mig:</p>';
echo '<UL>';
$relationinfo = $db->query("SELECT user2 from dateInterests WHERE(user1='$username')");
$relationstring = $relationinfo->fetchAll();
foreach ($relationstring as $relationquery) {
$relation2info = $db->query("SELECT user2 from dateInterests WHERE(user1='$relationquery[0]')");
$relation2string = $relation2info->fetchAll();
foreach ($relation2string as $relation2query) {;
if($relation2query[0] == $username){
$userinfo = $db->query("SELECT firstName from Users WHERE loginName='$relationquery[0]'");
$self = $userinfo->fetchAll();
$firstName = $self [0]['firstName'];
$userinfo = $db->query("SELECT surName from Users WHERE loginName='$relationquery[0]'");
$self = $userinfo->fetchAll();
$surName = $self [0]['surName'];
echo '<li><a href="./profile.php?uid=' . $relationquery[0] . '">' . $firstName . ' ' . $surName . '</a></li>';
}
}
}
echo '</UL>';
?>
|