php access数据导入mysql,大家应该都会的,勿喷哦,有错就改哈
Open($connstr);
$rs = @new COM("ADODB.RecordSet");
$rs->Open("select * from TABLE_NAME",$conn,1,3);
while(!$rs->eof){
$ftitle[]=iconv('GB2312','UTF-8',$rs->Fields["c_title"]->Value);
$fcontent[]=iconv('GB2312','UTF-8',$rs->Fields["c_content"]->Value);
$fcdate[]=strtotime($rs->Fields["c_date"]->Value);
$rs->Movenext(); //将记录集指针下移
}
$rs->close();
for ($i=0;$i$ftitle[$i],
"b_content"=>$fcontent[$i],
"b_date"=>$fcdate[$i]
);
/*这里是插入语句了*/
}
?>
PHP怎么学习?PHP怎么入门?PHP在哪学?PHP怎么学才快?不用担心,这里为大家提供了PHP速学教程(入门到精通),有需要的小伙伴保存下载就能学习啦!
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号