Senior PHP and MySQL developer

We have a web page with 5 Tables where we are aggregating the totals from 4 main categories: Age, Gender, Race, and Zip Code. The web page is already completed, and the HTML is done (no need to do that part). We need a qualified developer who can write the code that points to the right Tables (I will provide you exactly where to find the data) and total the numbers in each field. In one Table called Zip Code, it lists all 50 states, and your job for this Table and all other Tables, is to count the Total Number from our database that live or work in a particular state and the % of the grand total of our members. We currently have approx. 3,000 members, so if 30 of our members live in Alabama, for example, the field with the header # will show 30, and the % column will show 1%. There are 28 total columns in 5 Tables, where 16 columns are exactly the same and duplicated info, for example, Total Number of Members appears in every Table (except one) and the same 3,000(?) will appear the same throughout. I will show you where to find that info in the Tables. Each Table will have a Total row showing the totals and percentages. Although the HTML page shows a Print button, we want to deactivate or show in a gray color that it does not work and not useable. The Export button will export the exact table and look exactly the same in an exportable Excel file as it does on the web page, including background colors, fonts, etc. There is one button called Export all tables to excel, which basically means if the admin selects this feature, then all of the Tables will export to one Excel spreadsheet. Loading: we want the web page to load quickly so whatever you need to do to make sure that this page generally loads either in the background or with some other programming trick. We do not want the main file we are using to display this page to be the same file so please you a class system that is part of our overall class design where all the work and coding is actually done. Our current directory looks like: member > admin > classes (this might be where [login to view URL] might go) member > admin > content (this might be where [login to view URL] goes) member > admin > css member > admin > fonts member > admin > images member > admin > js (this might be where [login to view URL] goes) In terms of design, there should be no deviation from the HTML page – so whatever the final development is finished, then it will look exactly as it does before you started the work. You will be working on a “Demo” website with limited access to server, but we can discuss how we can do this.