Mercurial > epgrec.yaz

comparison recordedTable.php @ 61:87ded65fa485

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
add: keyword link
author yoneda <yoneda@recorder.localnet.mda.or.jp>
date Sun, 02 Aug 2009 12:23:37 +0900
parents 8965ef108821
children 4bd07b03c694
comparison
equal deleted inserted replaced
60:01079b81f125 61:87ded65fa485
13 $station = 0; 13 $station = 0;
14 14
15 // mysql_real_escape_stringより先に接続しておく必要がある 15 // mysql_real_escape_stringより先に接続しておく必要がある
16 $dbh = @mysql_connect( $settings->db_host, $settings->db_user, $settings->db_pass ); 16 $dbh = @mysql_connect( $settings->db_host, $settings->db_user, $settings->db_pass );
17 17
18 #$options = "WHERE complete='1'"; 18 // $options = "WHERE complete='1'";
19 $options = "WHERE starttime < '". date("Y-m-d H:i:s")."'"; // ながら再生は無理っぽい？ 19 $options = "WHERE starttime < '". date("Y-m-d H:i:s")."'"; // ながら再生は無理っぽい？
20
21 if(isset( $_GET['key']) ) {
22 $options .= " AND autorec ='".mysql_real_escape_string(trim($_GET['key']))."'";
23 }
20 24
21 if(isset( $_POST['do_search'] )) { 25 if(isset( $_POST['do_search'] )) {
22 if( isset($_POST['search'])){ 26 if( isset($_POST['search'])){
23 if( $_POST['search'] != "" ) { 27 if( $_POST['search'] != "" ) {
24 $search = $_POST['search']; 28 $search = $_POST['search'];