if ($sid == "") { die_exit("局がありません<BR>"); } $now = date("YmdHi"); ?> <body BGCOLOR="#ffffff" TEXT="#494949" LINK="#0047ff" VLINK="#000000" ALINK="#c6edff" > <?php printhtmlpageheader(); //タイトル取得 $query = "\nSELECT \nfoltia_program.tid,\nstationname,\nfoltia_program .title ,\nfoltia_tvrecord.bitrate ,\nfoltia_tvrecord.stationid \nFROM foltia_tvrecord , foltia_program , foltia_station \nWHERE foltia_tvrecord.tid = foltia_program.tid AND foltia_tvrecord.stationid = foltia_station .stationid AND foltia_tvrecord.tid = ? AND foltia_tvrecord.stationid = ? "; // $rs = m_query($con, $query, "DBクエリに失敗しました"); $rs = sql_query($con, $query, "DBクエリに失敗しました", array($tid, $sid)); $rowdata = $rs->fetch(); if (!$rowdata) { die_exit("登録番組がありません<BR>"); } $tid = htmlspecialchars($rowdata[0]); $stationname = htmlspecialchars($rowdata[1]); $title = htmlspecialchars($rowdata[2]); $bitrate = htmlspecialchars($rowdata[3]); $stationid = htmlspecialchars($rowdata[4]); $delflag = getgetnumform(delflag); ?> <p align="left"><font color="#494949" size="6">予約解除</font></p> <hr size="4"> <?php if ($delflag == "1") { print "「" . $title . "」の自動録画予約を解除しました。 <br>\n"; //削除処理
function sql_query($dbh, $query, $errmessage, $paramarray = null) { try { $rtn = $dbh->prepare("{$query}"); $rtn->execute($paramarray); return $rtn; } catch (PDOException $e) { /* エラーメッセージに SQL 文を出すのはセキュリティ上良くない!! */ $msg = $errmessage . "<br>\n" . $e->getMessage() . "<br>\n" . var_export($e->errorInfo, true) . "<br>\n" . "<small><code>" . htmlspecialchars($query) . "</code></small>\n"; //$dbh->rollBack(); $dbh = null; die_exit($msg); } }
$p = getgetnumform(p); // ページ取得の計算 list($st, $p, $p2) = number_page($p, $lim); /////////////////////////////////////////////////////////// $now = date("YmdHi"); $query = "\n\tSELECT \n\t foltia_program.tid,\n\t foltia_program.title,\n foltia_tvrecord.tid AS rec\n\tFROM foltia_program \n LEFT JOIN foltia_tvrecord ON foltia_tvrecord.tid = foltia_program.tid\n\tGROUP BY foltia_program.tid\n\tORDER BY foltia_program.tid DESC\n\tLIMIT {$lim} OFFSET {$st}\n"; $rs = sql_query($con, $query, "DBクエリに失敗しました"); $rowdata = $rs->fetch(); if (!$rowdata) { die_exit("番組データがありません<BR>"); } $query2 = "\n\tSELECT COUNT(*) AS cnt FROM foltia_program \n"; $rs2 = sql_query($con, $query2, "DBクエリに失敗しました"); $rowdata2 = $rs2->fetch(); if (!$rowdata2) { die_exit("番組データがありません<BR>"); } // 行数取得 $dtcnt = $rowdata2[0]; ?> <body BGCOLOR="#ffffff" TEXT="#494949" LINK="#0047ff" VLINK="#000000" ALINK="#c6edff" > <div align="center"> <?php printhtmlpageheader(); ?> <p align="left"><font color="#494949" size="6">番組一覧</font></p> <hr size="4"> <p align="left">全番組リストを表示します。</p>
//新仕様 $query = "\n SELECT \n foltia_program.tid,\n foltia_program.title,\n foltia_subtitle.countno,\n foltia_subtitle.subtitle,\n foltia_m2pfiles.m2pfilename,\n foltia_subtitle.pid,\n foltia_subtitle.pspfilename\n FROM foltia_subtitle, foltia_program, foltia_m2pfiles \n WHERE foltia_program.tid = foltia_subtitle.tid \n AND foltia_subtitle.m2pfilename = foltia_m2pfiles.m2pfilename \n ORDER BY foltia_subtitle.tid DESC, foltia_subtitle.startdatetime ASC \n LIMIT {$lim} OFFSET {$st}\n \n "; } else { $query = "\n SELECT \n foltia_program.tid,\n foltia_program.title,\n foltia_subtitle.countno,\n foltia_subtitle.subtitle,\n foltia_m2pfiles.m2pfilename,\n foltia_subtitle.pid,\n foltia_subtitle.pspfilename,\n foltia_subtitle.lengthmin\n FROM foltia_subtitle, foltia_program, foltia_m2pfiles \n WHERE foltia_program.tid = foltia_subtitle.tid \n AND foltia_subtitle.m2pfilename = foltia_m2pfiles.m2pfilename \n ORDER BY foltia_subtitle.startdatetime DESC \n LIMIT {$lim} OFFSET {$st}\n "; } } } $rs = sql_query($con, $query, "DBクエリに失敗しました"); $rowdata = $rs->fetch(); ///////////////////////////////////////// //テーブルの総数取得 $query2 = "\n SELECT COUNT(*) AS cnt FROM foltia_subtitle , foltia_program , foltia_m2pfiles\n WHERE foltia_program.tid = foltia_subtitle.tid\n AND foltia_subtitle.m2pfilename = foltia_m2pfiles.m2pfilename\n"; $rs2 = sql_query($con, $query2, "DBクエリに失敗しました"); $rowdata2 = $rs2->fetch(PDO::FETCH_ASSOC); if (!$rowdata2) { die_exit("番組データがありません<br>"); } $dtcnt = $rowdata2['cnt']; //クエリ代入 $query_st = $list; page_display($query_st, $p, $p2, $lim, $dtcnt, ""); ///////////////////////////////////////// if ($rowdata) { do { $tid = htmlspecialchars($rowdata[0]); $title = htmlspecialchars($rowdata[1]); $count = htmlspecialchars($rowdata[2]); $subtitle = htmlspecialchars($rowdata[3]); $fName = htmlspecialchars($rowdata[4]); $pid = htmlspecialchars($rowdata[5]); $mp4filename = htmlspecialchars($rowdata[6]);
$startdatetime = getnumform(startdatetime); $enddatetime = getnumform(enddatetime); $lengthmin = getnumform(lengthmin); */ $epgid = getnumform(epgid); if ($epgid == "") { print "\t<title>foltia:EPG予約:Error</title></head>\n"; die_exit("登録番組がありません<BR>"); } print "\t<title>foltia:EPG予約:完了</title>\n</head>\n"; $now = date("YmdHi"); //タイトル取得 $query = "\n\tSELECT epgid,startdatetime,enddatetime,lengthmin, ontvchannel,epgtitle,epgdesc,epgcategory , \n\tstationname , stationrecch ,stationid \n\tFROM foltia_epg , foltia_station \n\tWHERE epgid = ? AND foltia_station.ontvcode = foltia_epg.ontvchannel\n\t"; $rs = sql_query($con, $query, "DBクエリに失敗しました", array($epgid)); $rowdata = $rs->fetch(); if (!$rowdata) { die_exit("登録番組がありません。もう一度EPGに戻り操作して下さい。<BR>"); } else { $stationid = $rowdata[10]; $subtitle = $rowdata[5] . $rowdata[6]; $startdatetime = $rowdata[1]; $enddatetime = $rowdata[2]; $lengthmin = $rowdata[3]; } // - DB登録作業 //時刻検査 if ($startdatetime > $now && $enddatetime > $now && $enddatetime > $startdatetime) { //min pidを探す $query = "SELECT min(pid) FROM foltia_subtitle "; // $rs = m_query($con, $query, "DBクエリに失敗しました"); $rs = sql_query($con, $query, "DBクエリに失敗しました"); $rowdata = $rs->fetch();
} //end if login ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <html lang="ja"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <meta http-equiv="Content-Style-Type" content="text/css"> <link rel="stylesheet" type="text/css" href="graytable.css"> <title>foltia</title> </head> <?php $tid = getgetnumform(tid); if ($tid == "") { die_exit("番組が指定されていません<BR>"); } $station = getgetnumform(station); if ($station == "") { $station = 0; } $usedigital = getgetnumform(usedigital); if ($usedigital == "") { $usedigital = 0; } $bitrate = getgetnumform(bitrate); if ($bitrate == "") { $bitrate = 5; } $now = date("YmdHi"); //タイトル取得