<?PHP
$servername = "156.17.130.204"; //replace it with your database server name
$username = "root";  //replace it with your database username
$password = "lato-2016!212";  //replace it with your database password
$dbname = "zpi";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
$conn->set_charset('utf8');
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
$query = "SELECT g.*, p.source zdjecie, a.* FROM gallery g
INNER JOIN address a ON g.AddressId=a.id
INNER JOIN picture p ON g.PhotoId=p.id
WHERE g.status > 1
";


    $result = mysqli_query($conn, $query);



    while($row = mysqli_fetch_assoc($result))
    {

       $data[] = $row;


    }
$query2 = "SELECT e.*,g.name test,p.source test2,pe.PhotoId
FROM event e INNER JOIN gallery g ON e.GalleryID=g.id
LEFT JOIN picture_event pe ON e.id=pe.EventId
LEFT JOIN picture p ON pe.PhotoId=p.id
WHERE g.status > 1";


    $result2 = mysqli_query($conn, $query2);



    while($row2 = mysqli_fetch_assoc($result2))
    {
       $data2[] = $row2;
    }
$query3 = "SELECT e.*,g.name gname,g.id gid,a.street gstreet,a.houseNumber ghouse,p2.source gphoto, p.source test2,p3.source test3,pe.PhotoId
FROM eventhistory e INNER JOIN gallery g ON e.GalleryID=g.id
INNER JOIN address a ON g.AddressId=a.id
INNER JOIN picture p2 ON g.PhotoId=p2.id
LEFT JOIN picture_eventhistory peh ON e.id=peh.EventHistory
LEFT JOIN picture p3 ON peh.PhotoId=p3.id
LEFT JOIN photorelation pe ON e.id=pe.EventHistoryId
LEFT JOIN picture p ON pe.PhotoId=p.id
WHERE g.status > 1 ";


    $result3 = mysqli_query($conn, $query3);



    while($row3 = mysqli_fetch_assoc($result3))
    {
       $data3[] = $row3;
    }
$query4 = "SELECT e.*,g.name gname,g.id gid,a.street gstreet,a.houseNumber ghouse,p2.source gphoto,v.link tescik,p3.source test3
FROM eventhistory e INNER JOIN gallery g ON e.GalleryID=g.id
INNER JOIN address a ON g.AddressId=a.id
INNER JOIN picture p2 ON g.PhotoId=p2.id
INNER JOIN videorelation vr ON vr.EventHistoryId=e.id
INNER JOIN video  v ON vr.VideoId=v.id
LEFT JOIN picture_eventhistory peh ON e.id=peh.EventHistory
LEFT JOIN picture p3 ON peh.PhotoId=p3.id
WHERE g.status > 1";

    $result4 = mysqli_query($conn, $query4);



    while($row4 = mysqli_fetch_assoc($result4))
    {
       $data4[] = $row4;
    }


$res1[]="qafka";
$res2[]="qaska";
$res10[]="qalka";
$result4 = array_merge($data, $res1);
$res=array_merge($result4,$data2);
$res3=array_merge($res,$res2);
$res4=array_merge($res3,$data3);
$res5=array_merge($res4,$res10);
$res6=array_merge($res5,$data4);
header('Content-Type: application/json; Charset=UTF-8');
 echo (json_encode($res6,JSON_UNESCAPED_UNICODE));
?>