Raspberry Pi 3 Cookbook for Python Programmers - Third Edition

Getting ready

Ensure you have completed the previous recipe so that the sensor data has been collected and stored in the SQLite database. We need to install a web server (Apache2) and enable PHP support to allow SQLite access.

Use these commands to install a web server and PHP:

sudo apt-get update
sudo aptitude install apache2 php5 php5-sqlite  

The /var/www/ directory is used by the web server; by default, it will load index.html (or index.php) – otherwise, it will just display a list of the links to the files within the directory.

To test whether the web server is running, create a default index.html page. To do this, you will need to create the file using sudo permissions (the /var/www/ directory is protected from changes made by normal ...