how to import data from excel to mysql using php

Thanks~~ I tried many times to work with this code. Finally it works!
Tested in
PHP 5.6.36 Bitnami APM

can i install without composer?

hey can yo make it on codeigniter??
i try to get read when i upload file but not workiing

Good job! Very clear!

give source code

Pls Help! Error in
line 39: $xx= "'" . implode( glue: "','", $sheetData[$row]) . "'" ;


error message: Parse error: syntax error, unexpected ':', expecting ',' or ')' in C:\xampp\htdocs\demo\samples\Reader\05_Simple_file_reader_using_the_read_data_only_option.php on line 39

I have an Excel spreadsheet that has various data types including start dates, using this method will it import the dates from Excel in the correct format?

Thanks

I have got a problem that 'Column count doesn't match value count at row 1'
but my sql statement is start from row 3. What's happen to it?

too many ads

Your tutorial would have been the best if you first select the file from input and then work with it, but anyway it's OK, thanks for it

very good

how to use date with this case