/extremedating/trunk

To get this branch, use:
bzr branch http://gegoxaren.bato24.eu/bzr/extremedating/trunk

« back to all changes in this revision

Viewing changes to index.php

  • Committer: Daniel Johansson
  • Date: 2013-04-14 01:15:06 UTC
  • Revision ID: maila@danieljohansson.nu-20130414011506-eq1u7to43oruok14
Separated out files

Show diffs side-by-side

added added

removed removed

Lines of Context:
index.php
55
55
                                </form>
56
56
                        </div>
57
57
                        <div id="profileimg">
58
 
                                <img class="profilepic" src="./get_image.php?userName=<?PHP echo $username;?>"/>
59
 
                                <a href="profile.php?uid=<?php echo $username; ?>" class="profilename"><?php echo $firstName . " " . $surName;?></a>
60
 
                                <p class="smallheader">Personer jag vill träffa:</p>
61
 
                                <?PHP
62
 
                                        $relationinfo = $db->query("SELECT user2 from dateInterests WHERE(user1='$username')");
63
 
                                        $relationstring = $relationinfo->fetchAll();
64
 
                                        echo '<UL>';
65
 
                                        foreach ($relationstring as $relationquery) {
66
 
                                                $userinfo = $db->query("SELECT firstName from Users WHERE loginName='$relationquery[0]'");
67
 
                                                $self = $userinfo->fetchAll();
68
 
                                                $firstName = $self [0]['firstName'];
69
 
                                                $userinfo = $db->query("SELECT surName from Users WHERE loginName='$relationquery[0]'");
70
 
                                                $self = $userinfo->fetchAll();
71
 
                                                $surName = $self [0]['surName'];
72
 
                                                echo '<li><a href="./profile.php?uid=' . $relationquery[0] . '">' . $firstName . ' ' . $surName . '</a></li>';
73
 
                                        }
74
 
                                        echo '</UL>';
75
 
                                        echo '<p class="smallheader">Personer som vill träffa mig:</p>';
76
 
                                        echo '<UL>';
77
 
                                        
78
 
                                        $relationinfo = $db->query("SELECT user2 from dateInterests WHERE(user1='$username')");
79
 
                                        $relationstring = $relationinfo->fetchAll();
80
 
                                        foreach ($relationstring as $relationquery) {
81
 
                                                $relation2info = $db->query("SELECT user2 from dateInterests WHERE(user1='$relationquery[0]')");
82
 
                                                $relation2string = $relation2info->fetchAll();
83
 
                                                foreach ($relation2string as $relation2query) {;
84
 
                                                        if($relation2query[0] == $username){
85
 
                                                        $userinfo = $db->query("SELECT firstName from Users WHERE loginName='$relationquery[0]'");
86
 
                                                        $self = $userinfo->fetchAll();
87
 
                                                        $firstName = $self [0]['firstName'];
88
 
                                                        $userinfo = $db->query("SELECT surName from Users WHERE loginName='$relationquery[0]'");
89
 
                                                        $self = $userinfo->fetchAll();
90
 
                                                        $surName = $self [0]['surName'];
91
 
                                                                echo '<li><a href="./profile.php?uid=' . $relationquery[0] . '">' . $firstName . ' ' . $surName . '</a></li>';
92
 
                                                        }
93
 
                                                }
94
 
                                        }
95
 
                                        echo '</UL>';
96
 
                                ?>
 
58
                                <?PHP include './sidepanel.php'; ?>
97
59
                        </div>
98
60
                        <div id="wallflow">
99
61
                                <?PHP include './feed.php'; ?>