Blog Archives

Tracking user behaviour on your website

Tracking the behaviour of the users on your website can be useful for Search Engine Optimization and User Experience Optimization. In this tutorial I describe how you can get started with a simple piece of PHP and a MySQL query.

Posted in Tutorials Tagged with: , , , , , , ,

Execute a PHP script using CRON

In response to this post, I’ve received the following email: “How can I execute a PHP page using CRON? I’m trying ‘php -q /path/script.php’ but it does nothing..“ Note: It’s very likely that your PHP binary is outside of the

Posted in Tutorials Tagged with: , , ,

Daily Full MySQL backup using cron

Today I bring to you a cron job that will save a well named gzip of your database dump every day at 4:00 (4am). Example output: “myDB_2012-01-29_04-00-01.sql.gz“ In this example, I’ll use a fictional host, path, login and password. When

Posted in Tutorials Tagged with: , , , , ,