Closed

Page with Charts

This project was awarded to oCoDo for $100 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $250 USD
Total Bids
10
Project Description

I need a page that will draw charts based on data from mysql table.
Data is added to mysql table every 5 minute from a server that dumps his counters to mysql.

i want everything to be done using one of popular PHP frameworks (write your suggestions), so everything can be extended easily later.

It should be login page, and content page with charts.

----------------------
Login page: users can be stored in table, without option of editing them or if you use framework with easy CRUD option, every user can manage users.
----------------------
Content page:
Charts
1 separate chart for every field where X is time from mysql table, Y value of the field.
1 chart with all values of the fields that exists in data table.

so total number of charts - all fields in table + 1 all together

I want a jquery slider selector to select time period something like [url removed, login to view] Pressing to submit button should update charts without refreshing a whole page - I mean AJAX.

For charts any jQuery charts module should be OK, also I accept google charts if it will speed up development and price lowers.

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

MYSQL table is:

CREATE TABLE IF NOT EXISTS `stats` (
`time` mediumint(9) NOT NULL,
`field1` int(11) NOT NULL,
`field2` int(11) NOT NULL,
`field3` int(11) NOT NULL,
`field4` int(11) NOT NULL,
UNIQUE KEY `time` (`time`)
) ENGINE=MyISAM

------------------------
Test data:

For beginning you need to fill table with 1000 values where each time row is 5 minutes less.
field values can be sin,cos,tan,ln - any function that should look good on chart, but of course different functions for every field.

So test data should be
time(), sin,cos,tan, lg
time()-300, sin,cos,tan, lg
time()-600, sin,cos,tan, lg

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

Everything can be done in your server, I check if it works and release a milestone.

Happy bidding!

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