52 lines
1.3 KiB
PHP
52 lines
1.3 KiB
PHP
<?php
|
|
header('Content-Type: application/json');
|
|
require("../../inc/connect.php");
|
|
require("../session.php");
|
|
|
|
$session = $_GET['session'];
|
|
|
|
if($session == "")
|
|
{
|
|
echo '{"error":"No session"}';
|
|
exit;
|
|
}
|
|
|
|
//check session
|
|
verify_session($mysqli, $session);
|
|
|
|
//Check devices
|
|
$sql = "SELECT schedule.id AS `id`, schedule.name AS `name`, schedule.time AS `time`, schedule.duration AS `duration`, stream.name AS `stream` FROM `schedule`, `session`, `stream` WHERE schedule.stream = stream.id AND schedule.dev_id = session.dev_id AND `session`='$session'";
|
|
$query = ExecQuery($mysqli, $sql);
|
|
|
|
if($query->num_rows < 1)
|
|
{
|
|
echo '{"error":"No schedules found"}';
|
|
exit;
|
|
}
|
|
|
|
$str = '{"succes":true, "device":"' . $device . '", "schedules":[';
|
|
|
|
$count = 1;
|
|
|
|
while($result = $query->fetch_assoc())
|
|
{
|
|
$str .= '{"id":' . $result['id'] . ',';
|
|
$str .= '"name":"' . $result['name'] . '",';
|
|
$str .= '"time":"' . $result['time'] . '",';
|
|
$str .= '"duration":"' . $result['duration'] . '",';
|
|
$str .= '"stream":"' . $result['stream'] . '"';
|
|
|
|
if($count == $query->num_rows)
|
|
$str .= '}';
|
|
else
|
|
$str .= '},';
|
|
|
|
$count++;
|
|
}
|
|
|
|
$str .= ']}';
|
|
|
|
echo $str;
|
|
|
|
|
|
?>
|