Build a Website 2

Cancelado Publicado hace 7 años Pagado a la entrega
Cancelado 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.

HTML MySQL PHP Diseño de sitios web

Nº del proyecto: #10499797

Sobre el proyecto

1 propuesta Proyecto remoto Activo hace 7 años