如何在PHP中读取此CSV文件？

Question

I have a CSV file with the following format:

"1512";"Wreaths";"";"1493";"1";"0";"2"
"1513";"Wrist Rests";"";"1494";"1";"0";"2"
"1514";"Wrist Watches";"";"1495";"1";"0";"2"
"1515";"Writing";"";"1496";"1";"0";"2"
"1516";"Writing, Research & Publishing Guides";"";"1497";"1";"0";"2"
"1517";"xD-Picture Cards";"";"1498";"1";"0";"2"
"1518";"Yogurt Makers";"";"1499";"1";"0";"2"
"1519";"Yucatan Peninsula";"";"1500";"1";"0";"2"
"1520";"Zip Discs";"";"1501";"1";"0";"2"
"1521";"Zurnas";"";"1502";"1";"0";"2"

Every record is on a different line and I would like to read it using PHP to import it to my database. Here is my code, which doesn't print out anything at all.

<?php
$file = fopen("all_cats.csv", "r") or exit("Unable to open file!");
//Output a line of the file until the end is reached

while(!feof($file))
{
    $line =  fgets($file);
    $json = json_decode($line, true);
    $json[0];
}
fclose($file);

Please let me know what you think and what I should do to get this to work.

Answer 1

You need to use fgetcsv to retrieve data.Please refer this site.