Mercurial > epgrec.yaz
view recordedTable.php @ 93:80cc05b420af
fix: $*_CHANNEL_MAPに存在しないチャンネルの番組を取得する際のエラーを修正
author | epgrec@park.mda.or.jp <yoneda@recorder.localnet.mda.or.jp> |
---|---|
date | Tue, 02 Mar 2010 23:21:17 +0900 |
parents | 87ded65fa485 |
children | 4bd07b03c694 |
line wrap: on
line source
<?php include_once('config.php'); include_once( INSTALL_PATH . '/DBRecord.class.php' ); include_once( INSTALL_PATH . '/Smarty/Smarty.class.php' ); include_once( INSTALL_PATH . '/Settings.class.php' ); $settings = Settings::factory(); $order = ""; $search = ""; $category_id = 0; $station = 0; // mysql_real_escape_string・膓鏆荀 $dbh = @mysql_connect( $settings->db_host, $settings->db_user, $settings->db_pass ); // $options = "WHERE complete='1'"; $options = "WHERE starttime < '". date("Y-m-d H:i:s")."'"; // ∞c純鐚 if(isset( $_GET['key']) ) { $options .= " AND autorec ='".mysql_real_escape_string(trim($_GET['key']))."'"; } if(isset( $_POST['do_search'] )) { if( isset($_POST['search'])){ if( $_POST['search'] != "" ) { $search = $_POST['search']; $options .= " AND CONCAT(title,description) like '%".mysql_real_escape_string($_POST['search'])."%'"; } } if( isset($_POST['category_id'])) { if( $_POST['category_id'] != 0 ) { $category_id = $_POST['category_id']; $options .= " AND category_id = '".$_POST['category_id']."'"; } } if( isset($_POST['station'])) { if( $_POST['station'] != 0 ) { $station = $_POST['station']; $options .= " AND channel_id = '".$_POST['station']."'"; } } } $options .= " ORDER BY starttime DESC"; try{ $rvs = DBRecord::createRecords(RESERVE_TBL, $options ); $records = array(); foreach( $rvs as $r ) { $cat = new DBRecord(CATEGORY_TBL, "id", $r->category_id ); $ch = new DBRecord(CHANNEL_TBL, "id", $r->channel_id ); $arr = array(); $arr['id'] = $r->id; $arr['station_name'] = $ch->name; $arr['starttime'] = $r->starttime; $arr['endtime'] = $r->endtime; $arr['asf'] = "".$settings->install_url."/viewer.php?reserve_id=".$r->id; $arr['title'] = htmlspecialchars($r->title,ENT_QUOTES); $arr['description'] = htmlspecialchars($r->description,ENT_QUOTES); $arr['thumb'] = "<img src=\"".$settings->install_url.$settings->thumbs."/".$r->path.".jpg\" />"; $arr['cat'] = $cat->name_en; $arr['mode'] = $RECORD_MODE[$r->mode]['name']; array_push( $records, $arr ); } $crecs = DBRecord::createRecords(CATEGORY_TBL ); $cats = array(); $cats[0]['id'] = 0; $cats[0]['name'] = "鴻"; $cats[0]['selected'] = $category_id == 0 ? "selected" : ""; foreach( $crecs as $c ) { $arr = array(); $arr['id'] = $c->id; $arr['name'] = $c->name_jp; $arr['selected'] = $c->id == $category_id ? "selected" : ""; array_push( $cats, $arr ); } $crecs = DBRecord::createRecords(CHANNEL_TBL ); $stations = array(); $stations[0]['id'] = 0; $stations[0]['name'] = "鴻"; $stations[0]['selected'] = (! $station) ? "selected" : ""; foreach( $crecs as $c ) { $arr = array(); $arr['id'] = $c->id; $arr['name'] = $c->name; $arr['selected'] = $station == $c->id ? "selected" : ""; array_push( $stations, $arr ); } $smarty = new Smarty(); $smarty->assign("sitetitle","牙紙筝荀"); $smarty->assign( "records", $records ); $smarty->assign( "search", $search ); $smarty->assign( "stations", $stations ); $smarty->assign( "cats", $cats ); $smarty->assign( "use_thumbs", $settings->use_thumbs ); $smarty->display("recordedTable.html"); } catch( exception $e ) { exit( $e->getMessage() ); } ?>