Build a Website
$30-250 USD
Paid on delivery
Write a single page PHP application that implements all the CRUD operations on a database named “IOT” that contains a table named “TEMPERATURE” that has the following structure:
CREATE TABLE TEMPERATURE (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
temperature DOUBLE NOT NULL,
longitude DOUBLE NOT NULL,
latitude DOUBLE NOT NULL,
description VARCHAR(50),
measurement_date TIMESTAMP
)
The credentials to connect to the database are as follows: username=“root” and password=“root”
The following examples illustrate the RESTful CRUD operations that your application should support:
http://localhost/[login to view URL]
http://localhost/[login to view URL]
http://localhost/[login to view URL]
http://localhost/[login to view URL]
http://localhost/[login to view URL]
http://localhost/[login to view URL]
The response of all of these operations must be in JSON format.
Further, the response of this operation http://localhost/[login to view URL] must be an HTML page that displays a table of all the recorded temperature readings where the background of the even rows is white and that of the odd rows is blue.
Project ID: #10499862
About the project
Awarded to:
Hi my name is rajesh and i have 5 years of industry experience in Java,Android,PHP and mysql. I will write a php script for [login to view URL] minimum of your budget. please let me what are these query ? I will write a com More
9 freelancers are bidding on average $164 for this job
Check my profile. I'm very fast, reliable, and profesional. I'm easily 3 times faster than other programmers.
Hi, I’m dedicated professional Web and Desktop Programmer & Developer and also Team leader of my company. I have been working with challenge and hope to improve future plan with good network every client. If any clien More
I am new on freelancer. But I can assure that this work can be done in 24 hours satisfying all your expectations.