PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
Is there a way to create a PHP script so you can export data from excel into a mysql database,
or is there a better solution, maybe directly export data from excel into a db?
There's a couple of methods. The first, and arguably easiest, is to export the data from Excel as CSV or TSV data and import that using phpMyAdmin or SQLYog or something.
Alternatively you can connect to an Excel file using PHP's ODBC functions. It's not a great interface though.