getgetnumform PHP代码示例

示例#1

0

显示文件

文件： delreserve.php 项目： haru8/foltia

<?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";
    //削除処理
    if ($demomode || $protectmode) {
        //demomodeやprotectmodeならなにもしない
    } else {
        //キュー削除プログラムをキック
        $oserr = system("{$toolpath}/perl/addatq.pl {$tid} {$sid} DELETE");
        //DB削除
        $query = "\nDELETE  \nFROM  foltia_tvrecord  \nWHERE foltia_tvrecord.tid = ? AND foltia_tvrecord.stationid = ?  ";

示例#2

0

显示文件

文件： titlelist.php 项目： haru8/foltia

?>
<!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 
//////////////////////////////////////////////////////////
// 1ページの表示レコード数
$lim = 1000;
// クエリ取得
$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>");

示例#3

0

显示文件

文件： mp4player.php 项目： haru8/foltia

 DCC-JPL Japan/foltia project
*/
include "./foltialib.php";
$con = m_connect();
if ($useenvironmentpolicy == 1) {
    if (!isset($_SERVER['PHP_AUTH_USER'])) {
        header("WWW-Authenticate: Basic realm=\"foltia\"");
        header("HTTP/1.0 401 Unauthorized");
        redirectlogin();
        exit;
    } else {
        login($con, $_SERVER['PHP_AUTH_USER'], $_SERVER['PHP_AUTH_PW']);
    }
}
//end if login
$pid = getgetnumform(p);
$file = getgetform(f);
if ($pid != "") {
    $query = "\nSELECT \n  title,\n  countno,\n  subtitle,\n  foltia_subtitle.tid,\n  PSPfilename  \nFROM foltia_subtitle, foltia_program \nWHERE pid = ? AND foltia_subtitle.tid = foltia_program.tid";
    $rs = sql_query($con, $query, "DBクエリに失敗しました", array($pid));
    $rowdata = $rs->fetch();
    //$title = htmlspecialchars(mb_convert_encoding($rowdata[0], "UTF-8"));
    $title = htmlspecialchars($rowdata[0]);
    if ($rowdata[1] == "") {
        $countno = "";
    } else {
        $countno = "第" . htmlspecialchars($rowdata[1]) . "話";
    }
    //$subtitle = htmlspecialchars(mb_convert_encoding($rowdata[2], "UTF-8"));
    $subtitle = htmlspecialchars($rowdata[2]);
    $tid = htmlspecialchars($rowdata[3]);

示例#4

0

显示文件

文件： viewepg.php 项目： haru8/foltia

$day7 = date("m/d(D)", mktime($starthour, 0, 0, $beginmonth, $beginday + 7, $beginyear));
$day7 = weekDaysRep($day7);
///////////////////////////////////////////////////////////////////
// 表示局選定
// $page = 1
$maxdisplay = getgetnumform("st");
if (!ctype_digit($maxdisplay)) {
    $maxdisplay = 8;
}
$query = "SELECT count(*) FROM foltia_station WHERE \"ontvcode\" LIKE '%ontvjapan%'";
$rs = sql_query($con, $query, "DBクエリに失敗しました");
$maxrows = $rs->fetchColumn(0);
if ($maxrows > $maxdisplay) {
    $pages = ceil($maxrows / $maxdisplay);
}
$page = getgetnumform("p");
if ($page == "" || $page <= 0) {
    $page = 1;
    $offset = 0;
} else {
    $page = ereg_replace("[^0-9]", "", $page);
    if ($page > $pages) {
        $page = $pages;
    } elseif ($page <= 0) {
        $page = 1;
    }
    $offset = $page * $maxdisplay - $maxdisplay;
}
/////////////////////////////////////////////////////////////////
//表示部分
$navigationbar = "\n\n[<A HREF=\"./viewepg.php\">現在</A>] |\n<A HREF=\"./viewepg.php?p={$page}&start={$yesterday}\">{$dayyesterday} [前日]</A> |\n当日(\n<A HREF=\"./viewepg.php?p={$page}&st={$maxdisplay}&start={$today0400}&e={$endh}\">4:00</A>　\n<A HREF=\"./viewepg.php?p={$page}&st={$maxdisplay}&start={$today0800}&e={$endh}\">8:00</A>　\n<A HREF=\"./viewepg.php?p={$page}&st={$maxdisplay}&start={$today1200}&e={$endh}\">12:00</A>　\n<A HREF=\"./viewepg.php?p={$page}&st={$maxdisplay}&start={$today1600}&e={$endh}\">16:00</A>　\n<A HREF=\"./viewepg.php?p={$page}&st={$maxdisplay}&start={$today2000}&e={$endh}\">20:00</A>　\n<A HREF=\"./viewepg.php?p={$page}&st={$maxdisplay}&start={$today2359}&e={$endh}\">24:00</A>) |\n<A HREF=\"./viewepg.php?p={$page}&st={$maxdisplay}&start={$tomorrow}&e={$endh}\">{$daytomorrow} [翌日]</A>\n<br>\n |\n<A HREF=\"./viewepg.php?p={$page}&st={$maxdisplay}&start={$day0after}&e={$endh}\">{$day0}</A> |\n<A HREF=\"./viewepg.php?p={$page}&st={$maxdisplay}&start={$day1after}&e={$endh}\">{$day1}</A> |\n<A HREF=\"./viewepg.php?p={$page}&st={$maxdisplay}&start={$day2after}&e={$endh}\">{$day2}</A> |\n<A HREF=\"./viewepg.php?p={$page}&st={$maxdisplay}&start={$day3after}&e={$endh}\">{$day3}</A> |\n<A HREF=\"./viewepg.php?p={$page}&st={$maxdisplay}&start={$day4after}&e={$endh}\">{$day4}</A> |\n<A HREF=\"./viewepg.php?p={$page}&st={$maxdisplay}&start={$day5after}&e={$endh}\">{$day5}</A> |\n<A HREF=\"./viewepg.php?p={$page}&st={$maxdisplay}&start={$day6after}&e={$endh}\">{$day6}</A> |\n<A HREF=\"./viewepg.php?p={$page}&st={$maxdisplay}&start={$day7after}&e={$endh}\">{$day7}</A> | <BR>\n";

示例#5

0

显示文件

文件： reserveepg.php 项目： haru8/foltia

        exit;
    } else {
        login($con, $_SERVER['PHP_AUTH_USER'], $_SERVER['PHP_AUTH_PW']);
    }
}
//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">

<?php 
$epgid = getgetnumform(epgid);
if ($epgid == "") {
    print "\t<title>foltia:EPG予約:Error</title></head>\n";
    die_exit("登録番組がありません<BR>");
}
print "\t<title>foltia:EPG予約:{$epgid}</title>\n</head>\n";
$now = date("YmdHi");
// タイトル取得
$query = "\n  SELECT\n    epgid,\n    startdatetime,\n    enddatetime,\n    lengthmin,\n    ontvchannel,\n    epgtitle,\n    epgdesc,\n    epgcategory,\n    stationname,\n    stationrecch,\n    stationid\n  FROM\n    foltia_epg,\n    foltia_station\n  WHERE epgid = ?\n    AND foltia_station.ontvcode = foltia_epg.ontvchannel\n";
// 4812
$rs = sql_query($con, $query, "DBクエリに失敗しました", array($epgid));
$rowdata = $rs->fetch();
if (!$rowdata) {
    die_exit("登録番組がありません<BR>");
}
?>

示例#6

0

显示文件

文件： view_syabas.php 项目： haru8/foltia

http://www.geocities.co.jp/SiliconValley-Cupertino/2647/tec.html
*/
include "./foltialib.php";
$con = m_connect();
if ($useenvironmentpolicy == 1) {
    if (!isset($_SERVER['PHP_AUTH_USER'])) {
        header("WWW-Authenticate: Basic realm=\"foltia\"");
        header("HTTP/1.0 401 Unauthorized");
        redirectlogin();
        exit;
    } else {
        login($con, $_SERVER['PHP_AUTH_USER'], $_SERVER['PHP_AUTH_PW']);
    }
}
//end if login
$pid = getgetnumform(pid);
if ($pid == "") {
    exit;
}
$query = "\nSELECT \nfoltia_program.tid,\nstationname,\nfoltia_program.title,\nfoltia_subtitle.countno,\nfoltia_subtitle.subtitle,\nfoltia_subtitle.startdatetime ,\nfoltia_subtitle.lengthmin  , \nfoltia_subtitle.pid ,\nfoltia_subtitle.m2pfilename , \nfoltia_subtitle.pspfilename \nFROM foltia_subtitle , foltia_program ,foltia_station  \nWHERE foltia_program.tid = foltia_subtitle.tid AND foltia_station.stationid = foltia_subtitle.stationid \n AND foltia_subtitle.pid = ? ";
//	$rs = m_query($con, $query, "DBクエリに失敗しました");
$rs = sql_query($con, $query, "DBクエリに失敗しました", array($pid));
$rowdata = $rs->fetch();
if (!$rowdata) {
    print "";
    exit;
} else {
    $title = $rowdata[2];
    $episode = $rowdata[3];
    $subtitle = $rowdata[4];
    $m2pfilename = $rowdata[8];

示例#7

0

显示文件

文件： listreserve.php 项目： haru8/foltia

}
if ($now > 200501010000.0) {
} else {
    $now = date("YmdHi");
}
$query = "\n\tSELECT\n\t  foltia_program.tid,\n\t  stationname,\n\t  foltia_program.title,\n\t  foltia_subtitle.countno,\n\t  foltia_subtitle.subtitle,\n\t  foltia_subtitle.startdatetime as x,\n\t  foltia_subtitle.lengthmin,\n\t  foltia_tvrecord.bitrate,\n\t  foltia_subtitle.startoffset,\n\t  foltia_subtitle.pid,\n\t  foltia_subtitle.epgaddedby,\n\t  foltia_tvrecord.digital\n\tFROM\n\t  foltia_subtitle,\n\t  foltia_program,\n\t  foltia_station,\n\t  foltia_tvrecord\n\tWHERE foltia_tvrecord.tid         = foltia_program.tid\n\t  AND foltia_tvrecord.stationid   = foltia_station.stationid\n\t  AND foltia_program.tid          = foltia_subtitle.tid\n\t  AND foltia_station.stationid    = foltia_subtitle.stationid\n\t  AND foltia_subtitle.enddatetime >= ?\n\t  UNION\n\t  SELECT\n\t    foltia_program.tid,\n\t    stationname,\n\t    foltia_program.title,\n\t    foltia_subtitle.countno,\n\t    foltia_subtitle.subtitle,\n\t    foltia_subtitle.startdatetime,\n\t    foltia_subtitle.lengthmin,\n\t    foltia_tvrecord.bitrate,\n\t    foltia_subtitle.startoffset,\n\t    foltia_subtitle.pid,\n\t    foltia_subtitle.epgaddedby,\n\t    foltia_tvrecord.digital\n\t  FROM\n\t    foltia_tvrecord\n\t    LEFT OUTER JOIN foltia_subtitle ON (foltia_tvrecord.tid = foltia_subtitle.tid )\n\t    LEFT OUTER JOIN foltia_program  ON (foltia_tvrecord.tid = foltia_program.tid )\n\t    LEFT OUTER JOIN foltia_station  ON (foltia_subtitle.stationid = foltia_station.stationid )\n\t  WHERE foltia_tvrecord.stationid   = 0\n\t    AND foltia_subtitle.enddatetime >= ? ORDER BY x ASC\n";
$rs = sql_query($con, $query, "DBクエリに失敗しました", array($now, $now));
//チューナー数
if (getgetnumform('r') != "") {
    $recunits = getgetnumform('r');
} elseif ($recunits == "") {
    $recunits = 4;
}
$overlapCheck = false;
if (getgetnumform('o') != "") {
    $overlapCheck = getgetnumform('o');
    if ($overlapCheck == 1) {
        $overlapCheck = true;
    } else {
        $overlapCheck = false;
    }
}
?>

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

示例#8

0

显示文件

文件： m.php 项目： haru8/foltia

<p align="left">
  <font color="#494949" size="6">
    番組手動予約
  </font>
</p>
<hr size="4">
<?php 
//値取得
$startdate = getgetnumform(startdate);
$starttime = getgetnumform(starttime);
if ($startdate == "" || $starttime == "") {
    print "<p align=\"left\">全項目手動指定で予約します。</p>\n";
} else {
    $lengthmin = getgetnumform(lengthmin);
    $recstid = getgetnumform(recstid);
    $pname = getgetform(pname);
    //$usedigital = getgetnumform(usedigital);
    // 確認
    $startdatetime = "{$startdate}" . "{$starttime}";
    if (foldatevalidation($startdatetime)) {
        //print "valid";
    } else {
        $errflag = 1;
        $errmsg = "日付が不正です。";
    }
    if ($lengthmin < 361) {
        //valid
    } else {
        $errflag = 2;
        $errmsg = "録画時間は360分で区切ってください。";

示例#9

0

显示文件

文件： folcast.php 项目： haru8/foltia

		redirectlogin();
	    exit;
	} else {
	login($con,$_SERVER['PHP_AUTH_USER'],$_SERVER['PHP_AUTH_PW']);
	}
}//end if login
*/
$now = date("YmdHi");
$nowrfc822 = date("r");
$max = getgetnumform(max);
if ($max > 0) {
    //件数指定があればなにもしない
} else {
    $max = 45;
}
$tid = getgetnumform(tid);
if ($tid >= 0 && $tid != "") {
    $query = "\nSELECT  foltia_program.tid,foltia_program.title,\nfoltia_subtitle.countno , foltia_subtitle.subtitle , foltia_subtitle.startdatetime, foltia_subtitle.pspfilename,foltia_subtitle.lengthmin,foltia_subtitle.enddatetime   FROM foltia_subtitle , foltia_program   WHERE \"pspfilename\" LIKE 'M%%'  AND foltia_program.tid = foltia_subtitle.tid AND foltia_program.tid = {$tid}   \nORDER BY enddatetime DESC \n limit ? offset 0 \n";
    $titlequery = "\nSELECT  foltia_program.tid,foltia_program.title \nFROM  foltia_program   \nWHERE foltia_program.tid = ?   \n";
    //	$titlers = m_query($con, $query, "DBクエリに失敗しました");
    $titlers = sql_query($con, $query, "DBクエリに失敗しました", array($tid));
    //	$titlers = sql_query($con, $titlequery, "DBクエリに失敗しました",array($tid));
    $rowdata = $titlers->fetch();
    $rsstitle = htmlspecialchars($rowdata[1]);
} else {
    $query = "\nSELECT  foltia_program.tid,foltia_program.title,\nfoltia_subtitle.countno , foltia_subtitle.subtitle , foltia_subtitle.startdatetime, foltia_subtitle.pspfilename,foltia_subtitle.lengthmin,foltia_subtitle.enddatetime   FROM foltia_subtitle , foltia_program   WHERE \"pspfilename\" LIKE 'M%%'  AND foltia_program.tid = foltia_subtitle.tid ORDER BY enddatetime DESC \nlimit  ? offset 0 \n\t";
    $rsstitle = "新規録画";
}
//if
$header = "<?xml version=\"1.0\" encoding=\"UTF-8\"?> \n<rss xmlns:itunes=\"http://www.itunes.com/DTDs/Podcast-1.0.dtd\" version=\"2.0\"> \n    <channel> \n        <title>{$rsstitle}:Folcast</title> \n        <itunes:author>DCC-JPL Japan/foltia project</itunes:author> \n        <link>http://www.dcc-jpl.com/soft/foltia/</link> \n        <description>フォルティアが未読処理をお助けしちゃいます</description> \n        <itunes:subtitle>foltia video podcast :{$rsstitle}:Folcast</itunes:subtitle> \n        <itunes:summary>フォルティアが未読処理をお助けしちゃいます</itunes:summary> \n\t\t<language>ja</language>\n        <copyright>foltia</copyright> \n        <itunes:owner> \n            <itunes:name>{$rsstitle}:Folcast</itunes:name> \n            <itunes:email>foltia@dcc-jpl.com</itunes:email> \n        </itunes:owner>          \n        <category>Technology</category> \n        <itunes:category text=\"Technology\"></itunes:category> \n\n";
$header = mb_convert_encoding($header, "UTF-8");

示例#10

0

显示文件

文件： reservecomp.php 项目： haru8/foltia

</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");
//タイトル取得
$query = "select title from foltia_program where tid = ? ";
//	$rs = m_query($con, $query, "DBクエリに失敗しました");
$rs = sql_query($con, $query, "DBクエリに失敗しました", array($tid));
$rowdata = $rs->fetch();
if (!$rowdata) {
    $title = "(未登録)";
} else {
    $title = htmlspecialchars($rowdata[0]);
}
?>

PHP getgetnumform示例