PHP读取ACCESS数据到MYSQL的代码_php技巧

 <BR><?php <BR>header('ontent-Type:text/html;charset=GB2312');//避免输出乱码 <BR>$dbhost ="localhost"; <BR>$dbuser ="root"; <BR>$dbpassword = "123456"; <BR>$dbname = "139miaosha"; <BR>mysql_connect($dbhost,$dbuser<mark style="color:transparent">本%文来源gaodaimacom搞#^代%!码网@</mark>搞代gaodaima码,$dbpassword) or die("error!"); <BR>mysql_query("set names 'gbk'"); <BR>mysql_select_db('139miaosha'); <BR>$conn = new com("ADODB.Connection"); <BR>$connstr="DRIVER=Microsoft Access Driver (*.mdb);DBQ=F:/wamp/www/miaosha/ruichao858.mdb"; <BR>$conn->Open($connstr); <BR>$rs = new COM("ADODB.RecordSet"); <BR>$rs->Open("select * from News where bigclassname='装修课堂'",$conn,1,3); <BR>while(!$rs->eof){ <BR>switch ($rs->Fields[4]){ <BR>case "装修顾问": <BR>$sclass=1; <BR>break; <BR>case "厨卫空间": <BR>$sclass=2; <BR>break; <BR>case "家具物语": <BR>$sclass=3; <BR>break; <BR>case "电器工程": <BR>$sclass=4; <BR>break; <BR>case "居饰风景": <BR>$sclass=5; <BR>break; <BR>case "材料广角": <BR>$sclass=6; <BR>break; <BR>default: <BR>$sclass=1; <BR>} <BR>if ($rs->Fields[6]){ <BR>$spic=""; <BR>}else{ <BR>$spic=$rs->Fields[6]; <BR>} <BR>if ($rs->Fields[7]){ <BR>$user=""; <BR>}else{ <BR>$user=$rs->Fields[7]; <BR>} <BR>if ($rs->Fields[9]){ <BR>$hits=1; <BR>}else{ <BR>$hits=$rs->Fields[9]; <BR>} <BR>$sql="insert into rc_news(n_title,n_content,n_bclass,n_sclass,n_pic,n_spic,n_user,n_hits,n_audit) values('".$rs->Fields[1]."','".$rs->Fields[2]."',1,".$sclass.",'','".$spic."','".$user."',".$hits.",1)"; <BR>$result=mysql _query($sql); <BR>//echo $rs->Fields[1]; <BR>//echo "<br />"; <BR>$rs->Movenext(); //将记录集指针下移 <BR>} <BR>$rs->close(); <BR>?> <BR>

喜欢 (0)赏

[搞代码]

分享 (0)