foreach ($arr_fields as $key => $value) { $f = $rs->Fields($key); $insert_value[$i][$value] = convert_quote($f->value); } $i++; $rs->MoveNext(); } //print_r($insert_value); $DMC->query("TRUNCATE TABLE " . $DBPrefix . "categories"); foreach ($insert_value as $value) { $key = array_keys($value); $insert_sql = "insert into " . $DBPrefix . "categories(" . implode(",", $key) . ") values('" . implode("','", $value) . "')"; $DMC->query($insert_sql); } echo " 共转换了<font color=red>" . $i . "</font>条记录<br /><br />"; $rs->Close(); //转换日志 echo "正在转换日志 ..."; ob_flush(); flush(); $i = 0; $insert_value = array(); $arr_fields = array("log_ID" => "id", "log_CateID" => "cateId", "log_Title" => "logTitle", "log_Content" => "logContent", "log_Author" => "author", "log_CommNums" => "commNums", "log_QuoteNums" => "quoteNums", "log_ViewNums" => "viewNums", "log_PostTime" => "postTime", "log_IsShow" => "saveType", "log_tag" => "tags"); $rs->Open("select * from blog_Content", $conn, 1, 1); while (!$rs->eof) { foreach ($arr_fields as $key => $value) { $f = $rs->Fields($key); $field_value = convert_quote($f->value); if ($key == "log_PostTime") { $field_value = pjtime_convert($field_value); }