#php

Linux

LEMP (Linux, Nginx, Mysql, PHP) in Ubuntu 14.04

2

In this post, I will show step to run a simple site in nginx server, use FPM.

Install all packet with apt-get:

1
sudo apt-get install nginx mysql-server php5-fpm php5-mysql

Create example.com file in /etc/nginx/site-available/

1
2
cd /etc/nginx/site-available
vi example.com

Add the content below to “example.com” file

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
server {
        listen 80 default_server;
        listen [::]:80 default_server ipv6only=on;
 
        root /usr/share/nginx/example.com/www;
        index index.php index.html index.htm;
 
        server_name example.com
 
        gzip on;
        access_log /usr/share/nginx/example.com/nginx-access.log combined;
        error_log /usr/share/nginx/example.com/nginx-error.log warn;
 
        location / {
                try_files $uri $uri/ /index.php?q=$uri&$args;
        }
        location ~ \.php$ {
                fastcgi_pass unix:/var/run/php5-fpm.sock;
                fastcgi_index index.php;
                include fastcgi_params;
        }
 
}

And enable the site you created

1
2
3
4
5
6
cd /etc/nginx/site-enabled
ln -s /etc/nginx/site-available/example.com example.com
cd /usr/share/nginx
mkdir -p example.com/www
cd example.com/www
echo "<?php phpinfo() ?>" > index.php

Now for the test

Nguyen Sy Thanh Son

2

Linux, PHP

Install XHProf in Ubuntu 14.04

5

XHProf is a function-level hierarchical profiler for PHP and has a simple HTML based user interface. This article will show you the way to install and test XHProf in Ubuntu 14.04

a6f5639e-2cf3-4a71-91e4-250befcfd6a8-medium

When you talk, you are only repeating what you know; but when you listen, you learn something new

 

Install Graphviz:

1
2
sudo apt-get install graphviz
sudo apt-get install libgv-php5

Install XHProf from pecl:

1
sudo pecl install xhprof-0.9.4

Adding XHProf to PHP5:

1
2
3
4
sudo -s
echo "extension=xhprof.so" > /etc/php5/mods-available/xhprof.ini
php5enmod xhprof
exit;

Test:

1
2
3
4
$ php -i|grep xhprof
/etc/php5/cli/conf.d/20-xhprof.ini
xhprof
xhprof => 0.9.4

Install XHProf report view:

1
2
cd /var/www
git clone https://github.com/phacility/xhprof.git

Create a test script:

1
2
3
4
5
6
7
8
xhprof_enable();
// Your code here
$XHPROF_ROOT = "/var/www/xhprof/";
include_once $XHPROF_ROOT . "/xhprof_lib/utils/xhprof_lib.php";
include_once $XHPROF_ROOT . "/xhprof_lib/utils/xhprof_runs.php";
 
$xhprof_runs = new XHProfRuns_Default();
$run_id = $xhprof_runs->save_run($xhprof_data, "foobar");

And view the report:

1
http://localhost/xhprof/xhprof_html/index.php

In the better way, you should create header.php, and footer.php and change apache2 configuration so that you can track your request automatically

1
2
php_value auto_prepend_file /var/www/xhprof/header.php
php_value auto_append_file /var/www/xhprof/footer.php

 

Nguyen Sy Thanh Son

5

PHP

Adding external library to Laravel 4+

1

When you work with a framework, sometimes you need to use an external library. This will show you the way to add an external library to Laravel 4. Actually, it is very simple.

For example, you have a library that locates in path: app/library/external_lib. So you should add that path to composer.json file (located at root directory of framework)

1
2
3
4
5
6
7
8
9
10
11
12
    "autoload": {
        "classmap": [
            "app/commands",
            "app/controllers",
            "app/models",
            "app/library",
            "app/library/external_lib",
            "app/database/migrations",
            "app/database/seeds",
            "app/tests/TestCase.php"
        ]
    },

The next step is the final step, run command to dump library to autoload file of framework.

1
composer dump-autoload

I assumed that composer was installed to your machine.

Nguyen Sy Thanh Son

1

PHP

Laravel 4 and crontab

6

In many projects, you need use crontab (cron jobs) to execute some tasks as sending email or delete waste record in DB. With Laravel Project, you can do this easier.

Be strong enough to let go and patient enough to wait for what you deserve

Be strong enough to let go and patient enough to wait for what you deserve

Create a command in Laravel 4:

1
2
$ php artisan command:make FirstCommand
Command created successfully.

With command above, Laravel will create a file named FirstCommand.php in directory  app/commands/

FirstCommand.php contains source code as below:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
<?php
 
use Illuminate\Console\Command;
use Symfony\Component\Console\Input\InputOption;
use Symfony\Component\Console\Input\InputArgument;
 
class FirstCommand extends Command {
 
        /**
         * The console command name.
         *
         * @var string
         */
        protected $name = 'command:name';
 
        /**
         * The console command description.
         *
         * @var string
         */
        protected $description = 'Command description.';
 
        /**
         * Create a new command instance.
         *
         * @return void
         */
        public function __construct()
        {
                parent::__construct();
        }
        /**
         * Execute the console command.
         *
         * @return mixed
         */
        public function fire()
        {
                //
        }
 
        /**
         * Get the console command arguments.
         *
         * @return array
         */
        protected function getArguments()
        {
                return array(
                        array('example', InputArgument::REQUIRED, 'An example argument.'),
                );
        }
 
        /**
         * Get the console command options.
         *
         * @return array
         */
        protected function getOptions()
        {
                return array(
                        array('example', null, InputOption::VALUE_OPTIONAL, 'An example option.', null),
                );
        }
 
}

You should change this line:

1
protected $name = 'command:name';

E.g:  I changed to

1
protected $name = 'user:active';

Laravel Command supports you use parameters in your command. To add or remove parameters, you should look at getArguments and getOptions functions

And the most important function is fire() function. The command will execute source code that is wrote in that function.

I did the most simple changed to show you the easiest to understand Laravel Command. Please see file FistCommand.php after changing:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
<?php
 
use Illuminate\Console\Command;
use Symfony\Component\Console\Input\InputOption;
use Symfony\Component\Console\Input\InputArgument;
 
class FirstCommand extends Command {
 
        /**
         * The console command name.
         *
         * @var string
         */
        protected $name = 'user:active';
 
        /**
         * The console command description.
         *
         * @var string
         */
        protected $description = 'Command description.';
 
        /**
         * Create a new command instance.
         *
         * @return void
         */
        public function __construct()
        {
                parent::__construct();
        }
 
        /**
         * Execute the console command.
         *
         * @return mixed
         */
        public function fire()
        {
                echo "User Actived";
        }
        /**
         * Get the console command arguments.
         *
         * @return array
         */
        protected function getArguments()
        {
                return array(
                );
        }
 
        /**
         * Get the console command options.
         *
         * @return array
         */
        protected function getOptions()
        {
                return array(
                        array('example', null, InputOption::VALUE_OPTIONAL, 'An example option.', null),
                );
        }
 
}

Next step, you need to register the command with Laravel CLI. So easy, you open app/start/artisan.php file, and add one line as below:

1
Artisan::add(new FirstCommand);

You are done creating Laravel Command. To test, you could use command below:

1
2
$ php artisan user:active
User Active

The output above mean you successfully register a command.

Finally, put your command into the crontab:

1
crontab -e

Add line (run command every 2 minutes):

1
*/2 * * * * php path_to_laravel_project/artisan user:active

That’s all. Thank you for talking time to read this.

 

 

Nguyen Sy Thanh Son

6

PHP

Laravel 4.2 Setup Working Environment

0

Laravel 4.2 setup working environment is an important task should do at the beginning a project. Config files, Git, Gitignore is things you should take care. The below will show you the way to store config files to separate working environment as development, staging and production.

A man who conquers himself is greater than one who conquers a thousand men in battle

A man who conquers himself is greater than one who conquers a thousand men in battle

Detect Working Environment boostrap/start.php:

1
2
3
4
5
6
7
$env = $app->detectEnvironment(array(
 
        'local' => array('sonnst'),
        'staging' => array('staging-machine'),
        'production' => array('production-machine')
 
));

For security reason, from Laravel 4.1,  detectEnvironment function only supports hostname.

Create directories in app/config:

1
mkdir app/config/{local, staging, produciton}

Push config files (e.g database.php, app.php …) to directories that you pretend use for each environment, it will be override the default config value.

Nguyen Sy Thanh Son

0

PHP

Laravel Multiple Database Connection

5

Laravel Multiple Database Connection – this is way to setup and work with multiple database connection in Laravel

The soul always knows what to do to heal itself. The challenge is to silence the mind

The soul always knows what to do to heal itself. The challenge is to silence the mind

Define connections in config file app/config/database.php

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
<?php
return array(
 
    'default' => 'mysql',
 
    'connections' => array(
 
        # Our primary database connection
        'mysql' => array(
            'driver'    => 'mysql',
            'host'      => 'host1',
            'database'  => 'database1',
            'username'  => 'user1',
            'password'  => 'pass1'
            'charset'   => 'utf8',
            'collation' => 'utf8_unicode_ci',
            'prefix'    => '',
        ),
 
        # Our secondary database connection
        'mysql_2' => array(
            'driver'    => 'mysql',
            'host'      => 'host2',
            'database'  => 'database2',
            'username'  => 'user2',
            'password'  => 'pass2'
            'charset'   => 'utf8',
            'collation' => 'utf8_unicode_ci',
            'prefix'    => '',
        ),
    ),
);

Use the second DB in Eloquent Model

1
2
3
4
5
6
<?php
class SomeModel extends Eloquent {
 
    protected $connection = 'mysql_2';
 
}

Use the second DB Connection in Controller

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
<?php
 
class SomeController extends BaseController {
 
    public function someMethod()
    {
        $someModel = new SomeModel;
 
        $someModel->setConnection('mysql_2');
 
        $something = $someModel->find(1);
 
        return $something;
    }
 
}

Query Builder

1
$users = DB::connection('mysql_2')->select(...);

 

 

Nguyen Sy Thanh Son

5

Linux, PHP

Install Memcached, PHP Memcache and PHP Memcached in Ubuntu 14.04

1

As you know, Memcached is great cache system for your web application. Use correctly Memcached will speed up your application so much. So now is how to install memcached, PHP Memcache and PHP Memcached

Install Memcached, PHP Memcache and PHP Memcached in Ubuntu 14.04

In Ubuntu 14.04, the installation is very simple, just need one command:

1
sudo apt-get install memcached php5-memcache php5-memcached

Please remember restart apache2:

1
sudo /etc/init.d/apache2 restart

Finally, test your works by writing some PHP scripts.

1
vi test.php

Add php script to test.php:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
<?php
 
$memcache = new Memcache();
$memcache->connect('localhost', 11211);
 
$memcache->set('test', false); //
$flags = false;
var_dump($memcache->get('test', $flags)); // bool(false)
var_dump($flags); // int(256) - changed to int
 
$memcache->delete('test');
 
$flags = false;
var_dump($memcache->get('test', $flags)); // bool(false)
var_dump($flags); // bool(false) - untouched
 
?>

Successful result:

1
2
3
4
5
thanhson1085@sonnst:~$ php test.php
bool(false)
int(256)
bool(false)
bool(false)

 

 

Nguyen Sy Thanh Son

1

PHP

Different between MyISAM and InnoDB

2

MyISAM means MYSQL Indexed Sequential Access Method. Basically, It is a flat file, and is very old technology. But do not let that put you off using it. Because a flat file means it is not relational, and thus is not an RDBMS, and thus is more appropriate for some situations.
InnoDB is the full RDBMS like almost one you know.  InnoDB is great for if you have a lot of relational links (with references, joins, etc).

With MyISAM, It implements locking on the table, and while that lock is held, no other session can perform a SELECT. With InnoDB, It implements locking on the row.

Additional thing, MyISAM supports full-text search.

Both MyISAM and InnoDB are good. But when you design database you need determine if you need features provided by InnoDB. If not, then MyISAM is up for consideration.

 

Nguyen Sy Thanh Son

2

PHP

PHP create a class with dynamic variables

1

PHP provides overloading methods to help you create dynamically properties and methods. In this case we will use 2 functions __set() and get(). The below is the concept of  that two functions.

__set() is run when writing data to inaccessible properties.
__get() is utilized for reading data from inaccessible properties.

Now, we will write a class with dynamic variables using __get(), set() functions.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
<?php
class test{
 
   private $data;
 
   //$values is an associative array
   public function __construct($values){
      $this->data = $values;
   }
 
   public function __get($varName){
 
      if (!array_key_exists($varName,$this->data)){
          //this attribute is not defined!
          throw new Exception('this attribute is not defined!');
      }
      else return $this->data[$varName];
 
   }
 
   public function __set($varName,$value){
      $this->data[$varName] = $value;
   }
 
}
 
$t = new test(array('a' => 'b', 'c' => 'd'));
 
echo $t->a;
$t->m = 'n';
echo $t->m;

If you do not know about magic functions in PHP, this issue will is not easy for you. But, if you know it, it is so simple.

Nguyen Sy Thanh Son

1