Changeset 17878 for branches/comu-ver2/data/class/SC_Query.php

Timestamp:

2009/03/06 20:35:20 (15 years ago)

Author:

Seasoft

Message:

・不適切な文字列比較を修正。(PEAR::DB のカスタマイズに依存させる。)

 http://xoops.ec-cube.net/modules/newbb/viewtopic.php?topic_id=1808&forum=9

File:

• branches/comu-ver2/data/class/SC_Query.php (modified) (4 diffs)

branches/comu-ver2/data/class/SC_Query.php

@@ -253 +253 @@
             } else {
                 $strval .= '?,';
-                if($val != ""){
-                    $arrval[] = $val;
-                } else {
-                    $arrval[] = NULL;
-                }
+                $arrval[] = $val;
             }
             $find = true;
@@ -271 +267 @@
         // INSERT文の実行
         $ret = $this->conn->query($sqlin, $arrval);
-
-        return $ret;
-    }
-
-    // INSERT文の生成・実行
-    // $table   :テーブル名
-    // $sqlval  :列名 => 値の格納されたハッシュ配列
-    function fast_insert($table, $sqlval) {
-        $strcol = '';
-        $strval = '';
-        $find = false;
-
-        foreach ($sqlval as $key => $val) {
-                $strcol .= $key . ',';
-                if($val != ""){
-                    $eval = pg_escape_string($val);
-                    $strval .= "'$eval',";
-                } else {
-                    $strval .= "NULL,";
-                }
-                $find = true;
-        }
-        if(!$find) {
-            return false;
-        }
-        // 文末の","を削除
-        $strcol = ereg_replace(",$","",$strcol);
-        // 文末の","を削除
-        $strval = ereg_replace(",$","",$strval);
-        $sqlin = "INSERT INTO $table(" . $strcol. ") VALUES (" . $strval . ")";
-
-        // INSERT文の実行
-        $ret = $this->conn->query($sqlin);
 
         return $ret;
@@ -327 +290 @@
             } else {
                 $strcol .= $key . '= ?,';
-                if($val != ""){
-                    $arrval[] = $val;
-                } else {
-                    $arrval[] = NULL;
-                }
+                $arrval[] = $val;
             }
             $find = true;
@@ -363 +322 @@
         }
 
-        // INSERT文の実行
+        // UPDATE文の実行
         $ret = $this->conn->query($sqlup, $arrval);
         return $ret;