Build a Website 2
$30-250 USD
Pagado a la entrega
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/[url removed, login to view]
http://localhost/[url removed, login to view]
http://localhost/[url removed, login to view]
http://localhost/[url removed, login to view]
http://localhost/[url removed, login to view]
http://localhost/[url removed, login to view]
The response of all of these operations must be in JSON format.
Further, the response of this operation http://localhost/[url removed, login to view] 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.
Nº del proyecto: #10499797