importing a pipe csv files into a db issue

[ollyno1uk]

Hi

 

I wrote a script a while back that imports a pipe csv files into my database. It worked great until the people who make the file started using some pipes within the string.

 

The strings are separated with quotations but I do not know how to modify this script to not explode the pipes that are contained within;

 

Perhaps someone can point me in the right direction.

$url = 'url of feed';
$content = file_get_contents($url);

$array = explode("\n", $content);

foreach($array as $line_number=>$line){


$column = explode('|', $line);



$query = "insert into table set
column1 = $column[0],
column2 = $column[1],
column3 = $column[2]; 

[Yesideez]

PHP has some CSV handling routines especially for reading these files.

 

http://php.net/fgetcsv

[ollyno1uk]

wow that was quick - thanks

 

I have looked at this function before but as a bit of a php newbie, I note that most examples are using a while() rather than my foreach() hence I stayed way from it.

 

I will experiment some more with it

[Yesideez]

You're using file_get_contents to get the contents of your CSV file so it wouldn't be very difficult to modify your script to read in using fgetcsv()

[ollyno1uk]

with the fgetcsv() will I need to actually get teh csv file to my server first before it works?

 

Previously I was just getting the data from the url. It does not seem to like it changing to the fgetcsv()

[Yesideez]

I presume so - you can use file_get_contents to grab the content, create a file on the server something like:

$filename='tmp'.time().'.csv';

Then read the file in using fgetcsv() once you open() the file you created for reading.

 

Once finished, unless you need to keep the contents of the file you can use unlink() to delete it.

 

unlink($filename);