Looking for an experienced PHP and MySQL expert. If you also know some AJAX that is a plus.
I have a MySQL database with three tables of data. One table is customers, one table is purchases, and one table is sales agents. These tables are already populated with data.
I need a web page made with various queries I can run on my database that will display the results of the queries in a table on the page.
For example I might want to be able to find customers who have more than 3 purchases, or customers who purchased within the past 2 months, etc.
On the web page displaying the results I must be able to sort by each column of data by clicking the column header, and I must be able to customize some of the queries by entering the query criteria.
When the results from a query are displayed on the page there needs to be check boxes next to each row and an option to select or deselect all results. I need to be able to do two things to the results with are checked.
The first thing is to select some or all of the results with the checkbox and assign a sales agent (from the sales agent table of the satabase) to contact the customers. This should permanently assign a sales agent to those customers.
The second thing I need to do is to select some or all of the query results with the checkboxes and generate a comma seperated values (.csv) file for download containing all the data from the selected customers. I need to know which customers have been exported to .csv files and on what date so when this export is done it needs to update a table in the database showing they have been exported.
I will supply you with the table structure for my database, but you must build the web page and queries on your own test server. I will not give you access to my cpanel or directly to my database. When the project is complete you will just need to show me where in the code to insert my database name and password etc. and I will implement it on my own server.