Completed

This may be your first PHP review

This project was successfully completed by iampatel0289 for $2 USD / hour in 3 days.

Get free quotes for a project like this
Employer working
Completed by:
Project Budget
$2 - $8 USD / hour
Completed In
3 days
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.
-------------------------------------------------------------------------------------------

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