Here is some of the code to get the "Plant information".
The DHT and Soil moisture information is sent to my webserver using HTTP GET requests.
The sketch sends the HTTP request to temp.php on my webserver and this page then reads the data sent in the request (temp, hum, id & soil). Since the sensor data is updated every 30 seconds (I will change this to maybe 4 times per day), the database is filled with a lot of information. To deal with this I have created a "daily" table to store information for longer periods of time and also to be able to create nice graphs in the future. All data in my "detailed" table older than 7 days will be deleted since I don't see a actual need for this detailed infor for so long time.
Below I have attached the code for the temp.php page.