Changeset 7791 for temp/trunk

Timestamp:

2006/11/08 15:59:14 (20 years ago)

Author:

kakinaka

Message:

blank

Location:

temp/trunk

Files:

• data/class/SC_Query.php (modified) (1 diff)
• html/shopping/confirm.php (modified) (1 diff)

temp/trunk/data/class/SC_Query.php

@@ -410 +410 @@
     }
     
+    // auto_increment¤ò¼èÆÀ¤¹¤ë
     function get_auto_increment($table_name){
+        // ¥í¥Ã¥¯¤¹¤ë
+        $this->BEGIN();
+        
+        // ¼¡¤ÎIncrement¤ò¼èÆÀ
         $arrRet = $this->conn->query("SHOW TABLE STATUS LIKE $table_name");
-        
         $auto_inc_no = $arrRet["Auto_increment"];
         
+        // Ãͤò¥«¥¦¥ó¥È¥¢¥Ã¥×¤·¤Æ¤ª¤¯
         $this->conn->query("ALTER TABLE $table_name AUTO_INCREMENT=?" , $auto_inc_no + 1);
+        
+        // ²ò½ü¤¹¤ë
+        $this->COMMIT();
         
         return $auto_inc_no;

temp/trunk/html/shopping/confirm.php

@@ -92 +92 @@
             $order_id = $objQuery->nextval("dtb_order","order_id");
         }elseif (DB_TYPE == "mysql") {
-            $order_id = $objQuery->auto_increment("dtb_order","order_id");
+            $order_id = $objQuery->get_auto_increment("dtb_order");
         }
         $arrData["order_id"] = $order_id;