PHP has a wide range of uses. The most prominant uses (my opinion) are database related, in almost any area you can imagine where info needs to be stored and recalled....yes, you can make local & stand alone scripts.
To get some ideas of it's functionality, try
http://hotscripts.com/
and...