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.
Greetings for the day
This is poonam FULL TIME FREELANCER having 6+ YEARS of experience in PHP development.
DO you want me to work on your project i can do this by today.
I would appreciate if you could visit my portfolio and feedback of my past projects because that defines me batter then my proposal.
https://www.freelancer.in/u/sismaster.html
Can you please ping me back so that we can have small chat session.
Kind Regards,
Poonam
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 client want to get more faster job services with save time I am ready to work. I can ensure that I’ll complete each instruction within time frame even more faster.
I am available everyday to work more than 12 hours. I can ensure that I'll complete each instruction within time limit with daily update on server. I am ready to work and I hope I'll get permit to prove my experience.
Thank you