$rs = new com("ADODB.RecordSet", NULL, CP_UTF8); //转换类别 echo "正在转换类别 ..."; ob_flush(); flush(); $i = 0; $insert_value = array(); $arr_fields = array("cate_ID" => "id", "cate_Name" => "name", "cate_Order" => "orderNo", "cate_Intro" => "cateTitle", "cate_count" => "cateCount", "cate_Secret" => "isHidden"); $rs->Open("select * from blog_Category", $conn, 1, 1); while (!$rs->eof) { 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;