PHP MySQL Bug Fix & 4 Features

@Microlent

Hello Aaron S., I am Dr. Rajesh Rolen, PhD in Computer Science & Engineering, with experience of over 20+ years in Frontend Development, PHP, Web Development, JavaScript, MySQL, Backend Development, CSS, HTML, AJAX As a preferred freelancer in the top 1%, I have done 400+ projects here on freelancer.com, I have 4.9 ratings out of 5 on average, which showcases my quality of work and timely delivery. Key Highlights: - Free Hosting Support on the Cloud or any desired platform. - Free 3 months of post-delivery support to ensure that our client doesn’t face any challenges after the launch of the project. - Free Dedicated tester on projects to ensure quality delivery, so clients don’t need to act as a tester. - 10+ Years experience UI/UX team to ensure intuitive UI. Portfolio: https://www.freelancer.com/u/Microlent Please open the chat and send me a message, so we can have a more detailed discussion about the project to give you the project timeline and cost. Thank you for considering my services. I look forward to engaging in a productive conversation and understanding how I can be of assistance in bringing your project to life. Regards Rajesh Rolen

@asifchaudhry2015

Hi there, I can refactor your PHP + MySQL application to correctly support ONLY_FULL_GROUP_BY mode—rewriting the affected SQL queries so the data displays properly without disabling SQL mode. I am really interested to start this project for you. I would like to discuss in detail. Kindly drop me a message and discuss more with me. Thanks

@OutsourceMan

With 18 years of web development expertise, my team at CnELIndia offers a well-rounded skillset for your PHP MySQL project. We can address the display errors arising from ONLY_FULL_GROUP_BY mode - effectively refactoring the queries to ensure correct data representation without compromising the SQL mode. Our proficiency extends to crafting robust solutions that seamlessly integrate databases and improve site performance. The implementation of the comparison table and admin dashboard are equally within our capabilities. Our finesse with data handling using MySQL ensures we can create intricate tables like the sample one you described with ease. Furthermore, our expertise could equip your admin page with a secure login event recording system accurately storing timestamps, usernames, and visitors' locations. Lastly, as a bonus, we can implement an easy-to-use download to Excel functionality for any table on your site. So analyzing those figures or sharing data becomes a breeze for you and your users alike. I'm confident we can surpass your expectations in delivering an integrated product that ticks all four boxes you seek. Looking forward to making this project a smashing success!

@idefcoinfotech

Hi there, I have a few questions based on the shared description: 1) Can you share the two queries that fail under ONLY_FULL_GROUP_BY? 2) Do you have a preferred design or style for the comparison table and nav toggle? 3) Should the Excel download include all table data or only filtered/search results? Your PHP + MySQL queries can be refactored to comply with ONLY_FULL_GROUP_BY without losing the aggregated data, ensuring correct display on the main page. I can also implement a smooth, JavaScript/CSS-based toggle for your left-hand navigation, a comparison table for year-over-year data, an admin-only access log dashboard, and Excel export functionality for your tables. With 8+ years of experience in full-stack web development, I focus on reliable, maintainable, and cross-browser-compatible solutions. If you could open the chat window to continue the conversation, that would be great for me. Warm regards Idefco Before we discuss the project, please note that the price is a placeholder only.

@gauravgargcs

Hello, Hope you are doing great, i can be of great assistance to your project as an experienced PHP and MySQL developer. I have encountered and resolved similar issues related to SQL mode, thus fully capable of tidying up your codebase while ensuring the data is displayed correctly - without changing the SQL mode. I value a clean and efficient site just as much as you do. Moreover, my proficiency in AJAX, JavaScript, and CSS makes me the perfect fit for implementing a smooth slide-in/slide-out animation for users to toggle the left-hand navigation. Modern design principles dictate seamless user experiences without disrupting page loads, and I am confident in my ability to deliver exactly that. With my focus on quality work, timely-delivery garnished with consistent communication at all stages of work process - your project is my priority! thank you Gaurav D.

@installerpoint

As a seasoned web developer and data expert, I understand just how crucial it is to ensure that all data displays accurately on your site. With my proficiency in PHP and MySQL, I'll not only fix the errors you're experiencing but also ensure that none of the main functionality is compromised. Having worked on numerous bug-fix projects in my 7 years of professional experience, you can rest assured that your site will be fully optimized and custom-tailored to meet your unique needs. In addition to fixing the SELECT queries, I am well-versed in HTML, JavaScript, MySQL, and PHP - hence fully capable of implementing the three requested features. Regarding the comparison table function, I will diligently abide by your sample design and apply dynamic mathematical logic to display data across two years while computing the percentage difference for each data point. For the admin log feature, I can effectively integrate simple yet sophisticated login/logout system that perfectly captures all required user data. Regards, M Adeel,

@kamran2012

Hello, I can definitely help with that! I've dealt with ONLY_FULL_GROUP_BY issues plenty of times and know exactly how to refactor those MySQL queries without breaking your data display. The navigation toggle with smooth animations is straightforward, and I'll make sure it works perfectly across all browsers without any page reloads. I'll also build that comparison table with the year-over-year data and percentage differences, plus set up the admin login tracking system with searchable tables and Excel export functionality. Everything will be tested thoroughly under ONLY_FULL_GROUP_BY mode before delivery. Questions: – Are the problematic queries related to aggregation functions like COUNT or SUM that need proper GROUP BY clauses? – Should the login tracking capture additional details like IP address or browser information beyond username and location? Excited to bring your vision to life. Thanks and Best regards, Kamran

@ykarora26

Hello there I have extensive experience using PHP with WordPress to deliver high-quality websites and custom solutions. Over the years, I’ve built, customized, and optimized WordPress projects where PHP played a central role. My PHP & WordPress Experience: - Custom Theme Development: Building responsive WordPress themes from scratch using PHP, HTML, CSS, and JavaScript. - Plugin Development: Creating and customizing plugins in PHP to extend WordPress functionality and integrate third-party APIs. - Hooks & Template Customization: Leveraging WordPress hooks (actions & filters), template hierarchy, and custom post types to tailor websites as per client needs. - Database Optimization: Working with MySQL via PHP to create optimized queries and improve site performance. - WordPress REST API: Extending and customizing the REST API using PHP for seamless integrations. - Troubleshooting & Maintenance: Debugging PHP errors, fixing plugin/theme conflicts, and resolving 500 Internal Server Errors. By combining my PHP expertise with deep knowledge of WordPress, I ensure the delivery of secure, scalable, and efficient websites tailored to business goals. I’d be happy to discuss how I can apply my PHP + WordPress expertise to your project. Best regards,

@divumanocha

Hello, I came across your project and found it truly interesting. With over eight years of hands-on experience in this field, I have successfully delivered high-quality solutions to clients worldwide. My dedication to excellence is reflected in the 180+ positive reviews from satisfied clients. I’d love to bring this expertise to your project and ensure outstanding results. However, I do have a few important points I’d like to clarify to align perfectly with your vision. Let’s connect via chat, where I can also share relevant examples of my past work. I'm looking forward to hearing back from you! Best Regards, Divu.

@Friends4it

Hello Aaron, I understand you're facing display errors with your PHP + MySQL site due to the ONLY_FULL_GROUP_BY mode. I'll refactor the problematic queries to ensure all data appears correctly on the main page without toggling SQL mode. Additionally, I will implement: - A smooth toggle for the left-hand navigation using CSS/JavaScript. - A comparison table for data across two years, highlighting differences. - An admin dashboard to log login events with a searchable table. - An Excel download feature for easy data export. I'm confident in delivering this within your testing parameters. Let's discuss this further! What is your preferred timeline for completing these updates? Thanks, Muhammad

@seefattechnologi

SURE, I will fix the bugs and add the fetaures as per the given description ----------------->>>I have extensive experience with similar PROJECT ---->>I am highly qualified to do this job with high QUALITY ----- I am Passionate PHP/Full stack developer having rich experience with so many successful Tasks. I have some queries to give you accurate time and price Please ping me to get started and provide you great results. Thanks

@freshjah

I can confidently complete every part of this project to your exact requirements. I have deep experience with PHP, MySQL, and modern JavaScript, so fixing the ONLY_FULL_GROUP_BY query errors without disabling strict mode will be straightforward. Beyond resolving those issues, I’ll ensure the navigation toggle is smooth, responsive, and user-friendly, and the comparison table both accurate and visually clear. On the backend, I’ll implement a secure, admin-only dashboard that records logins with timestamps, usernames, and locations, all searchable and easy to manage, along with a polished Excel export function. What sets me apart from other candidates is my focus on precision, security, and maintainability: you’ll get solutions that not only work now but are also cleanly written, well-documented, and easy to extend in the future. You won’t need to worry about hacks or quick fixes I’ll deliver a reliable upgrade that you can trust. I would also like to initiate a quick chat with you. I believe I have other things to discuss with regards to optimizing your site.

@OmarFarukBD

I AM NOT LIKE OTHER 99% OF SELLERS. YOU WILL PAY ONLY AFTER THE WORK IS COMPLETE, AND I ONLY FOCUS ON EXPLAINING WHAT I UNDERSTAND. PLEASE READ IT. I am going to start your project right now. As an expert in PHP + MySQL, I will refactor your queries to run cleanly under ONLY_FULL_GROUP_BY, add a smooth slide-in/out toggle for the left navigation, build a comparison table with year-over-year data/differences, and create an admin-only access log dashboard with timestamps, usernames, locations, search, and Excel export—fully tested on Chrome, Firefox, and Edge.

@vashishtrupinder

Hi , Thanks for sharing all the details. Just to confirm — I will ask for the payment before you test the updates on your side. After payment, I’ll send you the full updated code. You can then check that everything is working, including: Fixed SQL errors for ONLY_FULL_GROUP_BY Smooth toggle to show/hide the left menu (no page reload) Comparison table with data from two years and difference Admin page with login logs and download to Excel option Please let me know if that works for you. Best regards,

@SBITServices

Hi, I have extensive experience in PHP and MySQL development and can help fix the display errors caused by the ONLY_FULL_GROUP_BY mode. I will refactor the queries to ensure the data displays correctly without disabling the SQL mode. Furthermore, I will implement the left-hand navigation toggle feature with a smooth slide-in/slide-out animation using JavaScript or CSS transitions. I will also create a comparison table with data from two years and a third column showing the difference, as well as an admin dashboard to log login events. Let's discuss further to finalize the details. Regards, Sai Bhaskar

@einnovention

With over 10 years of experience, my team at Einnovention has been delivering high-quality web development projects to clients worldwide. Our extensive skillset in Backend Development, CSS, Frontend Development, HTML, JavaScript, MySQL, PHP is a perfect match for your PHP + MySQL bug fix project and the additional features you require. In regard to your bug fix requirements, we have deep expertise in identify and refactoring problematic SQL queries to maintain strict SQL modes like ONLY_FULL_GROUP_BY without affecting data integrity or quality. Moreover, our proficiency in JavaScript and CSS will ensure the smooth slide-in/slide-out animation feature you desire. For the comparison table you mentioned we have worked on similar requirements prior thus this is somthing known to us and We would be able to quickly implement it to meet your specifications. And when it comes to the admin-only dashboard with a clean and searchable table capturing login events - this is something we have done multiple times before, so no problem there. Lastly, our experience with different APIs including Google API would be a great advantage in implementing the download-to-Excel functionality from a table. Not only do we pay meticulous attention to every detail but also offer unlimited revisions until you are satisfied with the final result.

@Rekhathakur

Hello, At WellSpring Infotech, we understand the urgency and importance of solving unexpected bugs that can bring your site to a screeching halt, like the two errors you're experiencing due to ONLY_FULL_GROUP_BY mode. With our technical prowess in backend development and proven proficiency in optimizing MySQL queries, we are confident in our ability to refactor those queries without disabling the SQL mode, ensuring your site's functionality remains intact. Moreover, our expertise extends beyond just bug fixes; we are adept at enhancing user experiences and providing innovative solutions. Implementing a smooth slide-in/slide-out animation to toggle left-hand navigation is well within our capabilities. Similarly, we'll deliver a dynamic comparison table comparing data/percentage from two years with an additional column showcasing the difference, exactly as per your sample design. Towards strengthening your admin capabilities, we can assure you an advanced access-log dashboard that records every login event while maintaining data integrity and security. Additionally, we'll incorporate an efficient download-to-Excel function for table data. The use of robust technologies like PHP, HTML, Javascript and MySQL combined with our dedication to comprehensive project management mean you can expect seamless execution and exceptional quality that will stand up to rigorous testing Thank you

@mannanmaan1425

Hello Aaron S., I have read the project details and understood the overall requirement. I am Abdul, a web developer with 5 years of experience in PHP, JavaScript, AJAX, CSS, MySQL, HTML, Backend Development, Frontend Development, and Database Management. For your project, I will refactor the queries causing display errors in PHP + MySQL without disabling ONLY_FULL_GROUP_BY mode. Additionally, I will implement a smooth slide-in/slide-out left-hand navigation feature using JavaScript or CSS transitions. I will also create a comparison table displaying data from two years with a third column showing the difference, as well as an admin-only dashboard to log login events and a download to Excel function for table data. You can view my portfolio here: https://www.freelancer.com/u/mannanmaan1425 Please ping me back so we can discuss the project further. Best regards, Abdul

@Webtechfusion23

✅ PHP MySQL Bug Fix & 4 Features ➡️ Facing issues with SQL mode and need enhanced features on your PHP + MySQL site? ⏺️ I can refactor your SQL queries to correct display errors in ONLY_FULL_GROUP_BY mode, ensuring your main page data is accurate and compliant. Additionally, I will implement a JavaScript/CSS-powered slide-in/out animation for the navigation toggle, enhancing user experience without page reloads. ➡️ For the comparison table, I will create an intuitive layout displaying yearly data and differences, based on your design. The admin dashboard will track and present login events in a searchable format, and I will add a functionality to download table data to Excel for administrative ease. ### Lets enhance your sites functionality and user interface! ➡️ Here are some of my relevant projects: ✅ SQL Query Optimization ✅ Dynamic UI Enhancements with JS and CSS ✅ Efficient Data Display and Reporting ✅ Secure Admin Dashboard Development ✅ Data Export Implementations --------------------------------- Waiting for your response in chat! Best Regards, Aftab Ahmad ---------------------------------