Changeset 4761 for temp/trunk

Timestamp:

2006/09/15 11:19:54 (20 years ago)

Author:

kakinaka

Message:

blank

Location:

temp/trunk

Files:

• data/class/SC_DbConn.php (modified) (3 diffs)
• data/lib/slib.php (modified) (1 diff)
• html/test/kakinaka/mysql.php (modified) (1 diff)

temp/trunk/data/class/SC_DbConn.php

@@ -52 +52 @@
         
         // mysql¤Î¾ì¹ç¤Ë¤Ï¥Ó¥å¡¼É½¤òÊÑ´¹¤¹¤ë
-        if (DB_TYPE == "mysql") {
-            $n = sfChangeView($n);
-            $n = sfChangeILIKE($n);
-        }
+        if (DB_TYPE == "mysql") $n = sfChangeMySQL($n);
         
         if ( $arr ) {
@@ -72 +69 @@
 
         // mysql¤Î¾ì¹ç¤Ë¤Ï¥Ó¥å¡¼É½¤òÊÑ´¹¤¹¤ë
-        if (DB_TYPE == "mysql") {
-            $n = sfChangeView($n);
-            $n = sfChangeILIKE($n);
-        }
+        if (DB_TYPE == "mysql") $n = sfChangeMySQL($n);
 
         if ( $arr ) {
@@ -93 +87 @@
 
         // mysql¤Î¾ì¹ç¤Ë¤Ï¥Ó¥å¡¼É½¤òÊÑ´¹¤¹¤ë
-        if (DB_TYPE == "mysql") {
-            $n = sfChangeView($n);
-            $n = sfChangeILIKE($n);
-        }
+        if (DB_TYPE == "mysql") $n = sfChangeMySQL($n);
         
         if(PEAR::isError($this->conn)) {

temp/trunk/data/lib/slib.php

@@ -2340 +2340 @@
 }
 
+//MySQLÍѤÎSQLʸ¤ËÊѹ¹¤¹¤ë
+function sfChangeMySQL($sql){
+    // ²þ¹Ô¡¢¥¿¥Ö¤ò1¥¹¥Ú¡¼¥¹¤ËÊÑ´¹
+    $sql = preg_replace("/[\r\n\t]/"," ",$sql);
+    
+    $sql = sfChangeView($sql);      // viewɽ¤ò¥¤¥ó¥é¥¤¥ó¥Ó¥å¡¼¤ËÊÑ´¹¤¹¤ë
+    $sql = sfChangeILIKE($sql); // ILIKE¸¡º÷¤òLIKE¸¡º÷¤ËÊÑ´¹¤¹¤ë
+    
+    return $sql;
+}
+
 // viewɽ¤ò¥¤¥ó¥é¥¤¥ó¥Ó¥å¡¼¤ËÊÑ´¹¤¹¤ë
 function sfChangeView($sql){

temp/trunk/html/test/kakinaka/mysql.php

@@ -53 +53 @@
     ) vw_products_allclass ';
     
-print(preg_replace("/[\r\n\t]/","",$sql));
+print(preg_replace("/[\r\n\t]/"," ",$sql));
 
 print("end");