Inserting data from CSV File

[gdk123]

Is it possible to insert data into MySQL from CSV (Comma Seperated Value) files?I have seen on project doing this in ASP.NET.They are using driver for SQL database.

[Mr_CHISOL]

Hi!You could use explode() (or split() if you want regular expessions), which splits the string into an array, and then add the info into an db.Example:

// Connecting, selecting database$link = mysql_connect('mysql_host', 'mysql_user', 'mysql_password')   or die('Could not connect: ' . mysql_error());mysql_select_db('my_database') or die('Could not select database');$text = file_get_contents( 'file.txt' );$info = explode( ',', $text );// Performing SQL query$query = "INSERT INTO my_table (field1,field2,field3) VALUES('".$info[0]."','".$info[1]."','".$info[2]."')";mysql_query($query) or die('Query failed: ' . mysql_error());// Closing connectionmysql_close($link);

If the info also is seperated by newlines (or such), you could do like this:

// Connecting, selecting database$link = mysql_connect('mysql_host', 'mysql_user', 'mysql_password')   or die('Could not connect: ' . mysql_error());mysql_select_db('my_database') or die('Could not select database');$text = file_get_contents( 'file.txt' );$lines = explode( "\n", $text );foreach ( $lines as $line ) {   $info = explode( ',', $line );   // Performing SQL query   $query = "INSERT INTO my_table (field1,field2,field3) VALUES('".$info[0]."','".$info[1]."','".$info[2]."')";   mysql_query($query) or die('Query failed: ' . mysql_error());}// Closing connectionmysql_close($link);

In the last example you could use file() instead of file_get_contents() and explode(), as file() returns an array with the lines. Please note that in the case of file() you also get the newline at the end of each line/string, which you don't get from explode.Hope that helped.Good Luck and Don't Panic!

[vijay]

Hi.. yes, Its possible.. there is command for load data.. refer: http://vietunicode.sourceforge.net/howto/importcsvmysql.html http://www.modwest.com/help/kb6-253.html http://www.modwest.com/help/kb6-253.html Regards, Vijay

[vijay]

Hi.. Open phpmyadmin and select any db then select any table then select sql: that will open sql query textbox area.. under that there is small link having text: "Insert data from a text file into the table " Click this you will get it.. Regards, Vijay