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号