In Progress

Page with Charts , second try

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!

Skills: AJAX, MySQL, PHP

See more: login page create php, jquery release, google ajax framework, frameworks ajax, easy ajax framework, data pressing, create page google, create table chart, beginning php mysql, ajax frameworks, ajax development framework, sin up, google test speed, google ajax jquery, try, try on, sin, sin cos, page speed, login page, ln, jquery chart, counters, cos, charts

About the Employer:
( 8 reviews ) tallinn, Estonia

Project ID: #1292441