Concluído

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

Habilidades: HTML, Javascript, MySQL, PHP, Arquitetura de software

Veja mais: 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

Acerca do Empregador:
( 38 comentários ) Brugge, Belgium

ID do Projeto: #19647632

Concedido a:

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 Mais

€250 EUR em 3 dias
(42 Comentários)
5.3

38 freelancers estão ofertando em média €464 para esse trabalho

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 Mais

€500 EUR in 4 dias
(855 Comentários)
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 Mais

€600 EUR in 18 dias
(166 Comentários)
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 dias
(127 Comentários)
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 Mais

€500 EUR in 10 dias
(349 Comentários)
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. Mais

€500 EUR in 3 dias
(242 Comentários)
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 dias
(118 Comentários)
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 Mais

€250 EUR in 7 dias
(59 Comentários)
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 Mais

€500 EUR in 7 dias
(91 Comentários)
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 Mais

€500 EUR in 10 dias
(99 Comentários)
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 Mais

€280 EUR in 15 dias
(175 Comentários)
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 Mais

€300 EUR in 10 dias
(54 Comentários)
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 dias
(25 Comentários)
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 Mais

€500 EUR in 3 dias
(19 Comentários)
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 Mais

€400 EUR in 10 dias
(17 Comentários)
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 dias
(49 Comentários)
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, Mais

€250 EUR in 7 dias
(17 Comentários)
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 Mais

€555 EUR in 10 dias
(11 Comentários)
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 Mais

€350 EUR in 5 dias
(34 Comentários)
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 Mais

€500 EUR in 10 dias
(12 Comentários)
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 Mais

€611 EUR in 9 dias
(5 Comentários)
4.4