Outline:

How it works, a little background
A simple shell script
How it can tie into apache
A static website (this!)
A dynamic website (mysql)
A dynamic website (postgresql)
A data manipulation problem solved with a php shell script