SHELL commands for Putty Basic

Zip a folder and it's contents

zip -r folder.zip foldername

Unzip a folder

unzip foldername

Recursive permission for folder and it's contents

chmod -R 777 foldername 

Recursive permission for folder  contents

chmod -R 777 * 

Making a tunnel and transfer files

wget -c http://www.example.com/backup.zip

List contents in current folder

li

Moving folder to another folder

mv foldername foldername2

session null after redirect with header

This is session saving problem and i could fix it giving permission to session storing directory.

Other things to check

1. session_save_path('"your home directory path"/cgi-bin/tmp');
2. check register_globals. It should be off.
3. After the header redirect, end the current script using exit(); (Or can use session_write_close(); Or session_regenerate_id(true))

Yii2 basic commands

Save data
$member = new Member;
$member->name = 'John';
$member->email = 'john@gmail.com';
$member->save();  // equivalent to $member->insert();

Select *
$model = $connection->createCommand('SELECT * FROM member');
$members = $model->queryAll();

Select One row
$model = $connection->createCommand("SELECT * FROM member where member_id=$id");
$member = $model->queryOne();

Query Column
$model = $connection->createCommand('SELECT name FROM member');
$members = $model->queryColumn();

JSON format return
$items = ['book1', 'book2', 'book3', 'book4'];
\Yii::$app->response->format = 'json';
return $items;

OR

$items = ['book1', 'book2', 'book3', 'book4'];
return \yii\helpers\Json::encode($items);