PHP XLS Report Builder

Job ID: 39979869

Budget: $30 – $250 USD

I need a small PHP 8.2 solution that lets an end-user open a single web page, pick the variables they want, press a button, and instantly download the resulting data as an .xls file.

Core workflow
• Database is MySQL 8.3.
• On page load the script should query the relevant tables and populate two multiselect boxes: Fac and Mod.
• A date picker must allow either one day or a custom range—no extra “last 7 days” shortcuts are required.
• When the user submits, the script runs the SQL, formats the results, and streams the spreadsheet download.

Look & feel
The interface should stay classic and professional: clean lines, neutral colours, no distracting graphics. I only need one page plus any supporting include files.

Header & footer
Every generated report must show my company name and logo, the report title, the run date, and a short custom message. Please place these items in easily editable header/footer sections so I can update wording or branding later without touching the core code.

Config & flexibility
• A single config file should hold database credentials, table names, and any future field changes.
• Header/footer content should live in a separate PHP include or a simple template so I can tweak it quickly.

Deliverables
– PHP page(s) that render the UI, perform the query, and export to .xls
– Config file and header/footer include files
– A short README covering installation, required PHP extensions (PHPExcel or similar), and how to add new fields later

I’m ready to drop this straight onto an Apache/PHP 8.2 server, so please build with portability in mind.