Changeset 5881 for temp/trunk

Timestamp:

2006/09/26 14:51:50 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/system/bkup.php (modified) (7 diffs)

temp/trunk/html/admin/system/bkup.php

@@ -179 +179 @@
                 $data = "";
                 foreach($arrData as $data_key => $data_val){
-                    $data .= lfGetCSVList($arrData[$data_key]);
+                    $data .= sfGetCSVList($arrData[$data_key]);
                 }
                 // CSV½ÐÎϥǡ¼¥¿À¸À®
@@ -192 +192 @@
     $csv_file = $bkup_dir . "bkup_data.csv";
     $csv_autoinc_file = $bkup_dir . "autoinc_data.csv";
+    mb_internal_encoding('EUC-JP');
     // CSV½ÐÎÏ
     // ¥Ç¥£¥ì¥¯¥È¥ê¤¬Â¸ºß¤·¤Æ¤¤¤Ê¤±¤ì¤ÐºîÀ®¤¹¤ë     
@@ -471 +472 @@
 function lfExeInsertSQL($objQuery, $csv){
     global $objPage;
-    // csv¥Õ¥¡¥¤¥ë¤«¤é¥Ç¡¼¥¿¤Î¼èÆÀ
-    $arrCsvData = file($csv);
 
     $sql = "";
@@ -481 +480 @@
     $pagelayout_flg = false;
     $mode = $objPage->mode;
-        
-    foreach($arrCsvData as $key => $val){
-        $data = trim($val);
+    
+    // csv¥Õ¥¡¥¤¥ë¤«¤é¥Ç¡¼¥¿¤Î¼èÆÀ
+//  $arrCsvData = file($csv);
+    $fp = fopen($csv, "r");
+
+
+    while ($data = fgetcsv($fp, 1000000)) {
+//  foreach($arrCsvData as $key => $val){
         
         //¶õÇò¹Ô¤Î¤È¤­¤Ï¥Æ¡¼¥Ö¥ëÊѹ¹
-        if ($data == "") {
+        if (count($data) <= 0 == "") {
             $base_sql = "";
             $tbl_flg = false;
@@ -495 +499 @@
         // ¥Æ¡¼¥Ö¥ë¥Õ¥é¥°¤¬¤¿¤Ã¤Æ¤¤¤Ê¤¤¾ì¹ç¤Ë¤Ï¥Æ¡¼¥Ö¥ë̾¥»¥Ã¥È
         if (!$tbl_flg) {
-            $base_sql = "INSERT INTO $data ";
+            $base_sql = "INSERT INTO $data[0];";
             $tbl_flg = true;
             
@@ -508 +512 @@
         if (!$col_flg) {
             if ($mode != "restore_config"){
-                $base_sql .= " ($data) ";
+                $base_sql .= " ( $data[0] ";
+                for($i = 1; $i < count($data); $i++){
+                    $base_sql .= "," . $data[$i];
+                }
+                $base_sql .= " ) ";
             }
             $col_flg = true;
@@ -515 +523 @@
 
         // ¥¤¥ó¥µ¡¼¥È¤¹¤ëÃͤò¥»¥Ã¥È
-        $sql = $base_sql . "VALUES ($data);\n";
+        $sql = $base_sql . "VALUES ( $data[0] ";
+        for($i = 1; $i < count($data); $i++){
+            $sql .= "," . $data[$i];
+        }
+        $sql .= " );";
         $err = $objQuery->query($sql);