PHP code to read ACCESS data to MYSQL_PHP tutorial

The following example is relatively simple, that is, first use the com interface to read the access database tutorial, read the data, then connect to the mysql tutorial database, and insert the corresponding fields into the corresponding tables and fields of mysql.

header('ontent-Type:text/html;charset=GB2312');//Avoid garbled code output
$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='Decoration Classroom'",$conn,1,3);
while(!$rs->eof){
Switch ($rs->Fields[4]){
case "Renovation Consultant":
$sclass=1;
        break;
case "Kitchen and Bathroom Space":
$sclass=2;
        break;
case "Furniture Story":
$sclass=3;
        break;
case "Electrical Engineering":
$sclass=4;
        break;
       case "Home Decoration Scenery":
$sclass=5;
        break;
case "Material wide angle":
$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 "
";
$rs->Movenext(); //Move the record set pointer down
}
$rs->close();
?>

http://www.bkjia.com/PHPjc/630753.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/630753.htmlTechArticleThe following example is relatively simple, which is to first use the com interface to read the access database tutorial, read the data and then connect to mysql Tutorial database, insert the corresponding fields into the corresponding tables and fields of mysql...