璇诲彇ACCESS鏁版嵁鍒癕YSQL鐨凱HP浠ｇ爜 - PHP鍏ラ棬

涓嬮潰瀹炰緥姣旇緝绠€鍗?灏辨槸鍏堝埄鐢╟om鎺ュ彛璇诲彇access鏁版嵁搴?鎶婃暟鎹鍙栧悗鍐嶈繛鎺ysql鏁欑▼鏁版嵁搴?鎶婂搴旂殑瀛楁insert鍒癿ysql瀵瑰簲鐨勮〃涓庡瓧娈靛氨瀹炵幇浜?璇诲彇ACCESS鏁版嵁鍒癕YSQL鐨凱HP浠ｇ爜濡備笅:

<?php 
	header(&#39;ontent-Type:text/html;charset=GB2312&#39;);//閬垮厤杈撳嚭涔辩爜 
	$dbhost     ="localhost"; 
	$dbuser     ="root"; 
	$dbpassword = "123456"; 
	$dbname     = "139miaosha"; 
	mysql_connect($dbhost,$dbuser,$dbpassword) or die("error!"); 
	mysql_query("set names &#39;gbk&#39;"); 
	mysql_select_db(&#39;139miaosha&#39;); 
	 
	 
	 $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"); 
	//寮€婧愪唬鐮乸hprm.com 
	 $rs->Open("select * from News where bigclassname=&#39;瑁呬慨璇惧爞&#39;",$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(&#39;".$rs->Fields[1]."&#39;,&#39;".$rs->Fields[2]."&#39;,1,".$sclass.",&#39;&#39;,&#39;".$spic."&#39;,&#39;".$user."&#39;,".$hits.",1)"; 
	     $result=mysql _query($sql); 
	     //echo  $rs->Fields[1]; 
	     //echo "<br/>"; 
	     $rs->Movenext(); //灏嗚褰曢泦鎸囬拡涓嬬Щ 
	 } 
	 $rs->close(); 
	

鏈枃鍦板潃锛?a target="_self" data-cid="10425" href="">

杞浇闅忔剰锛屼絾璇烽檮涓婃枃绔犲湴鍧€:-)