This may be your first PHP review

IN PROGRESS
Bids
22
Avg Bid (USD)
$5 / hr
Project Budget (USD)
$2 - $8 / hr

Project Description:
We want to display statistics about ads views, per user.

A user posts an ad, then we record the number of times site visitors view that ad daily, in a mysql database (already done).

Here below is the structure of that database :

There are three tables :

Table (1) : Ads {ID_Ad , ID_Usr }

Table (2) : View {ID_Ad , Date , Nb_View }

Table (3) : User {ID_Usr , Name}

TO DO :

- Create an html / php page containing a form of two date fields (to be used to filter search results), and a submit button.
To enter these dates, a jQuery calendar should be used, in a popup.

When submitted, the result should be the number of ads views, per user, between these two selected dates - as displayed in the grid below:


Number of views for each user taken from a mysql database using PHP codes:
---------------------------------------------------------------------------------------------------------
|ID_Usr |ID_Ad1 |ID_Ad2 |ID_Ad3 | ... |
----------------------------------------------------------------------------------------------------------
|Date1 | | | | | |
----------------------------------------------------------------------------------------------------------
|Date2 | | | | | |
---------------------------------------------------------------------------------------------------------
|Date3 | | | | | |
----------------------------------------------------------------------------------------------------------
|Date4 | | | | | |
----------------------------------------------------------------------------------------------------------
... | | | | | |
----------------------------------------------------------------------------------------------------------

- Fill in each cell with the total number of people having viewed this ad, on this date (format m/d/Y);

- Make the total per month, and per year;

- Then plot the result in a graph (like google chart).


If you can do this simple project, then we may hire you for bigger ones.

Thanks.
-------------------------------------------------------------------------------------------

Hours of work: Unspecified Project Duration: < 1 week Skills required:
Graphic Design, MySQL, PHP, Statistics, Website Design
Hire Tulear
Project posted by:
Tulear Madagascar
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$7 / hr
Hours: 3 hr/ week
$10 / hr
Hours: 10 hr/ week
$8 / hr
Hours: 20 hr/ week
$6 / hr
Hours: 10 hr/ week
$5 / hr
Hours: 25 hr/ week
$5 / hr
Hours: 6 hr/ week
$5 / hr
Hours: 15 hr/ week
Hire bobvm
$4 / hr
Hours: 20 hr/ week
$5 / hr
Hours: 10 hr/ week
Hire arundutt83
$7 / hr
Hours: 5 hr/ week