fixed: mysql_connect before mysql_real_escape_string

diff --git a/programTable.php b/programTable.php
index d5633c4..fe0555b 100755 (executable)
--- a/programTable.php
+++ b/programTable.php
@@ -11,7 +11,10 @@ $type = "*";
 $category_id = 0;
 $station = 0;
 
+// mysql_real_escape_stringより先に接続しておく必要がある
+$dbh = @mysql_connect(DB_HOST, DB_USER, DB_PASS );
 
+       // パラメータの処理
 if(isset( $_POST['do_search'] )) {
        if( isset($_POST['search'])){
                if( $_POST['search'] != "" ) {
@@ -44,14 +47,13 @@ if(isset( $_POST['do_search'] )) {
                }
        }
 }
-
 $options .= " ORDER BY starttime ASC LIMIT 300";
-
 $do_keyword = 0;
 if( ($search != "") || ($type != "*") || ($category_id != 0) || ($station != 0) )
        $do_keyword = 1;
-
+       
 try{
+       
        $precs = DBRecord::createRecords(TBL_PREFIX.PROGRAM_TBL, $options );
        
        $programs = array();

diff --git a/recordedTable.php b/recordedTable.php
index fc48d62..3f8c7bb 100755 (executable)
--- a/recordedTable.php
+++ b/recordedTable.php
@@ -8,6 +8,9 @@ $search = "";
 $category_id = 0;
 $station = 0;
 
+// mysql_real_escape_stringより先に接続しておく必要がある
+$dbh = @mysql_connect( DB_HOST, DB_USER, DB_PASS );
+
 #$options = "WHERE complete='1'";
 $options = "WHERE starttime < '". date("Y-m-d H:i:s")."'";     // ながら再生は無理っぽい？