Changeset 10299

Timestamp:

2006/12/06 12:30:51 (20 years ago)

Author:

kaki

Message:

 

Location:

temp/trunk

Files:

• data/lib/slib.php (modified) (2 diffs)
• html/admin/products/index.php (modified) (1 diff)

temp/trunk/data/lib/slib.php

@@ -2524 +2524 @@
 }
 
-
+// SQL¥·¥ó¥°¥ë¥¯¥©¡¼¥ÈÂбþ
 function sfQuoteSmart($in){
     
@@ -2566 +2566 @@
     $changesql = eregi_replace("( RANDOM)", " RAND", $sql);
     return $changesql;
+}
+
+// view¤Îwhere¤òÃÖ´¹¤¹¤ë
+function sfViewWhere($target, $where = "", $arrval = array(), $option = ""){
+    global $arrViewWhere;
+    $arrWhere = split("[?]", $where);
+    $where_tmp = " WHERE " . $arrWhere[0];
+    for($i = 1; $i < count($arrWhere); $i++){
+        $where_tmp .= sfQuoteSmart($arrval[$i - 1]) . $arrWhere[$i];
+    }
+    $arrViewWhere[$target] = $where_tmp . " " . $option;
 }
 

temp/trunk/html/admin/products/index.php

@@ -279 +279 @@
             
             // view¤â¹Ê¹þ¤ß¤ò¤«¤±¤ë(mysqlÍÑ)
-            global $arrViewWhere;
-            $arrWhere = split("[?]", $view_where);
-            $where_tmp = " WHERE " . $arrWhere[0];
-            for($i = 1; $i < count($arrWhere); $i++){
-                $where_tmp .= sfQuoteSmart($arrval[$i - 1]) . $arrWhere[$i];
-            }
-            $arrViewWhere["&&noncls_where&&"] = $where_tmp . " " . $objQuery->order . " " .  $objQuery->setlimitoffset($page_max, $startno, true);
-        
+            sfViewWhere("&&noncls_where&&", $view_where, $arrval, $objQuery->order . " " .  $objQuery->setlimitoffset($page_max, $startno, true));
+
             // ¸¡º÷·ë²Ì¤Î¼èÆÀ
             $objPage->arrProducts = $objQuery->select($col, $from, $where, $arrval);