Yii框架 session 數(shù)據(jù)庫(kù)存儲(chǔ)操作方法示例

[
  'components' => [
    'db'   => [
      'class'     => 'yii\db\Connection',
      'dsn'      => 'mysql:host=localhost;dbname=yii',
      'username'   => 'root',
      'password'   => 'xxxxxx',
      'charset'    => 'utf8'
    ],
    'session' => [
      'class' => 'yii\web\DbSession', //session 操作對(duì)象
      'db'  => 'db',   //指定數(shù)據(jù)庫(kù)操作組件是上面的組件db
      'sessionTable' => 'yii_session' //session 數(shù)據(jù)庫(kù)表名稱(chēng)
    ]
  ]
]

CREATE TABLE yii_session
(
  id CHAR(40) NOT NULL PRIMARY KEY,
  expire INTEGER,
  data BLOB
)

namespace app\controllers\home;
use Yii;
use yii\web\Controller;
class IndexController
{
  public function actionIndex()
  {
    $session = Yii::$app->session;
    if(isset($session['name'])  isset($session['tel']))
    {
      var_dump($session);
    }else{
      $session['name'] = '譚勇';
      $session['tel'] = 22;
      echo 'set session';
    }
  }
}