php - 将 Csv 导入数据库

Question

我有这段代码，当我仅导入三个字段时它运行良好，但是当我尝试导入超过 3 个字段时它不起作用。

mysql_query("INSERT INTO forms (id, created_time, ad_id, ad_name, adset_id, adset_name, campaign_id, campaign_name, form_id, is_organic, specialist, full_name, email, city, country, date_of_birth, phone_number) VALUES 
                ( 
                    '".addslashes($data[0])."', 
                    '".addslashes($data[1])."', 
                    '".addslashes($data[2])."', 
                    '".addslashes($data[3])."', 
                    '".addslashes($data[4])."', 
                    '".addslashes($data[5])."', 
                    '".addslashes($data[6])."', 
                    '".addslashes($data[7])."', 
                    '".addslashes($data[8])."', 
                    '".addslashes($data[9])."', 
                    '".addslashes($data[10])."', 
                    '".addslashes($data[11])."', 
                    '".addslashes($data[12])."', 
                    '".addslashes($data[13])."', 
                    '".addslashes($data[14])."', 
                    '".addslashes($data[15])."', 
                    '".addslashes($data[16])."', 
                    '".addslashes($data[17])."' 
                ) 
            "); 
        } 
    } while ($data = fgetcsv($handle,1000,",","'")); 

Answer 1

试试这个，它对你有用

while ($data = fgetcsv($handle, 1000, ","));

而不是

while ($data = fgetcsv($handle,1000,",","'"));