如何使用php将apache请求的url保存到数据库中？

Question

I wanted to save the requested urls of my website in to a table in database.

For example if user1 requests the url myserver.com/images/header.png, the below record should be saved in to database.

id    user    requested_url
1     user1   /images/header.png

EDIT: My main problem is how to know the requested Urls and pass them to a php file!

Answer 1

Have a look at Apaches' mod_log_mysql or mod_log_sql. They will allow you to forward apache logs to SQL servers.

Readup:

http://onlamp.com/pub/a/apache/2005/02/10/database_logs.html?page=2