<?php
/**
 * Created by IntelliJ IDEA.
 * User: Vali
 * Date: 19.05.2017
 * Time: 18:26
 */
    session_start();
    $idUser=$_SESSION['id'];
    //echo $idUser;
    //$idUser = 3;
    //$idUser = $_GET['idUser'];
    $conn = new mysqli("localhost","root","1234","lab10");

    // Check connection
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }
    $sql = "SELECT id, type, severity, date, message FROM logs WHERE idUser=?";

    $stmt = $conn->prepare($sql);
    $stmt->bind_param("i",$idUser);
    $stmt->execute();
    $stmt->bind_result($id,$type,$severity,$date,$message);

    $logs = array();
    while($stmt->fetch()){
        $log = new StdClass();
        $log->id = $id;
        $log->type = $type;
        $log->severity = $severity;
        $log->date = $date;
        $log->message = $message;
        array_push($logs,$log);
    }
    echo  json_encode($logs);
    $stmt->close();
    $conn->close();


?>