function load_epg($id = 0)
{
global $db;
$epg = '';
if (!$id) {
return;
}
if (@$_GET['yy'] && @$_GET['mm'] && @$_GET['dd']) {
$time = mktime(0, 0, 0, $_GET['mm'], $_GET['dd'], $_GET['yy']);
} else {
$time = time();
}
$year = date("Y", $time);
$month = date("m", $time);
$day = date("d", $time);
$time_from = $year . '-' . $month . '-' . $day . ' 00:00:00';
$time_to = $year . '-' . $month . '-' . $day . ' 24:00:00';
$sql = "select * from epg where ch_id=" . $id . " and time > '" . $time_from . "' and time < '" . $time_to . "' order by time";
//echo $sql;
$rs = $db->executeQuery($sql);
$epg = '';
while (@$rs->next()) {
$arr = $rs->getCurrentValuesAsHash();
$epg .= time_mysql2epg($arr['time']) . " " . $arr['name'] . "\n";
}
return $epg;
}
function load_epg($id = 0)
{
$epg = '';
if (!$id) {
return null;
}
if (@$_GET['yy'] && @$_GET['mm'] && @$_GET['dd']) {
$time = mktime(0, 0, 0, $_GET['mm'], $_GET['dd'], $_GET['yy']);
} else {
$time = time();
}
$year = date("Y", $time);
$month = date("m", $time);
$day = date("d", $time);
$time_from = $year . '-' . $month . '-' . $day . ' 00:00:00';
$time_to = $year . '-' . $month . '-' . $day . ' 23:59:59';
$programs = Mysql::getInstance()->from('epg')->where(array('ch_id' => $id, 'time>=' => $time_from, 'time<=' => $time_to))->orderby('time')->get()->all();
foreach ($programs as $arr) {
$epg .= time_mysql2epg($arr['time']) . " " . $arr['name'] . "\n";
}
return $epg;
}
