die_exit PHP 코드 예제들

예제 #1

0

파일 보기

파일: delreserve.php 프로젝트: haru8/foltia

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";
    //削除処理

예제 #2

0

파일 보기

파일: foltialib.php 프로젝트: haru8/foltia

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);
    }
}

예제 #3

0

파일 보기

파일: titlelist.php 프로젝트: haru8/foltia

$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>

예제 #4

0

파일 보기

파일: showplaylist.php 프로젝트: haru8/foltia

            //新仕様
            $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]);

예제 #5

0

파일 보기

파일: reserveepgcomp.php 프로젝트: haru8/foltia

$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();

예제 #6

0

파일 보기

파일: reservecomp.php 프로젝트: haru8/foltia

}
//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");
//タイトル取得

PHP die_exit 예제들