Ejemplo n.º 1
0
<?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);
}