How to import data from text to mysql using php

In access, you can easily import the data in the text into the table. It is not so convenient to use in MySQL, but it is actually very simple.
First, the data records are processed in rows and separated by specific characters such as: ","
The record looks like:
aaa,bbb,ccc,ddd,eee
fff,ggg,hhh,iii,jjj,kkk
That’s it, create loaddate.php
$hostname="localhost";
$username="yourname";
$passWord="yourpwd";
$dbname="yourdb";
mysql_connect($hostname,$username,$password);
mysql_select_db("$dbname");
$mydate=file("yourdate.txt");
$n=count($mydate);
for($i=0;$i<$n;$i++){
$date=explode(",",$mydate[$i]);
$str="insert into ip values('$date[0]','$date[1]','$date[2]','$date[3]','$date[4]')" ; //
mysql_query($str);
}
mysql_close();
echo "ok!";
?>
Run loaddate.

The above introduces how to use PHP to import data from text to mysql, including the content of importing text into mysql. I hope it will be helpful to friends who are interested in PHP tutorials.