temp_table

A quick and easy tool to import a spreadsheet as a table in a MySQL database.

I created this tool because i often needed to quickly add data to my DB provided by clients in spreadsheets.

Works with most spreadsheet formats including CSV & XLSX

How To use:

1. First update db.php with your database's login info. (lines 4-7)
2. Launch index.php on your server
3. Browse for your spreadsheet file & Upload
4. Your Done! your new table is ready to use.

HOW TO VIDEO HERE:

https://www.youtube.com/watch?v=Y7BGZopgHJ4

---

This tool's functionality for reading the spreadsheets is based on the PHP Excel Repo (I know its deprecated but i already have this working so i'm using it.) https://github.com/PHPOffice/PHPExcel