NEED: Script to show Stats per Page (Apache)

I am looking for a script which will post traffic stats for individual pages to a we page:
- hits
- unique visitors (day/month/total)?
- bot visits
- search terms

I would prefer a PHP script but I am not sure that PHP can actually interact with Apache in that way. Data needs to be stored in a MySQL database.

 

BBclone is a very good one, but sadly it uses flat text files as database