PHP Script to Insert CSV into MySQL with first row as field names

[hybmg57]

Hi,

 

Is there a way we can use PHP script to insert a CSV file into MySQL with CSV's first row as field names in MySQL?

[mapleleaf]

If you know what the field names are and how many you just skip the first row. Like this:

$row = 0;
if (($handle = fopen($path_to_csv, "r")) !== FALSE) {
    while (($data = fgetcsv($handle, 1000, "\t")) !== FALSE) {
        $num = count($data);
        //echo "<p> $num fields in line $row: <br /></p>\n";
        if($row > 1) {
        
            $sql = "INSERT INTO your_table 
             VALUES ('','".mysql_real_escape_string($data[0])."','".mysql_real_escape_string($data[1])."','".mysql_real_escape_string($data[2])."','".mysql_real_escape_string($data[3])."','".mysql_real_escape_string($data[4])."','','".mysql_real_escape_string($data[5])."','".mysql_real_escape_string($data[6])."','".mysql_real_escape_string($data[7])."','".mysql_real_escape_string($data[8])."','')";
             mysql_query($sql) or die(mysql_error());
            
        }
        $row++;
    }
    fclose($handle);
}

 

Something like that.

This is code which did do that for a site but I haven't checked it. Obviously the number of fields is up to you.

[fenway]

There's a CSV ENGINE type that makes all of this not an issue.

[hybmg57]

Hi fenway,

 

What do you mean by CSV ENGINE type? Sorry I'm a beginner. 

[fenway]

See here.