Web Developer

Hello , 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. PHP, Javascript and CSS are the only core tools I want you to use for this demonstration of your skill set. Using PHP or Javascript frameworks is highly encouraged. For the user interface functionality I would like you to use HTML, Javascript and CSS. Showing your skills with Angular JS (Google's Javascript framework) or SASS (a CSS framework) would be advantageous. ================ PHP Requirements ================ I would like to see you use PHP to select data from a mysql database table (see included [login to view URL]) and produce a JSON view of this data. Your javascript application will consume and display this data according to the "Javascript Requirements" section below. 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. ======================= Javascript Requirements ======================= Once you have created the JSON web service to consume you should build a javascript application from the following requirements.. 1. Consume the above web service and make the JSON string returned available to local Javascript. 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. 4. Create a graph using a Javascript graphing tool that sits above the HTML table on the page and shows the number of customer sign-ups per year (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. ========= Submit It ========= 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. Thanks