Using PHP/MySQL create an upload tool where you can upload an Excel file (see attached examples) and process it and store it in a MySQL database. Then using PHP display the data dynamically so you can view it by country or market.
Looking at the attached .ZIP file:
1) the "html" folder contains what I want to output html to look like pulled from the database. There is an upload.php, by_procedure.php and by_market.php page as an example that should be populated from the database.
2) the "data" folder contains the data to be uploaded. This is just a small segment. There are 32 total countries and 12 total markets. (I'm only giving you 3 markets from Japan and 3 markets from India as a sample)
3) When making the database architecture and storing the data, please do it in a way to make it as dynamic as possible so in the future I can compare the data by country/procedure. For example, it would be cool to compare the Stereotactic Radio Surgery procedure "Intracranial SRS Procedure" in Japan to that in India side-by-side (along with any country that has Intracranial SRS as a data point). In the Excel files I have marked in yellow the fields that I would like to be able to compare by Country
In short, create an upload script to take the Excel tables in the "data" folder and save it to a MySQL database, then display it by country or market as seen in the "html" folder. When viewing the data displayed as HTML, you should able to export any individual table/exhibit as a .xls file
April 7, 2018
I am looking for freelancers with the lowest rates