Gathering and collecting information into databases is very helpful, but if it is locked inside a database or a file it isn't much use. However, if we allow the stored data to be viewed via a web page it will be far more accessible; not only can we view the data from other devices, we can also share it with others on the same network.
We shall create a local web server to query and display the captured SQLite data and allow it to be viewed through a PHP web interface. This will allow the data to be viewed, not only via the web browser on the Raspberry, Pi but also on other devices, such as cell phones or tablets, on the local network:
Data captured in the SQLite database displayed via a web-page
Using a web server to enter and display information is a powerful way to allow a wide range of users to interact with your projects. The following example demonstrates a web server setup that can be customized for a variety of uses.
