Completed

Create a line chart and colored bar from mysql database table data

I have a script that checks my external website every minute and stores the info in an mysql DB (date time, http response code and response time )

I need a php developer who can create a dotted line chart from this results and a colored bar (uptime)

Work to be done:

create a php script that connects to DB and generates the line chart default for the last 24 hours

like this with X date time and Y response time, also with high, low and avg calculated

But we need also a dropdown button to select what to show in the chart

- last 24 hours (default)

- this day (starting at 00.00 am)

- last 48 hours

- last 7 days

- last 30 days

- last 70 days

- last 90 days

- last 3 months

- last 6 months

- last 12 months

- this month

- last year

- this year

and a date picker to select a custom range:

- pick date (1 day)

- pick date range (from date to date)

We also need a colored bar with the uptime (error field in the DB (0 = ok, 1 = downtime) with the same date range

And the data must also shown in a table with the same date range

You get access to a hosting account and the Database to work and test.

See pdf in attachment with details and screenshots

Skills: HTML, Javascript, MySQL, PHP, Software Architecture

See more: uploading images mysql database table, read xml file mysql database table, create pdf file info taken mysql database, how to create pie chart in php using database values, chart.js - getting data from database using mysql and java, how to create dynamic bar chart in php or javascript with mysql, how to create line chart in php and mysql, how to create graph in php using database, bar chart in php mysql source code, google line chart php mysql, create bar chart with database values, create form page captures details mysql database, retrieve mysql database display data map, retrieve data mysql database table scroll, convert xml mysql database table, create line chart year monthly sales excel, data fetch mysql database table vb net, insert excel data mysql database table file jsp hibernate, notify client data change mysql database table wcf, sample flex java calling mysql database table

About the Employer:
( 38 reviews ) Brugge, Belgium

Project ID: #19647632

Awarded to:

soumyanildas

Hello there! I have gone through your project description and also the pdf you've attached and I can help you out with this. For this I'll be setting up code in PHP to return the necessary data according to the date pr More

€250 EUR in 3 days
(42 Reviews)
5.3

38 freelancers are bidding on average €464 for this job

uhjk

Hello, I reviewed your pdf file (last sentence is "You get access to a hosting account and the Database"). I can create this one using jquery plugins. I am good with php so I guess I will get this done in 3 days max. T More

€500 EUR in 4 days
(855 Reviews)
8.2
tranngocanh1702

Hi, I am able to develop the script to generate the line chart and colored bar for the period of time. I am ready to discuss and start now. I am Khoa with more than 7 years experience in web and cross-platform a More

€600 EUR in 18 days
(166 Reviews)
7.8
ominfowave

Dear Sir, We are really glad that you posted a project on freelancer. Our skills and experience speak in our freelancer portfolio. Please check and let's discuss. Warm Regards, Om Infowave

€750 EUR in 25 days
(127 Reviews)
7.7
pointlogic

Hello, I have read complete project details and i would like to discuss with your few points . I have good working knowledge of line charts . I have in-depth knowledge of php, mysql, javascript , jquery, payment syste More

€500 EUR in 10 days
(349 Reviews)
8.2
Starlight05

Hello. As a talented Web developer, i have rich experience in database programming, html5/css3, Less/sass/scss, bootstrap, jquery/js, php & software architecture. And therefore very interesting to your project. More

€500 EUR in 3 days
(242 Reviews)
7.8
isensebd

Hello I have well experience working with chart plugins like d3, chartjs and so on. Also worked with live data as well. Lets discuss in details.

€600 EUR in 9 days
(118 Reviews)
6.9
leemilun

Hi, nice to meet you. I have read your post.I am interesting in your project. I am good in web basic skill and i am familiar with some frameworks such as Laravel, Wordpress, Codeigniter, Nodejs and so on. I have been l More

€250 EUR in 7 days
(59 Reviews)
6.5
yuriyes43

Dear, sir I've read your specification carefully and I'm very interested in your job. I have rich experience of developing web projects for 5 years using JS. I ensure high quality and deadline. I would like to have a More

€500 EUR in 7 days
(91 Reviews)
6.8
markninja

Hello, I will develop a line chart and colored bar from mysql database table data but I have questions which I want you to answer. [login to view URL] [login to view URL] I’d really like to More

€500 EUR in 10 days
(99 Reviews)
6.9
junkyfunky

Hello, I've read your project description and I want to tell you that I can create a line chart and colored bar from MySQL database table data for you as per your [login to view URL] have a quick chat to discuss this More

€280 EUR in 15 days
(175 Reviews)
7.2
anatolygenay123

Hello, I have developed several line dot chart, pie chat from the database (mysql). I checked the [login to view URL] file very carefully and am really confident in this job. I look forward to hear More

€300 EUR in 10 days
(54 Reviews)
6.8
oneginaalyona

Hi there. I'm confident in any part of Web development. [login to view URL] https://www.freelancer.com/u/oneginaalyona Promise high-quality and bug-free. Let's make a great experience. Best regards. Alyona.

€700 EUR in 10 days
(25 Reviews)
6.0
braineax

Hi, I've read the description of your developer task and understood the requirements perfectly. I’m an expert in HTML/CSS and can create any layout no matter how complex the design is. I can do changes in the design More

€500 EUR in 3 days
(19 Reviews)
5.7
WebExpert555

Hi, nice to meet you. I am Ruyun and always ready for you. After reading your description carefully, I have convinced that I can complete this project in time perfectly as you want. Because through over 7 years, I More

€400 EUR in 10 days
(17 Reviews)
5.8
shanymathew

Dear Sir excellent in php,mysql , jQuery etc i analysed your pdf i can make this chart based on the conditions perfectly currently am working with lots of graphs like this so its easier for me please contact me

€280 EUR in 7 days
(49 Reviews)
5.0
DianaBorisov

Hi Dear, Nice to meet you. I read your job in carefully and understood your requirements well. I have good experiences in web development using PHP, Laravel, WordPress, HTML5, Bootstrap, JS(JQuery, Node.js,Angular.js, More

€250 EUR in 7 days
(17 Reviews)
4.8
sevenstarservice

Hello, I'm a full time freelancer and am free now. I have read your project description I am very interested in this project. I have a lot of experience in this type of work. I'm sure I can complete it on time w More

€555 EUR in 10 days
(11 Reviews)
4.8
aswebsmart

Hi, I have read through your job descriptions, and I understand all of the requirements. I am applying because I believe that I have the required skill set to complete your project. I have been working as a PHP develo More

€350 EUR in 5 days
(34 Reviews)
4.6
AndreiPPB

Hello. I'm very interested your project. The most important thing for me is the client's satisfaction, good result, and high quality. I'm very talented Web developer. if you assign to me this project More

€500 EUR in 10 days
(12 Reviews)
4.7
itbeamtech

we have 7 plus years experience in web & Mobile technology, impeccable technical skills, high quality Standards and references. We provide quality services for Xamrine, Android , iOS and Web technologies( UI, serve More

€611 EUR in 9 days
(5 Reviews)
4.4