Simple script: Display data from MySQL into HTML (PHP, RoR)
$30-250 USD
进行中
已发布将近 13 年前
$30-250 USD
货到付款
----------------
** Background **
----------------
This project is designed to demonstrate the amount of time (in hours) spent on 2 Australian blogs, popular in the media & advertising industry.
The data comes from Nielsen site tracking data, which we scrape and insert into a MySQL database (via a Ruby script running on a cron job).
The presentation of this data is required to display the total hours, total number of unique visitors, and total cost (hours + $200/hr) for advertising professionals in Australia.
------------------------
** What we'll provide **
------------------------
1. A design / wireframe (file attached: [login to view URL])
2. Access to the MySQL database, containing the required data
3. Access to a PHP webserver to host the script on
------------------------
** Server Environment **
------------------------
We have PHP and Ruby on Rails (2.x) hosting available (see Dreamhost for specs).
We don't have .NET hosting, so this script can't be in .NET
------------------------
** Database Structure **
------------------------
DB Name: Adwaste
Table: Visits
Columns:
Date - Date (in text format) of the daily visits data
ub - "Unique Browsers" each day
tt - "total time", in '000s of seconds. So, 3450 is 3,450,000 seconds (958.33 hours)
site - Either "mumbrella" or "cb" (campaign brief)
-------------------
** REQUIREMENTS **
-------------------
* Develop a HTML page, using whatever web programming language you prefer, that accesses a MySQL database and produces calculation of total hours spent on two websites.
(see wireframe mockup)
NB: Filter checkboxes and radio boxes, when changed, will updated automatically, without pressing a button (using javascript or whatever).
1. Checkboxes will include values from the database field:"site", if checked. If unchecked, the calculation will ignore the values from that site.
Default is both checked.
2. 3 Fields, radio boxes:
* Yesterday - pulls most recent daily data in the database. Doesn't need to be yesterday in all cases, sometiems the data will come in late, but we'll still refer to it as "yesterday"
* Last week: Combine the last 7 days worth of values in the field "tt", and divide by 3600, to give total hours spent in past 7 days.
NB: When "Last Week" or "All Time" is selected, the Note #5 "invested by XXXXXX people" will NOT be shown. This is because we don't have accurate weekly visitation data. In the case of "Last Week" or "All Time" radio button selected, the text at Note #4 should only read: That's XXXXXX hours
* All time: Adds up ALL the fields "tt" and divides by 3600.
3. Dollar value - this is the number of seconds in the field "tt", multiplied by 1000, then divided by 3600, to give hours. The number of hours is multiplied by 200, to give a cost.
Algorithm: (tt * 1000 / 3600) * 200 = $
4. The XXXXX is total number opf hours using the selected filters. So either the single day's "tt" value * 1000 / 3600, or the total of the amount of "tt" values, * 1000 and / 3600.
5. Note: this part doesn't appear if "Last Week" or "All time" are selected
6. "Twitter This" button should link to [login to view URL]!%20http%3A%2F%[login to view URL]%2Fadblogcost%20HT%20%40maxusAU
the XXXXX should be replaced with up to date figures, changing each day.
-------------------
** Deliverables **
-------------------
* unobfuscated code and all required libraries, with instructions for install if required.