This may be your first PHP review

  • Status Completed
  • Budget $2 - $8 USD / hour
  • Total Bids 20

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.

-------------------------------------------------------------------------------------------

Get free quotes for a project like this
Completed by:

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online