Orion's Blog – A Lazy Developer

Install sendmail on Ubuntu 14.04/16.04

#Entering the following command into the terminal –

1) Install sendmail

sudo apt-get install sendmail

2) Configure sendmail
Enter the following command into the terminal and type “Y” for each question it asks –

sudo sendmailconfig

3) Edit hosts file

sudo nano /etc/hosts

Add/Edit the following line to your hosts file and save it-

127.0.0.1 localhost localhost.localdomain YOUR_DOMAIN.com

4) Restart apache
Let’s restart apache –

sudo service apache2 restart

Hope it works’s on your Ubuntu 14.04/16.04.

Convert null to empty string for json output in PHP

# Technique 1:

array_walk_recursive($YOUR_ARRAY, function (&$item, $key) {
    $item = null === $item ? '' : $item;
});

# Technique 2:

array_walk($YOUR_ARRAY, function(&$item) {
    $item = strval($item);
});

Install FFMPEG in CentOS 6.8

Go to your terminal and execute the following command one by one –

rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm

rpm -Uvh http://li.nux.ro/download/nux/dextop/el6/x86_64/nux-dextop-release-0-2.el6.nux.noarch.rpm

yum update

yum -y install ffmpeg ffmpeg-devel

# Success !!! Now check the version

ffmpeg -version

Create new user with rights only for specific DB in Mysql

# Log-in to Mysql from terminal
# Set proper value in ( DB_NAME, NEW_DB_USER_NAME, PASSWORD_FOR_NEW_USER )

-> GRANT ALL PRIVILEGES ON DB_NAME.* To 'NEW_DB_USER_NAME'@'localhost' IDENTIFIED BY 'PASSWORD_FOR_NEW_USER';
-> FLUSH PRIVILEGES;

# If you want to delete user

-> DROP USER ‘demo’@‘localhost’;

Ajax Request Headers in Postman

You can add the following header to sent Ajax request in postman.

Content-Type      application/json

X-Requested-With  XMLHttpRequest

Screenshot

Postman Header for API

Codeigniter Sending email via SMTP Gmail

Here I share with you the way; How to send email in Codeigniter Framework via Gmail SMTP feature.

Write this code in your controller:-

Controller

public function send_email() {

        $config = array(
            'protocol' => 'smtp',
            'smtp_host' => 'ssl://smtp.googlemail.com',
            'smtp_port' => 465,
            'smtp_user' => 'YOUR_GMAIL_ID@gmail.com', // gmail Username
            'smtp_pass' => 'YOUR_GMAIL_PASSWORD', // gmail Password
            'mailtype' => 'html', // what type of mail you want to sent. i.e html/plaintext
            'charset' => 'utf-8',
            'wordwrap' => TRUE
        );

        $message = "Hi, This is a test mail using gmail smtp from my PC using CodeIgniter Framework.";

        $this->load->library('email', $config);
        $this->email->set_newline("\r\n");
        $this->email->from('FROM_EMAIL_ADDRESS'); // in which email address you want to send email.
        $this->email->to('TO_EMAIL_ADDRESS'); // where your mail goes.
        $this->email->subject('Test Email via Gmail SMTP from My PC');
        $this->email->message($message);
        $success = $this->email->send();

        if ($success) {
            echo 'Waooo.. Email send successfully!!!';
        } else {
            // if email don't send then shows error.
            show_error($this->email->print_debugger());
        }
    }

Why Mysql Insert Query Returns False

Some days ago I face a problem; which is my mysql insert query retun false. So I need to dubug the query and wanna to know which problem is here. This help me very much:-

trigger_error(mysql_error());

to debug the query. I think sometime you need help with that.

$sql = "here is you mysql query";
mysql_query($sql) or trigger_error(mysql_error()." in ".$sql);

How to Subtract two dates in php

$date_one = "2013-09-02 04:24:25";

$date_two = "2012-09-02 04:24:25";

$to_date = strtotime($date_one);
$from_date = strtotime($date_two);

$date_difference = $to_date- $from_date; // Get date difference between the two dates in number of seconds
$days = floor($date_difference / (24 * 60 * 60 )); // convert to days
echo($days); // print 365

Mysql Select data where expire date = today + 30 days

SELECT * FROM domain_hosting_info WHERE exp_date <= DATE_ADD(DATE(now()), INTERVAL 30 DAY)

SELECT * FROM domain_hosting_info WHERE exp_date = DATE(DATE_ADD(NOW(), INTERVAL 30 DAY))

CodeIgniter pagination when 2 variables in the URL

When 2 variables or number are present in the URL It occurs a problem in pagination. Easily solve this by the set the following config.

Example - http://test.com/CONTROLLER/FUNCTION/5/1

here 1 is the uri segment.

// set this is the function
$config['uri_segment'] = 4;