/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 profile.php

  • Committer: Daniel Johansson
  • Date: 2013-04-13 22:25:50 UTC
  • Revision ID: maila@danieljohansson.nu-20130413222550-4n2qx901s5vows0n
Made it possible to show interest for lunch with people. Kinda broken still thought.

Show diffs side-by-side

added added

removed removed

Lines of Context:
profile.php
60
60
                        </div>
61
61
                        <div id="wallflow">
62
62
                        <?PHP
63
 
                        $profilename = 'åäö';
 
63
                        $profilename = htmlspecialchars($_GET['uid']);
 
64
                        if($profilename != $username) {
 
65
                                $relationinfo = $db->query("SELECT * from dateInterests WHERE (user1='$profilename' AND user2='$username') OR (user1='$username' AND user2='$profilename')");
 
66
                                $relationquery = $relationinfo->fetchAll();
 
67
                                if($relationquery != array()) {
 
68
                                        echo 'Du har visat intresse för en lunchdejt med den här personen';
 
69
                                        echo '<form method="POST" action="">';
 
70
                                        echo '<button type="Submit" name="Unsubscribe">Sluta visa intresse</button>';
 
71
                                        echo '</form>';
 
72
                                } else {
 
73
                                        echo 'Vill du gå på lunch med den här personen?';
 
74
                                        echo '<form method="POST" action="">';
 
75
                                        echo '<button type="Submit" name="Subscribe">Visa intresse</button>';
 
76
                                        echo '</form>';
 
77
                                }
 
78
                                if (isset($_POST['Subscribe'])) 
 
79
                                { 
 
80
                                        $db->exec("INSERT INTO dateInterests VALUES ('$profilename', '$username')");
 
81
                                        echo 'Du har visat intresse för lunch med personen'; 
 
82
                                }
 
83
                                if (isset($_POST['Unsubscribe'])) 
 
84
                                { 
 
85
                                        $db->exec("DELETE FROM dateInterests WHERE (user1='$profilename' AND user2='$username') OR (user1='$username' AND user2='$profilename')");
 
86
                                        echo 'Du har slutat visa intresse för lunch med personen'; 
 
87
                                }
 
88
                        }
64
89
                        $userinfo = $db->query("SELECT firstName from Users WHERE loginName='$profilename'");
65
90
                        $self = $userinfo->fetchAll();
66
91
                        $firstName = $self [0]['firstName'];
67
92
                        $userinfo = $db->query("SELECT surName from Users WHERE loginName='$profilename'");
68
93
                        $self = $userinfo->fetchAll();
69
 
                        $surName = $self [0]['surName']
 
94
                        $surName = $self [0]['surName'];
 
95
                        $userinfo = $db->query("SELECT city from Users WHERE loginName='$profilename'");
 
96
                        $self = $userinfo->fetchAll();
 
97
                        $city = $self [0]['city'];
 
98
                        $userinfo = $db->query("SELECT eMail from Users WHERE loginName='$profilename'");
 
99
                        $self = $userinfo->fetchAll();
 
100
                        $eMail = $self [0]['eMail'];
70
101
                        ?>
71
102
                        <p class="profilename"><?php echo $firstName . " " . $surName;?></p>
 
103
                        <p> Ort: <?PHP echo $city; ?></p>
 
104
                        <p> Epost: <?PHP echo $eMail; ?></p>
72
105
                        </div>
73
106
                </div>
74
107
        </body>