[insert_php]
$db = mysqli_connect(‘localhost’,’prartoon_epg’,’?dtwAx[ZI[K0′,’prartoon_epg’)
or die(‘Hiba történt az adatbázishoz való kapcsolódáskor.’);
mysqli_set_charset($db,”utf8″);
$display = “”;
$day = “”;
$option = “”;
$title = “”; if (isset($_GET[‘channel’],$_GET[‘date’])) {
$option = $_GET[‘channel’];
$day = $_GET[‘date’];
$display = $country[$option];
$title = $option;
} else {
$title = “search”;
}
[/insert_php]
[insert_php]
$today = date_create();
$today = date(“Y-m-d”);
if($option == NULL)
echo ‘
‘;
[/insert_php] [insert_php]
$query_c = “SELECT * FROM channels WHERE ID = ” . “‘” . $option . “‘”;
mysqli_query($db, $query_c);
$result_c = mysqli_query($db, $query_c);
$row_c = mysqli_fetch_array($result_c); if ($option != NULL && $row_c[‘Ahu’] != 0)
{
echo ‘‘; $date_html = date(“Y-m-d”);
$date = “‘” . $date_html . “‘”;
$date_html = date(“Y-m-d”);
$ds = new DateTime($day);
$ds->sub(new DateInterval(‘PT1H’));
$ds->format(‘Y-m-d H:i’);
$ds=date_format($ds,”Y-m-d H:i”);
$de = new DateTime($day);
$de->add(new DateInterval(‘PT22H59M59S’));
$de->format(‘Y-m-d H:i’);
$de=date_format($de,”Y-m-d H:i”); echo ‘
‘; if ($row_c[‘Site’] != NULL) { echo ‘ ‘; } if ($row_c[‘Email’] != NULL) { echo ‘ ‘; } if ($row_c[‘Phone’] != NULL) { echo ‘ ‘; } if ($row_c[‘Facebook’] != NULL) { echo ‘ ‘; } if ($row_c[‘YouTube’] != NULL) { echo ‘ ‘; } if ($row_c[‘Instagram’] != NULL) { echo ‘ ‘; } echo ‘
‘; $dday = date_create($day); $dday = date_format($dday, ‘m/j/Y’); $dprev = new DateTime($day); $dprev->sub(new DateInterval(‘P1D’)); $dprev=date_format($dprev,”Y-m-d”); $dnext = new DateTime($day); $dnext->add(new DateInterval(‘P1D’)); $dnext=date_format($dnext,”Y-m-d”); echo ‘
‘; $query = “SELECT * FROM `epg` WHERE Channel=” . $option . ” AND TimeStart >= ‘” . $ds . “‘ AND TimeStart<='" . $de . "' ORDER BY `epg`.`TimeStart` ASC "; mysqli_query($db, $query); $result = mysqli_query($db, $query); while ($row = mysqli_fetch_array($result)) { if($row['TimeStart'] != NULL) { $dtwo = date_create($row['TimeStart']); $dtwo = date_format($dtwo, 'H:i'); } $dtwo = new DateTime($dtwo); $dtwo->add(new DateInterval(‘PT1H’)); $dtwo->format(‘Y-m-d H:i’); $dtwo=date_format($dtwo, “H:i”); $dday = date_create($day); $dday = date_format($dday, ‘m/j/Y’); $date_html = date(“m/j/Y”); echo ‘
‘; } else { echo ‘
ÁLTALÁNOS | |||
|---|---|---|---|
 |  |  |  |
HÍR | |||
 |  | ||
ÁLTALÁNOS SZÓRAKOZTATÓ ÉS SOROZAT | |||
 |  |  |  |
 |  |  |  |
 |  |  |  |
 |  |  |  |
 |  |  |  |
 |  |  |  |
 | |||
FILM | |||
 |  |  |  |
 |  |  |  |
 |  |  |  |
 |  |  |  |
 | |||
ISMERETTERJESZTŐ | |||
 |  |  |  |
 |  |  |  |
 |  |  |  |
 |  |  |  |
 |  |  |  |
 | |||
SPORT | |||
 |  |  |  |
 |  |  |  |
 |  |  |  |
 |  | ||
GYEREK | |||
 |  |  |  |
 |  |  |  |
 |  |  | |
ZENE | |||
 |  |  |  |
|  |  |  |
 |  |  |  |
 |  |  | |
ÉLETMÓD | |||
 |  |  |  |
 |  |  |  |
|  | ||
KÖZÖSSÉGI ÉS VALLÁSI | |||
 |  |  |  |
 |  | ||
KÜLFÖLDI | |||
 |  |  |  |
 |  |  |  |
 |  |  |  | FELNŐTT |
 |  |  | HELYI |
 |  |  |  |
 |  |  |  |
 | |||
‘ . $row_c[‘Name’] . ‘
‘; if ($row_c[‘Site’] != NULL) { echo ‘ ‘; } if ($row_c[‘Email’] != NULL) { echo ‘ ‘; } if ($row_c[‘Phone’] != NULL) { echo ‘ ‘; } if ($row_c[‘Facebook’] != NULL) { echo ‘ ‘; } if ($row_c[‘YouTube’] != NULL) { echo ‘ ‘; } if ($row_c[‘Instagram’] != NULL) { echo ‘ ‘; } echo ‘
‘ . $row_c[‘DescriptionHungarian’] .’
‘; setlocale(LC_ALL, ‘hu_HU’); echo ‘‘; $dday = date_create($day); $dday = date_format($dday, ‘m/j/Y’); $dprev = new DateTime($day); $dprev->sub(new DateInterval(‘P1D’)); $dprev=date_format($dprev,”Y-m-d”); $dnext = new DateTime($day); $dnext->add(new DateInterval(‘P1D’)); $dnext=date_format($dnext,”Y-m-d”); echo ‘
« ‘ . utf8_encode(strftime(“%Y. %B %e., %A”,strtotime($dday))) . ‘ »
‘; echo ‘‘; $query = “SELECT * FROM `epg` WHERE Channel=” . $option . ” AND TimeStart >= ‘” . $ds . “‘ AND TimeStart<='" . $de . "' ORDER BY `epg`.`TimeStart` ASC "; mysqli_query($db, $query); $result = mysqli_query($db, $query); while ($row = mysqli_fetch_array($result)) { if($row['TimeStart'] != NULL) { $dtwo = date_create($row['TimeStart']); $dtwo = date_format($dtwo, 'H:i'); } $dtwo = new DateTime($dtwo); $dtwo->add(new DateInterval(‘PT1H’)); $dtwo->format(‘Y-m-d H:i’); $dtwo=date_format($dtwo, “H:i”); $dday = date_create($day); $dday = date_format($dday, ‘m/j/Y’); $date_html = date(“m/j/Y”); echo ‘
‘ . ‘‘ . $dtwo . ‘‘ . ‘
‘ . ‘‘ . $row[‘Title’] . ‘ ‘; if($row[‘Live’] == 1)
echo ‘(élő) ‘; if($row[‘Rerun’] == 1)
echo ‘(ism.) ‘; if($row[‘ReAir’] == 1)
echo ‘(redifuzare) ‘; if($row[‘Age’] != NULL)
echo ‘(‘ . $row[‘Age’] . ‘) ‘; if($row[‘Premiere’] == 1)
echo ‘(PREMIER) ‘; if ($row[‘TitleOriginal’] != NULL || $row[‘Genre’] != NULL || $row[‘GenreTwo’] != NULL || $row[‘Synopsis’] != NULL || $row[‘Synopsis2’] != NULL || $row[‘SynopsisEPG’] != NULL || $row[‘Season’] != NULL || $row[‘Episode’] != NULL || $row[‘EpisodeTitle’] != NULL || $row[‘EpisodeTitleOriginal’] != NULL || $row[‘Year’] != 0 || $row[‘Country’] != NULL || $row[‘HD’] != 0 || $row[‘Director’] != NULL || $row[‘Cast’] != NULL || $row[‘Producer’] != NULL || $row[‘Presenter’] != NULL || $row[‘Subtitles’] != 0)
{
echo ‘
‘; } else { echo ‘
‘;
echo ‘