Question

How to parse a CSV file into an array in PHP

Answer 1

$csv = array_map('str_getcsv', file('d:\\test.csv'));

echo "<pre>"; print_r($csv); echo "</pre>";


/*
run:
    
Array
(
    [0] => 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
        )

    [1] => Array
        (
            [0] => Vincent Van Gogh
            [1] => Vincent Willem van Gogh post-Impressionist painter
            [2] => Vincent Willem van Gogh was a Dutch post-Impressionist painter
            [3] => Art, CSV Importer
            [4] => van gogh, dutch, painter
            [5] => June 1, 2010
            [6] => alice
            [7] => Van-gogh-one
            [8] => Painting, post-impressionism
            [9] => Netherlands,France
            [10] => 53
        )

    [2] => Array
        (
            [0] => Claude Monet
    ...
      
*/

 

70+ SQL courses for beginners and professionals