I am trying to make an HTML form so my users can upload xlsx files ,and the PHP parse xlsx,show results to user and then user can confirm and insert data automatically to mysql and show success msg.
I already can upload the file to my folder on host,also i found the way to parse the file,but i cant do it all together automatically. I focus more on the SimpleXLSX https://www.phpclasses.org/package/6279-PHP-Parse-and-retrieve-data-from-Excel-XLS-files.html
There are lots of answers on forums but each of them just answer a part of question i cant handle to compile them running.some of them included blow Upload and insert xls file to mysql? https://www.phpclasses.org/blog/post/571-php-xlsx-mysql.html