Suoritettu

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

Taidot: HTML, Javascript, MySQL, PHP, tietojärjestelmäarkkitehtuuri

Näytä lisää: 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

Tietoa työnantajasta:
( 38 arvostelua ) Brugge, Belgium

Projektin tunnus: #19647632

Myönnetty käyttäjälle:

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 Lisää

€250 EUR 3 päivässä
(42 Arvostelua)
5.3

38 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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 Lisää

€500 EUR 4 päivässä
(855 arvostelua)
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 Lisää

€600 EUR 18 päivässä
(166 arvostelua)
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 25 päivässä
(127 arvostelua)
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 Lisää

€500 EUR 10 päivässä
(349 arvostelua)
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. Lisää

€500 EUR 3 päivässä
(242 arvostelua)
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 9 päivässä
(118 arvostelua)
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 Lisää

€250 EUR 7 päivässä
(59 arvostelua)
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 Lisää

€500 EUR 7 päivässä
(91 arvostelua)
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 Lisää

€500 EUR 10 päivässä
(99 arvostelua)
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 Lisää

€280 EUR 15 päivässä
(175 arvostelua)
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 Lisää

€300 EUR 10 päivässä
(54 arvostelua)
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 10 päivässä
(25 arvostelua)
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 Lisää

€500 EUR 3 päivässä
(19 arvostelua)
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 Lisää

€400 EUR 10 päivässä
(17 arvostelua)
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 7 päivässä
(49 arvostelua)
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, Lisää

€250 EUR 7 päivässä
(17 arvostelua)
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 Lisää

€555 EUR 10 päivässä
(11 arvostelua)
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 Lisää

€350 EUR 5 päivässä
(34 arvostelua)
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 Lisää

€500 EUR 10 päivässä
(12 arvostelua)
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 Lisää

€611 EUR 9 päivässä
(5 arvostelua)
4.4