PHP MySQL Bug Fix & 4 Features

My PHP + MySQL site throws two display errors whenever the server runs in ONLY_FULL_GROUP_BY mode. I need those queries refactored so the affected data shows up correctly on the main page without disabling the SQL mode.

While you are in the codebase, I also want to give users the option to hide or reveal the left-hand navigation. A smooth slide-in / slide-out animation is ideal; no page reloads, just a neat JavaScript or CSS transition tied to a simple toggle icon.

Implmenation of Comparison table comparing data/percentage from two years (2 columns)and a third column showing the difference (Sample table design will be provided)

Finally, I would like an admin-only dashboard that records every login event. The log has to capture the timestamp, the username, and the visitor’s stored location, then present that information in a clean searchable table behind an /admin/access-log route.

Implement a download to Excel funcation to downlad data from a table


I will test locally under ONLY_FULL_GROUP_BY and review the new admin page; if everything renders correctly and the toggle works across the latest Chrome, Firefox, and Edge, the job is done.