sql : self join best example

https://www.youtube.com/watch?v=6DQpvfdj6EE

wordperss : setup environment

Cakephp : cronjob

http://miftyisbored.com/a-tutorial-on-how-to-setup-a-cron-job-for-cakephp-2-x-on-shared-hosting/

I recently had to setup a cron job on shared hosting for one of my CakePHP projects. And although I have done this often, I always seem to forget the steps and something that should take me 5 minutes end up taking 15-30 minutes. So here is a quick tutorial on how to setup a Cron Job for CakePHP 2.x on shared hosting. In my case, I am using Bluehost but this should work for HostGator or any other shared hosting provider that gives you acces to crons through the cPanel.

The Initial Setup

Before begining the tutorial, its important to understand CakePHP Console and Shells. You can read about them in the CakePHP 2.x Cookbook. Basically, console applications are ideal for handling a variety of background tasks such as maintenance, and completing work outside of the request-response cycle. Using the console, you can create shells for use in the console. What’s really awesome about CakePHP shells is that they provide easy access to your models by using the $uses property, you can define an array of models you want to have access to in your shell. A typical install of CakePHP 2.x will have the Cakeshell executable located in the app/Console/ folder. There are 3 variations of the cakeshell provided in this folder:

• cake: which is the standard bash version of the cakeshell
• cake.bat: which is the Windows version of the cakeshell used on Windows environments
• cake.php: which is the PHP version of the cakeshell used in PHP setups. This is the version we will be using on shared hosting accounts

A Simple Cakeshell Application

For this tutorial, we will be building a simple cakeshell application that sends emails to users who have not confirmed their email address. The shell uses the User model and since it is a mailing shell, it also uses CakePhP’s CakeEmail. Below is the source code for this simple shell script that emails users that have not yet confirmed their email address.

1 2 3 4 5 6 7 8 9 10 11 12 13 14

<?php App::uses('CakeEmail', 'Network/Email'); class UsersUpdateShell extends AppShell {     public $uses = array('User');       public function remind_unconfirmed_users() {        $conditions = array('conditions'=>array('User.email_confirmed'=>false));        $unconfirmed_users = $this->User->find('all',$conditions);        foreach($unconfirmed_users as $unconfirmed){           $this->sendConfirmationEmailRemider($unconfirmed);        }     } } ?>

I have named the above file UsersUpdateShell.php. This shell, along with any other shell files that are created in CakePHP must be placed in the app/Console/Command/ folder. Therefore, the full path becomes app/Console/Command/UsersUpdateShell.php. This shell will work as-is using the CakePHP console. Now, we want to run it as a cron job on our shared hosting account.

Setting up the Shell as a Cron Job

Now that the shell has been created, we need to add it to our cronjob using cPanel. You first need to find the Cron menu in cPanel. Below is a screenshot of the bluehost cPanel page for cron jobs.

According to the CakePHP documentation, you should run your shell as a cron job using the following command

1	cd /full/path/to/app && Console/cake myshell myparam

This does not exactly work for shared hosting and some slight tweeking is required. You need to call a command similar to what CakePHP suggests but keeping in mind the limitations of shared hosting: you need to provide full paths and you probably will not have access to bash. So let’s assume that you installed your application at the root folder of /home/myawesomesite/public_html/, then you will have to setup the following command for your cron job

1	php -c /home/myawesomesite/public_html/php.ini /home/myawesomesite/public_html/app/Console/cake.php -app /home/myawesomesite/public_html/app -working /home/myawesomesite/public_html/app UsersUpdate remind_unconfirmed_users > /home/myawesomesite/public_html/app/tmp/logs/cron_logs.txt 2>&1

Here is an analysis of the command above:

• php -c /home/myawesomesite/public_html/php.ini /home/myawesomesite/public_html/app/Console/cake.php tells the comnand line that we will be running a php script called cake.php. I also provide the additional parameter of -c which allows me to specify which configuration file that I want to use. In this example, I created a php.ini configuration file at /home/myawesomesite/public_html/php.ini that I want to use. This is important to do because on some servers, the environment variable register_argc_argv is turned off. If it is turned off, PHP will not be able to read any extra parameters that are required for your Cakeshell to execute and you will get the very frustrating and not very helpful error message: Error: This file has been loaded incorrectly and cannot continue. Please make sure that /lib/Cake/Console is in your system path, and check the cookbook for the correct usage of this command..
• /home/myawesomesite/public_html/app/Console/cake.php -app /home/myawesomesite/public_html/app corresponds the command to start the cake console and the -app option tells CakePHP where your app folder is located. The -working option tells CakePHP where your working folder is located. The working folder should always be your app folder.
• UsersUpdate corresponds to the shell to execute
• remind_unconfirmed_users corresponds to the function to execute
• > /home/myawesomesite/public_html/app/tmp/logs/cron_logs.txt 2>&1 forces all output to be directed to a logfile that I have setup in the tmp folder under the filename cron_logs.txt. This is optional and not really required but I like to keep my logs clean