如何使用PHP将文本文件（CSV）解析为MySQL

Question

I have a .txt (csv) file which I want to read thru PHP and arrange it in arrays so that I can later insert or update it into MySQL, The text file is like this:

FIELD1;FIELD2;FIELD3;FIELD4

CATEGORY 1(SOME VALUE in PARENTHESIS)
Sub-Category 1
VALUEof1;VALUEof2;VALUEof3;VALUEof4
VALUEof1;VALUEof2;VALUEof3;VALUEof4
VALUEof1;VALUEof2;VALUEof3;VALUEof4

Sub-Category 2 
VALUEof1;VALUEof2;VALUEof3;VALUEof4
VALUEof1;VALUEof2;VALUEof3;VALUEof4
VALUEof1;VALUEof2;VALUEof3;VALUEof4

CATEGORY 2(SOME VALUE in PARENTHESIS)
Sub-Category 1
VALUEof1;VALUEof2;VALUEof3;VALUEof4
VALUEof1;VALUEof2;VALUEof3;VALUEof4
VALUEof1;VALUEof2;VALUEof3;VALUEof4

I have been able to read each line separately beyond that I have gone completely blank and not able to figure out what is to be done, any advice or direction will be appreciated

Answer 1

You can use MYSQL query as below to import the .csv file. Keep in mind that you have to match the columns in the CSV file to those in the table. Also, i will recommend that you to refer the LOAD DATA INFILE.

https://dev.mysql.com/doc/refman/5.7/en/load-data.html

$query = <<<EOF
        LOAD DATA LOCAL INFILE '$file'
         INTO TABLE users
         FIELDS TERMINATED BY ','
         LINES TERMINATED BY '
'
         IGNORE 1 LINES
        (name,mobile,email)
EOF;