<?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); }