<?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') {
