Create simple 4 page web site to present database data in fusion chart and table
$100-250 USD
Cancelled
Posted about 13 years ago
$100-250 USD
Paid on delivery
Summary
======
Create a simple four page web site to display data from a database in a bar chart using fusion charts and a tables using javascript. The data will be generated as json using php. See detailed requirement below.
The Requirement
===============
Please view the diagram diagram [login to view URL] in attached [login to view URL]
1. Create a postgres 8.x database called salesdata from the included database [login to view URL]
2. Create a php file [login to view URL] that reads the query "select region, sum(sales) from salesdata group by region" from the database
3. render the data set as json that can be read by a fusion chart bar chart.
4. Create a basic html page calls [login to view URL] (note .. this is *NOT* a php page)
5. Add a barchart form fusion charts that reads the json data generated in 3.
6. Make sure the user is able to click on one of the bars and open another web page to show the detail for that bar.
7. the name of the basic web page will be [login to view URL] and the link to open it will be for example [login to view URL]
8. create a php file calls salesdatadetail.php. This will read the query for the selected bar e.g north = "select city, sales from salesdata where region = 'north'"
9. Out put the data as json.
10. using javascript read the json data and create a table in the [login to view URL] file
Notes
=====
1. Only create the files that are described in the Requirement above.
2. Ensure the code will read postgresql database.
3. Use php5.x
4. do not use any other libraries or frameworks unless agreed - keep it vanilla.
5. Only use fusion charts [login to view URL] - you can download a dev version from their site.