链接ACCESS数据库的PHP原代码

作者：[网上资料 ]

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