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:
( 41 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
(46 Reviews)
5.4

36 freelancers are bidding on average €472 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
(902 Reviews)
8.3
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
(276 Reviews)
8.0
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
(171 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
(129 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
(353 Reviews)
8.2
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
(101 Reviews)
7.0
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
(119 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
(191 Reviews)
7.3
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
(123 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
(75 Reviews)
7.1
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
(90 Reviews)
6.7
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
(30 Reviews)
6.2
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
(37 Reviews)
6.4
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
(31 Reviews)
6.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
(39 Reviews)
5.8
zpedia723

Hello, how are you? My name is Fengshu L. I have read your description very carefully and it was interesting. I have developed WebSites for over 5 years and have good design senses. Especially, I am familiar More

€250 EUR in 10 days
(29 Reviews)
5.5
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
(21 Reviews)
5.3
whiteeagle0001

Hello,How are you? I have read attached file. I can do it.I have read your description in more detail and have much interest in your project. So I think that I can finish your work perfectly as you need.I have many exp More

€500 EUR in 10 days
(22 Reviews)
5.2
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
(50 Reviews)
5.0
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.7