Question

How to read csv file with PHP

Answer 1

$csv_file = fopen("e:/test.csv", "r");
while (!feof($csv_file))
    print_r(fgetcsv($csv_file));
fclose($csv_file);
    
/*
run:

Array ( [0] => csv_post_title [1] => csv_post_post [2] => csv_post_excerpt [3] 
=> csv_post_categories [4] => csv_post_tags [5] => csv_post_date [6] => csv_post_author [7] 
=> csv_post_slug [8] => csv_ctax_art [9] => csv_ctax_country [10] => my_custom1 ) Array ( [0] 
=> Vincent Van Gogh [1] => Vincent Willem van Gogh[a 1] (30 March 1853...

*/

 

70+ SQL courses for beginners and professionals

Answer 2

$csv_file = fopen("e:/test.csv", "r");
while (!feof($csv_file))
{
    echo '<pre>';
    print_r(fgetcsv($csv_file));
    echo '</pre>';
}
fclose($csv_file);
    
/*
run:

Array
(
    [0] => csv_post_title
    [1] => csv_post_post
    [2] => csv_post_excerpt
    [3] => csv_post_categories
    [4] => csv_post_tags
    [5] => csv_post_date
    [6] => csv_post_author
    [7] => csv_post_slug
    [8] => csv_ctax_art
    [9] => csv_ctax_country
    [10] => my_custom1
)

Array
(
    [0] => Vincent Van Gogh
    [1] => Vincent Willem van Gogh[a 1] (30 March 1853 29 July 1890) 
    ...

*/

 

70+ SQL courses for beginners and professionals

Answer 3

/*
 array fgetcsv ( resource $handle [, int $length = 0 
                                  [, string $delimiter = ","  
                                  [, string $enclosure = '"' 
                                  [, string $escape = "\" ]]]] )
 */


$row = 1;
if (($csv_file = fopen("e:/test.csv", "r")) !== FALSE) 
{
    while (($row_data = fgetcsv($csv_file, 1024, ",")) !== FALSE) 
    {
        $num_fields = count($row_data);
        echo "<p> Line $row: <br /></p>\n";
        $row++;
        for ($i = 0; $i < $num_fields; $i++) 
            echo $row_data[$i] . "<br />\n";
    }
    fclose($csv_file);
}

    
/*
run:

Line 1: 


csv_post_title
csv_post_post
csv_post_excerpt
csv_post_categories
csv_post_tags
csv_post_date
csv_post_author
csv_post_slug
csv_ctax_art
csv_ctax_country
my_custom1

Line 2: 


Vincent Van Gogh
Vincent Willem van Gogh 30 March 
...

*/

 

70+ SQL courses for beginners and professionals