Parse Text File to Database

[Anon]

I want to parse a text file and extract the values from it using the pole delimeter '|'.

The data looks like this:

55239|38|Description|1.25|2.56|

I want to extract the values and insert it, can anyone help me with the source code.

[Anon]

You don't need to write PHP to do this; the mysql utility can invoke LOAD DATA INFILE with the proper arguments. See the MySQL manual, section 6.4.9.

[Anon]

<?
$file = file ('text.txt);
foreach ($file as $line) {
$fields = explode ('|', $line);
mysql_query = "INSERT INTO table SET
field1 = '$fields[0]',
field2 = '$fields[1]',
field3 = '$fields[2]',
field4 = '$fields[3]',
field5 = '$fields[4]',
":
}
?>

obviously you would fill in those "fields" with the exact names of your database fileds.