不卡aⅤ中文字幕手机看,卡一卡二卡三专区免费,国产女饥渴熟女专区九色

<?php $conn = new com("ADODB.Connection"); $connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("11.mdb"); $conn->Open($connstr); $rs = new com("ADODB.RecordSet"); $rs->Open("select * from newslist where n_ppid=81",$conn,1,3); while(!$rs->eof) { $title=$rs->Fields(4); $neirong=$rs->Fields(8); $time=$rs->Fields(24); $laiyuan=$rs->Fields(10); $zuozhe=$rs->Fields(11); $sql=mysql_query("INSERT INTO mysql數(shù)據(jù)庫名字(title,content,addtime,laiyuan,author)<br /> VALUES('".$title."','".$neirong."','".$time."','".$laiyuan."','".$zuozhe."')"); $rs->MoveNext(); } ?>

以上php讀取Access數(shù)據(jù)庫信息和錄入mysql是不是沒有錯(cuò)誤呢？但是很多時(shí)候是導(dǎo)入不成功的，最常見的問題就是兩個(gè)數(shù)據(jù)庫的編碼不同，怎么辦呢，假如access數(shù)據(jù)庫是gbk的，mysql數(shù)據(jù)庫是utf8的，我們做以下操作即可：

<?php $conn = new com("ADODB.Connection"); $connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("11.mdb"); $conn->Open($connstr); $rs = new com("ADODB.RecordSet"); $rs->Open("select * from newslist where n_ppid=81",$conn,1,3); while(!$rs->eof) { $title=mb_convert_encoding($rs->Fields(4), 'utf-8','gb2312' ); $neirong=mb_convert_encoding($rs->Fields(8), 'utf-8','gb2312' ); $time=mb_convert_encoding($rs->Fields(24), 'utf-8','gb2312' ); $click=mb_convert_encoding($rs->Fields(12), 'utf-8','gb2312' ); $laiyuan=mb_convert_encoding($rs->Fields(10), 'utf-8','gb2312' ); $zuozhe=mb_convert_encoding($rs->Fields(11), 'utf-8','gb2312' ); $sql=mysql_query("INSERT INTO mysql數(shù)據(jù)庫名字(title,content,addtime,laiyuan,author)<br /> VALUES('".$title."','".$neirong."','".$time."','".$laiyuan."','".$zuozhe."')"); $rs->MoveNext(); } ?>
西安網(wǎng)頁設(shè)計(jì)

上一篇：skype在線代碼,skype在線會(huì)話,是可以skype客服代碼

下一篇：西安市、陜西省工商營(yíng)業(yè)執(zhí)照網(wǎng)上標(biāo)識(shí)辦理網(wǎng)址及流程

亚洲免费无码网站,一起69国产视频无弹窗,国产182视频在线观看,029亚洲国产乱人视频,国产类似周晓琳视频全集,日韩在线视频线观看一区,国产偷伦视频片免费观看,一级欧美日韩理论片,国产日韩欧美综合在线线,久久99久国产精品66

php讀取Access數(shù)據(jù)庫并寫入mysql數(shù)據(jù)庫