Insert Excel file into MySQL database using PHP

This Video is about, How to Upload an XLSx / excel file and insert it into MySQL Database with dynamic table name and field(column) name using PHP.
Creating an Excel file with Microsoft Excel.
Creating a PHP script for Inserting that Excel file into MySQL Database.

Introduction about simple XLSx Library

XLSX Reader Library

Code available here :

Previous videos about CSV

Basic Login System

[Kalot_tv]

Good Nice Its helpful keep up the good deeds my friend

[MdHasan-pgsx]

Thanks you so much! upload more Tricks.

from Bangladesh!

[matheshrx]

Great tutorial. just struggled to modify the code to enter only data in existing table instead of creating a new table and inserting in it, Thanks sir

[Instructors-tube]

Thank you very much I have solved my problem

[sevenadams]

Great video. Is it possible for one to write a php code that will upload a csv file and import it to mysql database as it is, without having to first read and manipulate the contents of the file because the file can have upto 15 rows and 48 columns?

[erictan]

Anyone can help me, i not sure why my last row in my excel sheet will be save duplicated on phpMyAdmin side

[tanzeelurrehman]

Function rtrim is not working to remove comma ", "

[buzzolol]

For some reason if i add another column on excel dont work anymore

[hhaneya]

My columns are not all of type varchar(50). I have 2 int(255) and 2 varchar(120) and the primary key is auto-increment. How can I implement that in my code? Thank you

[abrudeandenisa]

I have this error
Uncaught Error: Class 'SimpleXLSX' not found