: This article describes how to use php to import data from text to mysql. if you are interested in the PHP Tutorial, refer to it. Access allows you to easily import data in text into tables. MySQL is not that easy to use, but it is also very easy to use.
First, separate data records by line to use specific characters, for example, ",".
The record format is as follows:
Aaa, bbb, ccc, ddd, eee
Fff, ggg, hhh, iii, jjj, kkk
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 preceding section describes how to use php to import data from text to mysql, including text to mysql. if you are interested in the PHP Tutorial.
