Simple script: Display data from MySQL into HTML (PHP, RoR)


** 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: [url removed, login to view])

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


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)




* 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 [url removed, login to view]!%20http%3A%2F%[url removed, login to view]%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.

Skills: AJAX, HTML, MySQL, PHP, Ruby on Rails

See more: script display data mysql, display mysql data rails html page, late display data html page php, x-site media, wireframe media, when people ignore you, what's algorithm, what ruby on rails, what is the most popular programming language, what is ruby programming, what is data structure in programming, what is data structure in c, what is data structure, what is data in data structure, what is a web script, what is a programming algorithm, what is algorithm in programming, what is algorithm in data structure, what is algorithm design, what is a data structure in c, what is a data structure, what is a algorithm in programming, what data structure, what are data structure, web programming with php

About the Employer:
( 1 review ) North Sydney, Singapore

Project ID: #1117894

Awarded to:


Hello Please see PM for further details

$80 USD in 2 days
(7 Reviews)

9 freelancers are bidding on average $95 for this job


PHP/MySQL expert here. Please contact me!

$250 USD in 4 days
(69 Reviews)

please check your pmb

$199 USD in 4 days
(140 Reviews)

Hi !! I can start rightaway .. please see pm

$70 USD in 3 days
(4 Reviews)

PHP expert.. check pm pls.

$90 USD in 1 day
(61 Reviews)

Hi, tommyk421. I am interested in working on this project. Regards, Ivan Stankov

$120 USD in 7 days
(27 Reviews)

Hello, please check the PM.

$110 USD in 1 day
(4 Reviews)

ready to start..

$100 USD in 2 days
(2 Reviews)

Hello. I have experience coding PHP/MySql scripts. I can complete this project in less than 2 days. Thank you!

$80 USD in 2 days
(4 Reviews)

I'll do this [login to view URL] contact to me.

$45 USD in 4 days
(1 Review)

hi, wil be glad to do it

$55 USD in 5 days
(1 Review)