Use the PHP extension for MySQL to access data from the MySQL database.

Stored procedures protect from SQL injection hacks, and they speed up your database server and return records to the PHP page.

Here’s a Raspberry Pi hack that adds web control using PHP and MySQL. As you can see in the image, it serves up a webpage (using the Apache2 server) which allows you to change the state of the ...