how to import data from excel to mysql using php

[@iamzero0000]

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?

[@dashbyictfd]

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

[@글쓰는개발자]

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

[@Webeasystep]

you are welcome ,Great News

[@DavidAshby1]

I have got to the stage where you are testing, 11:00 but when I try to view via the browser I get
Fatal error: Uncaught Error: Class 'PhpOffice\PhpSpreadsheet\IOFactory' not found in C:\xampp\htdocs\davidssite1\demo\samples\Reader\05_Simple_file_reader_using_the_read_data_only_option.php:10 Stack trace: #0 {main} thrown in ........
I understand it as saying it is not finding the IOFactory but I have not deleted or moved any files. Everything was installed successfully going by your previous steps, can you advise please?

[@anoundhim4393]

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

[@barbarazavaleta5264]

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

[@plamenvladimirov3121]

Good job! Very clear!

[@computadorhumano949]

very good

[@bagasnuralim7679]

how to use date with this case

[@bagasnuralim7679]

i have problem when can use type of date

[@bagasnuralim7679]

can you help me

[@faridariamaulana2670]

can i install without composer?

[@fitriizuanabdulronie5228]

ya wanna know too... I am not using any framework

[@ASK2GURUJI]

give source code

[@Justwavy09]

Did you ever get the source code?

[@yudadesela4781]

too many ads

[@barbarazavaleta5264]

JUST INSTALL ADBLOCK FROM GOOGLE