CodeAndCoins Forum

Official Forum of YouTube/CodeAndCoins Channel

Any problem, other than on a youtube video.
User avatar
By Kevin
#79
Good day,

I have an IOT device where I check the network connectivity status then store that Boolean value in a msqli table. Is it possible for me to check the database for the last time the device was connected then post the timedate on an HTML page? I use 1 as device online and 0 as the device is offline.
Any response is greatly appreciated,
User avatar
By shah.nawaraj.forum
#81
Kevin wrote: Fri Oct 23, 2020 9:21 am Good day,

I have an IOT device where I check the network connectivity status then store that Boolean value in a msqli table. Is it possible for me to check the database for the last time the device was connected then post the timedate on an HTML page? I use 1 as device online and 0 as the device is offline.
Any response is greatly appreciated,
You can send the status online to the server and save it along with the current time. You have to do it frequently (minutes or hours). If that status time is more than your frequency-time then you can set that device as offline.

Warning: mysqli::__construct(): (HY000/1045): Acce[…]

How to get the data from Register into Login

Check out this post .

Checking values in a database

Good day, I have an IOT device where I check t[…]

Check out the code from this page .