Myself Suraj and I am working on a project which demands below.
I have data in my Oracle database.
I want to make a PHP page which can read this data and create charts. Like a dashboard with multiple charts on the same page.
E.g 10 items are present in database. Everyday I receive some quantities from my XYZ vendor and quantity increases.
So on Day 1 if my quantity is 10 for X item and I receive 10 more on the next day, so my next day quantity will be 20. This part of the database will be directly available from database.
PHP, AJAX and jQuery not sure of the technologies required but in my research this 3 languages seems to be important.
PHP: Design Webpage
AJAX: To create asyn pages
jQuery: To build the charts
So I need two charts which should look like
1. Pie Chart:
If you have 10 items eg. A B C D E F G H I J with quantity 5,5,5,5,40,10,10,5,5,10
So the pie chart should show the proportions right.
2. Bar Chart
This needs to be 2 layered. X axis will be item names layered by 7 days group
This will show in last 7 days item X had so and so quantity.
The Y axis will have number which will denote the numbers
8 freelancers are bidding on average ₹2374 for this job