Monday, 23 September 2013

How to configure phpMyAdmin to access multiple servers from phpmyadmin?

Hi Guys,

Open the following URL in editor:

vim /etc/phpmyadmin/



    $cfg['Servers'][$i]['auth_type'] = 'cookie';
    /* Server parameters */
    //if (empty($dbserver))
    $dbserver = 'servername';
    $cfg['Servers'][$i]['host'] = $dbserver;

    if (!empty($dbport)) {
        $cfg['Servers'][$i]['connect_type'] = 'tcp';
        $cfg['Servers'][$i]['port'] = $dbport;
    //$cfg['Servers'][$i]['compress'] = false;
    /* Select mysqli if your server has it */
    $cfg['Servers'][$i]['extension'] = 'mysqli';

Monday, 16 September 2013

How to count files and line recursively using ubuntu?


How to count number of files recursively?

find . -type f | wc -l

How to count number of lines in files recursively?

wc -l `find  -name '*.php' -o -name '*.html' -o -name '*.xls' -type f`;


Thursday, 5 September 2013

How to Remove Save Draft & Preview Buttions.. and also Status: Draft & Visibility: Public in wordpress?

 Hello All,
 Please add below lines in your function.php file 
  add_action('admin_print_styles', 'remove_this_stuff');
  function remove_this_stuff() { ?>
       #misc-publishing-actions, #minor-publishing-actions {display:none; }
<?php } ?>

Friday, 30 August 2013

How to remove admin bar from non admin users in wordpress?

Hi All,

Please add following script into your functions.php file:

add_action('after_setup_theme', 'remove_admin_bar');

function remove_admin_bar() {
    if (!current_user_can('administrator') && !is_admin()) {


How to add login/logout button in wordpress menu?

Hi All,

Add following script into your functions.php

add_filter('wp_nav_menu_items', 'add_login_logout_link', 10, 2);
function add_login_logout_link($items, $args) {

        $loginoutlink = ob_get_contents();

        $items .= '<li>'. $loginoutlink .'</li>';

    return $items;


Thursday, 8 August 2013

How to create cron job in YII framework?

Hi All,

Create cron.php file under project folder and write following:

// change the following paths if necessary



Create console.php file under protected/config folder and write same data as written in main.php. see below:

/ This is the configuration for yiic console application.
// Any writable CConsoleApplication properties can be configured here.
return array(
    'name'=>'My Console Application',

    // preloading 'log' component

    // application components
        // uncomment the following to use a MySQL database       
            'connectionString' => 'mysql:host=localhost;dbname=bollywood_news',
            'emulatePrepare' => true,
            'username' => $dbUsername,
            'password' => $dbPassword,
            'charset' => 'utf8',
                        'enableProfiling' => true,
                    'levels'=>'error, warning',


Create CronjobCommand.php file under protected/commands folder. Here cronjob is a command.


class CronjobCommand extends CConsoleCommand {

    public function run($args) {
        // your code will come here...



You have two ways to run your command:

Go to your project folder and write following:

a. php cron.php cronjob
b. php protected/yiic cronjob



Wednesday, 7 August 2013

How to take backup of log files in symfony 1.4?

Hi All,

Execute following command on your project root folder:

php symfony log:rotate frontend prod --period=1 --history=5

In above command,
period 1 means:
    frontend_prod.log contains 1 day log data and very next day backup of same file will be saved under log/history folder and also empty it.
history 5 means:
    Under log/history folder, backup of 5 days will be stored only.


Friday, 12 July 2013

How to send mail from shell scirpt?

Hi All,

First of all we will create a sh file and write script see example below:


Write down the following code in the above file:

dt=`date +%F`
echo $dt
count=`mysql -uipay_read -p$passwd -h localhost -D database_name -B --skip-column-names -e "select count(*) from tablename where last_execution_status = 'notexecuted' AND date(created_at) = '$dt';"`
if [ $count -ge 5 ]; then

echo $count;
mail   -s "$count Payment notifications are getting failed."  <<< 'There are $count notifications are pending due to cron job failure'

Now setting cronjob which will run every minute:

* * * * * /path/to/file/ipay4me_cronJob/ /usr/bin/php Asia/Calcutta >/dev/null 2>&1


Thursday, 4 July 2013

How to create cron in symfony?

Hi All,

First of all create task using the below command:

php symfony generate:task [your task] 

for example:

php symfony generate:task notificationFailed

After executing above command you will see that following file has been created.

Creating "/var/www/archive/ipay4me_zen/lib/task /notificationFailedTask.class.php" task file


change the following variable in above created file:

$this->namespace        = 'project';
$this->name             = '[name-for-your-task]';
$this->briefDescription = '[some short explanation of what your task does]';

You will see another method called execute() given below:

protected function execute($arguments = array(), $options = array())
 // initialize the database connection
 $databaseManager = new sfDatabaseManager($this->configuration);
 $connection = $databaseManager->getDatabase($options['connection'] ? $options['connection'] : null)->getConnection();

 // add your code here

 echo "I just did nothing at all, but at least I did it successfully!\n\n";

Let’s give it a test run. Open your command line and enter

php symfony project:[your task]

if everything is fine then you will see "I just did nothing at all, but at least I did it successfully!" otherwise correct error and run again.

If you see the expected output you’re then ready to go to the next step.

Note: if you want to access your app.yml variable here then you have to write following line:

$this->createConfiguration('frontend', 'prod')


$this->createConfiguration('frontend', 'dev')

Cron Setup:

* * * * * cd [YOUR SF APP DIR] && /usr/bin/symfony project:[YOUR TASK] >>[YOUR SF APP DIR]/log/crontab.log

* * * * * cd /var/www/archive/ipay4me_new && /usr/bin/php symfony project:notificationFailed >>/var/www/archive/ipay4me_new/log/crontab.log


Wednesday, 22 May 2013

How to create session in zend framework 1.12?

Hi All,

Use following script to create session:

$mysession = new Zend_Session_Namespace('mysession');   
$mysession->counter = 1000;


Thursday, 16 May 2013

How to open crontab in VI editor?

Hi  All,

Please write the following command to see crontab in Vi editor:

VISUAL=vi crontab -e


Wednesday, 30 January 2013

How to change extension from upper to lower case in ubuntu?

Dear All,

rename 's/\.JPG$/\.jpg/' *.JPG

The above command will convert all JPG to jpg.