Construisez un site Web

Project : Display stats with PHP MySQL I need to display few stats from MySQL database tables. This is a test site exercise for "Car rental" (hiring cars). So we have the following tables in database: ------------------------------------------------------ - members (people should signup in order to rent a car) - cars (all cars that will be use in table "products") - products (we create a product with different existing cars) - comments (site members can rate cars from 0/10 up to 10/10) - orders (summary of all orders) Here are the stats we need to display: ------------------------------------------------ - Top 5 hired cars - Top hired car (only one car) 1) Top 5 rated cars (Note that each car can be rated many times. So you will need to get the average rate in this case!) 2) Top rated car (only one car) 3) Top 5 regular clients (people who rent more cars) 4) Best regular client (Only the best client (1person) who buys more) 5) Top 5 clients who spend more money (here we pay attention to the amount of money they spend. They may buy few times buy height prices) 6) Best money spending client (the person who paid more money) 7) Daily signup stats using Google charts (display in a Column or line Chart). You are free to add (date for table "members if needed") 8) Sales evolution stats using Google charts. Display how much sales we made per day (from table "orders"). Here it's not a matter of money but counting how many orders we get every day. 9) Net daily affair stats using Google charts. Display how much money we made per day. So we need to count all orders we made every day. Requirements: ------------------ - You should code ONLY with "PROCEDURAL PHP" !!! NO object oriented code or any other framwork !!! - Use mysqli or PDO queries (NOT the deprecated mysql_query()) - You should comment your code verywell. - Stats should be coded and displayed in separate files. (See provided site pages) Provided materials: ------------------------ - Simple php siles on which you will displays stats. - Site databse This project is very urgent, we need it to be done very quickly. If you have questions, please ask before you submit you bid. Regards.