在php中读取txt文件并将数据解析为MySQL

Question

im new to php and i hope you can help with an easy to get script. I have a txt file with this general format:

5TB-2A, L+, 1, 1695, 3255, l.jpg
5TB-2A, L-, 2, 1965, 3270, l.jpg
5TB-2A, D-, 7, 2970, 3270, l.jpg
5TB-2A, DFOK, 8, 3225, 3300, l.jpg

I want to read this txt file using php to retrive every data separated by "," into my MySQL table. Thanks for any help.

Answer 1

$lines=file($yourTxt);

foreach($lines as $v) {
   $values = explode(',',$v);
   PDO::prepare("INSERT INTO tbl (?,?,?,?,?)");
   PDO::execute($values);
}

You can make a further check too see if the line just read is ok like:

foreach($lines as $v) {
   $values = explode(',',$v);
   if (count($values)!=6)
     continue;
}