Due to a bad experience in past, As part of the hiring a freelancer process I ask all freelancer to give me a small demonstration of the skills.
I request that you build a dynamic web page using open source libraries and tools.
I would like to see you use PHP to select data from a mysql database table (see included [url removed, login to view]) and produce a JSON view of this data.
The URL should be able to take 3 GET or POST string arguments : "firstname", "surname" and "email".
These arguments should be used to limit the results in the JSON output to only include records the search strings match in their respective MySQL database fields.
2. Generate a HTML table from the JSON array that contains all the fields from the database table and displays all of the records.
This table should employ pagination.
3. Create text fields that when typed into, limits the results based on the firstname, surname and email of the member and redraws the table with the limited results.
(this is determined by the joined_date). This can be any type of graph you wish.
5. Create a function that drills into each year on the graph and displays the number of sign-ups for each month in that year.
Please submit the application as a zip file ASAP.
If frameworks and libraries are used please provide instructions for setup and installation on an Apache web server.
Pointing us to setup instructions for any frameworks would be good or alternatively, if the framework is small enough,
include it in the zip file. Using a package manager to install frameworks and libraries (i.e. Composer, Bower)
with instructions on how to use them in your installation instructions would also be a highly valued approach.
I will not pay for the test but if your solution meets my requirements I will hire you and we can work out some agreements.