PHP reads access data to MySQL

 

<? PHP
Header ('ontent-type: text/html; charset = gb2312 '); // avoid output garbled characters
$ Dbhost = "localhost ";
$ Dbuser = "root ";
$ Dbpassword = "123456 ";
$ Dbname = "139 miaosha ";
Mysql_connect ($ dbhost, $ dbuser, $ dbpassword) or die ("error! ");
Mysql_query ("set names 'gbk '");
Mysql_select_db ('139miaosha ');

$ SID = $ _ Get ["Sid"];
If ($ SID = 1 ){
$ 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 class' and smallclassname <>'' ", $ Conn, 1, 3 );
While (! $ RS-> EOF ){
Switch ($ RS-> fields [4]-> value ){
Case "decoration consultant ":
$ Sclass = 2;
Break;
Case "kitchen space ":
$ Sclass = 3;
Break;
Case "furniture story ":
$ Sclass = 4;
Break;
Case "Electrical Engineering ":
$ Sclass = 5;
Break;
Case "decoration scenery ":
$ Sclass = 6;
Break;
Case "wide angle material ":
$ Sclass = 7;
Break;
Default:
$ Sclass = 1;
}

$ Spic = $ RS-> fields [6]-> value;
$ User = $ RS-> fields [7]-> value;
$ Hits = $ RS-> fields [9]-> value;
If ($ RS-> fields [24]-> value = ''){
$ Comments = 0;
} Else {
$ Comments = $ RS-> fields [24]-> value;
}
$ Ytime = date ("Y", strtotime ($ RS-> fields [8]-> value ));
$ Mtime = date ("M", strtotime ($ RS-> fields [8]-> value ));
$ Dtime = date ("D", strtotime ($ RS-> fields [8]-> value ));
$ Stime = mktime (0, 0, 0, $ mtime, $ dtime, $ ytime );
$ Pfile = $ stime. "". Rand (1000,9999). ". shtml ";

// $ SQL = "insert into rc_news_connent (n_title, n_content, n_bclass, n_sclass, n_pic, n_spic, n_user, n_time, n_hits, n_audit) values ('". $ RS-> fields [1]-> value. "','". $ RS-> fields [2]-> value. "', 1 ,". $ sclass. ",'','". $ spic. "','". $ user. "','". date ("Y-m-d h: I: s "). "',". $ hits. ", 1 )";
$ SQL = "insert into values (news_class, news_title, template_id, news_content, news_publisher, news_hits, created, inputtime, news_commentnum, news_image, news_file, news_htmlname) values (". $ sclass. ",'". $ RS-> fields [1]-> value. "', 1 ,'". $ RS-> fields [2]-> value. "', 'admin ',". $ hits. ",'". $ stime. "','". $ RS-> fields [8]-> value. "',". $ comments. ",'". $ spic. "','". $ RS-> fields [8]-> value. "','". $ pfile. "')";
$ Result = mysql_query ($ SQL );
$ RS-> movenext (); // move the record set pointer down
}
$ RS-> close ();
Echo "successful! ";
} Else {
Echo "error! ";
}
?>