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

Completato Pubblicato 4 anni fa Pagato alla consegna
Completato Pagato alla consegna

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

HTML JavaScript MySQL PHP Architettura Software

Rif. progetto: #19647632

Info sul progetto

27 proposte Progetto a distanza Attivo 4 anni fa

Assegnato 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 Altro

€250 EUR in 3 giorni
(56 valutazioni)
5.8

27 freelance hanno fatto un'offerta media di €473 per questo lavoro

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 Altro

€500 EUR in 4 giorni
(1050 valutazioni)
8.4
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. Altro

€500 EUR in 3 giorni
(277 valutazioni)
8.0
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 Altro

€500 EUR in 10 giorni
(353 valutazioni)
8.2
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 giorni
(138 valutazioni)
7.8
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 Altro

€600 EUR in 18 giorni
(182 valutazioni)
7.9
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 giorni
(125 valutazioni)
7.0
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 Altro

€500 EUR in 7 giorni
(109 valutazioni)
7.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 Altro

€500 EUR in 3 giorni
(45 valutazioni)
6.8
TechnicalKnight

I will set up a cron job which can give insight of the site for hourly, daily,weekly basis as required. It will show graph in attractive UI as per your needs.

€250 EUR in 4 giorni
(83 valutazioni)
5.7
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 Altro

€555 EUR in 10 giorni
(21 valutazioni)
5.3
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 giorni
(65 valutazioni)
5.4
purplemaestro

Hello. My name is Muhammad Hassan. I have high level expertise in PHP Development and Charts. I can do the work on time and wont disappoint you. Please share other details with me so that I can start working on it. Altro

€250 EUR in 5 giorni
(39 valutazioni)
5.0
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 Altro

€611 EUR in 9 giorni
(5 valutazioni)
4.4
Danial2018

Hi, I read your project requirement carefully and I understand your project but I want to ask a few questions before mover further so that I can deliver you exact work with one shoot. I always deliver quality wit Altro

€555 EUR in 10 giorni
(1 Recensione)
4.0
devzonesolution

hello there we can get the job done have checked your requirements and would love to work on the project. kind regards Team Devzone.

€1500 EUR in 30 giorni
(1 Recensione)
2.4
abhimadankr

I read job description and I can do your project.I can even work on urgent basis and complete your project soon..contact me for more information

€250 EUR in 20 giorni
(3 valutazioni)
1.8
Mindlarz

We are a web developing and designing company with various other facilities such as web content and digital marketing related to all types of specializations. Additional considerations and implementations are assisted Altro

€444 EUR in 4 giorni
(0 valutazioni)
0.0
ucwise

Just a proper understanding or a blue print of how the structure should look and this job will be done swiftly.

€500 EUR in 13 giorni
(0 valutazioni)
0.0