$file = $this->root_path.'Gsync.csv';
mysqli_query($cons, 'LOAD DATA LOCAL INFILE "'.$file.'"                                 
        INTO TABLE your_table_name
        FIELDS TERMINATED by \',\'
        LINES TERMINATED BY \'\n\'
        IGNORE 1 LINES
        (isbn13,price,discount,free_stock,report,report_date);
Tags: