Sync my Office 365 Excel sheet to MySQL with PHP 7.x
Budget: €30 – €250 EUR
I need someone to write a PHP script to sync my Office 365 Excel Sheet into a MySQL table. The Access is via public file share link. The table fields are not named the same, so it needs to be matched via a simple array in the script I can edit (Fieldname_File => Fieldname_Database). The insert should not be hard-coded as the fields can change in naming, order and count any time. If a row already exists in MySql table, it must be updated, not insert again. The script needs to be run by console, not webserver. For database communication only use build in PHP mysqli object.