如何将数据从文本导入到mysql
<p><span class="t18">access中可以将文本中的数据轻松导入表中，<a href="http://www.phpchina.com/javascript:;" onClick="javascript:tagshow(event, 'mysql');" target="_self"><u><strong>mysql</strong></u></a>中用起来没那么方便，其实起来也很简单。 <br>首先将数据记录按行处理好用特定的字符分开如：“,” <br>记录形如： <br>aaa,bbb,ccc,ddd,eee <br>fff,ggg,hhh,iii,jjj,kkk <br>就行,建立loaddate.php <br><?php <br>$hostname="localhost"; <br>$username="yourname"; <br>$password="yourpwd"; <br>$dbname="yourdb"; <br>mysql_connect($hostname,$username,$password); <br>mysql_select_db("$dbname"); <br>$mydate=file("yourdate.txt"); <br>$n=count($mydate); <br>for($i=0;$i<$n;$i++){ <br>$date=explode(",",$mydate[$i]); <br>$str="insert into ip values('$date[0]','$date[1]','$date[2]','$date[3]','$date[4]')"；// <br>mysql_query($str); <br>} <br>mysql_close(); <br>echo "ok!"; <br>?> <br>运行loaddate. <br></span><!--正文内容结束--><div>
