Dynamic HTML Table with AJAX/PHP

I am in need of a unique, neatly structured HTML table that mimics the functionality of Excel. The table should consist of both rows and columns, with particular attention to two columns that will feature dropdown lists. Here are the specifics:

– Dropdown Lists: Two columns should consist of dynamic dropdown lists, filled with data from a MySQL table. As this question wasn't elaborated further, I assume the functionality should include: expanding on click and selecting an option from the list.

– Additional Columns: The other column fields should showcase an auto-increment number and a date field.

– AJAX/ jQuery/ JSON: Ensure the select option within the table operates effectively using AJAX, jQuery, and JSON in PHP and MySQL.

– Total Calculations: I require the table to automatically calculate and display the total amount at the bottom.

The task is personal in nature, and I am hopeful for completion as soon as possible. The ideal freelancer for this project will have strong experience in PHP, AJAX, jQuery, HTML, and MySQL. An in-depth understanding of creating dynamic content and making calculations with JavaScript is vital.

PHP AJAX MySQL JavaScript jQuery / Prototype

Project ID: #37765383

About the project