<?php header('Content-Type: application/json; charset=utf-8'); require_once 'connection.php'; session_start(); if (isset($_SESSION['userid'])) { $user = $_SESSION['userid']; $connect = new connection(); $connect->connect(); $number = $connect->escapestring($_GET["number"]); $sql = "SELECT `mailid`,`senderid`,`empfaengerid`,`text` FROM `mail` WHERE (`senderid` = " . $user . " OR `empfaengerid` = " . $user . ") order by `gesendet` LIMIT " . $number; $connect->setsql($sql); $row = $connect->getmap(); echo json_encode($row); }
<?php header('Content-Type: application/json; charset=utf-8'); require_once 'connection.php'; $user = $_GET["user"]; $connect = new connection(); $connect->setsql("SELECT * FROM `profil` WHERE id=" . $user); $connect->connect(); $row = $connect->getarray(); if ($row['sex'] == '0') { $sex = "keine Angabe"; } if ($row['sex'] == '1') { $sex = "Männlich"; } if ($row['sex'] == '2') { $sex = "Weiblich"; } if ($row['orientierung'] == '0') { $ori = "keine Angabe"; } if ($row['orientierung'] == '1') { $ori = "Heterosexuel"; } if ($row['orientierung'] == '2') { $ori = "Homosexuel"; } if ($row['orientierung'] == '3') { $ori = "Bisexuel"; } if ($row['orientierung'] == '4') {