查看完整版本: access to mysql

access to mysql

             <p><PRE>这段程序是用来进行ACCESS到<A onclick="javascript:tagshow(event, 'MYSQL');" href="http://www.phpchina.com/javascript:;" target=_self><U><STRONG><FONT color=#009999>MYSQL</FONT></STRONG></U></A>的转换程序！</PRE><PRE>我的做法是先把ACCESS文件转换成CSV文件，然后利用fgetcsv函数进行转换！</PRE><PRE>&lt;?<BR>&nbsp;require("conn.php");</PRE><DIV class="entry-body nerr"><P>&nbsp;for($j=101;$j&lt;=115;$j++)<BR>&nbsp;{<BR>&nbsp;$file = "a".$j.".csv";</P><P>&nbsp;//到导入的表名称<BR>&nbsp;$table= 'website';</P><P>&nbsp;$fp = fopen("$file",'rb');<BR>&nbsp;$datanum = 1;<BR>&nbsp;echo "&lt;font color='red'&gt;开始插入".$j."&lt;/font&gt;&lt;br&gt;&lt;br&gt;";<BR>&nbsp;while($data = fgetcsv($fp,1024,','))<BR>&nbsp;&nbsp;{<BR>&nbsp;&nbsp;&nbsp;$num = count($data);<BR>&nbsp;&nbsp;&nbsp;$values="$j";<BR>&nbsp;&nbsp;&nbsp;for ($i=1; $i &lt; $num; $i++) <BR>&nbsp;&nbsp;&nbsp;{<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if($values=="")<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$values="'".addslashes($data[$i])."'";<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;else<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$values.=",'".addslashes($data[$i])."'";<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<BR>&nbsp;&nbsp;&nbsp;}</P><P>&nbsp;&nbsp;&nbsp;//表的字段信息<BR>&nbsp;&nbsp;&nbsp;$field="`web_bh` , `web_site` , `web_url` , `web_field` , `web_channel` , `web_date` , `web_signum` , `web_zxrs` , `web_alexa` , `web_rec` , `web_adv` , `web_layout` , `web_laysum` , `web_sumtie` , `web_city` , `web_per` , `web_cont`";</P><P>&nbsp;&nbsp;&nbsp;$sql="insert into $table($field) values($values)";<BR>&nbsp;&nbsp;&nbsp;echo $sql;<BR>&nbsp;&nbsp;&nbsp;exit;<BR>&nbsp;&nbsp;&nbsp;$res=mysql_query($sql,$conn);<BR>&nbsp;&nbsp;&nbsp;if(!$res)<BR>&nbsp;&nbsp;&nbsp;{<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;echo mysql_errno(). ": ".mysql_error(). "&lt;br&gt;";<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//exit();<BR>&nbsp;&nbsp;&nbsp;}</P><P>&nbsp;&nbsp;&nbsp;echo "&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;第".$datanum."条数据插入完毕&lt;br /&gt;";<BR>&nbsp;&nbsp;&nbsp;$datanum++;<BR>&nbsp;&nbsp;}<BR>&nbsp;}</P><P><BR>?&gt;</P>