CVS Files

AndyPanda

Basically I have a CVS file with two tabs. I just need a simple loop which extracts the data from each line into $var1 and $var2. I can then format these two vars, then add them into MySQL with more stuff I will be adding to it. I can do the formatting and MySQL part, but I can't find a working solution for extracting from CVS.

AndyPanda

$file= file_get_contents("./text.txt");
$data = explode("\n",$file);
foreach ($data as $file) {
list($var1, $var2) = explode(",", $data);
}

Is it something like this?

Bjom

It might be a csv (comma separated values) file even it it's delimited by tabs 😉.

You can do it like that or you can save a line of code by using

$file= file("./text.txt");

which returns an array by itself and makes the explode unnecessary.

Or you could simply open the file (instead of reading it in its entirety) and then read it one line at a time with fgetcsv like in the example in the manual

(if you try all those alternatives and do some speed testing let me know the results)

Bjom

P.S.: using [ php ] [ /php ] tags instead of [ code ] [ /code ] tags makes the code pretty and colorful

AndyPanda

I don't get it.

This splits the line, but what read the line ( $line )
list($title, $epic) = explode(",", $line);

AndyPanda

Can you give me an explain of opening the file, then putting the line intot $line, then repeat until EOF.

Bjom

read up in the manual about foreach. php.net/foreach think you mixed up where to put array and arrayentry in your first example. This should work, provided that your data is separated by commas:

$data= file("./text.txt");
foreach ($data as $line) {
    list($var1, $var2) = explode(",", $line);
    echo 'var1: ', $var1, 'var2: ', $var2, '</br>';
}

And also follow the link to the manual that I provided above and have a look at "example 1". It has all you need.