Summary of common techniques for YII framework

echo $this->id;
echo $this->action->id;

$this->module->id

// ActiveForm class$form->field($model, 'Field Name')->passwordInput(['maxlength' => true])->label(false)

Yii::$app->request->rawBody;

use yii\helpers\Html;
use yii\helpers\HtmlPurifier;
echo Html::encode($view_hello_str) //The <script></script> code can be displayed as it isecho HtmlPurifier::process($view_hello_str) //The <script></script> code can be filtered out

// SELECT * FROM `order` WHERE `subtotal` > 200 ORDER BY `id`
$orders = $customer->getOrders()
->where(['>', 'subtotal', 200])
->orderBy('id')
->all();

$dataProvider = $searchModel->search(Yii::$app->request->queryParams);
// $dataProvider->query->andWhere(['pid' => 0]);
$dataProvider->query->andWhere(['>', 'pid', 0]);
//Optional pass parameters$dataProvider->query->andFilterWhere(['id'=>isset($id)?$id:null]);

return \yii\helpers\ArrayHelper::getColumn(User::find()->all(), 'name');

return User::find()->select('name')->asArray()->column();

// Reference namespaceuse yii\helpers\VarDumper;
// useVarDumper::dump($var);
// Use 2 The second parameter is the depth of the array. The third parameter is whether to display the code highlighting (not displayed by default)VarDumper::dump($var, 10 ,true);die;

public function rules()
{
  return [
    [['card_id', 'card_code'], function ($attribute, $param) {//At least one      if (empty($this->card_code) && empty($this->card_id)) {
        $this->addError($attribute, 'Card_id/card_code must be filled in at least one');
      }
    }, 'skipOnEmpty' => false],
  ];
}

// ['not' => ['attribute' => null]]
//['ISNULL(`attribute`)'=>true]
$query = new Query;
$query->select('ID, City,State,StudentName')
  ->from('student')
  ->where(['IsActive' => 1])
  ->andWhere(['not', ['City' => null]])
  ->andWhere(['not', ['State' => null]])
  ->orderBy(['rand()' => SORT_DESC])
  ->limit(10);

public function rules()
{
  return [
    [['point_template_id'], 'exist',
      'targetClass' => PointTemplate::className(),
      'targetAttribute' => 'id',
      'message' => 'this{attribute}Does not exist。'
    ],
  ];
}

div . required label:after {
  content:
  " *";
  color:
  red;
}

$styleId = Yii::$app->request->get('style');
$collection = Yii::$app->db->cache(function ($db) use ($styleId) {
  return Collection::findOne(['style_id' => $styleId]);
}, self::SECONDS_IN_MINITUE * 10);

class User extends \yii\db\ActiveRecord
{
...
  public function extraFields()
  {
    $fields = parent::extraFields();
    $fields['avatar_url'] = function () {
      return empty($this->avatar_path) ? 'You can set a default avatar address' : '/' . $this->avatar_path;
    };
    return $fields;
  }
...
}

class ExampleController extends \yii\web\Controller
{
  public function actionIndex()
  {
    $userModel = User::find()->one();
    $userData = $userModel->toArray([], ['avatar_url']);
    echo $userData['avatar_url']; // Output content: /Avatar path  }
}

[['name', 'email', 'subject', 'body'], 'required','message'=>'{attribute} must'],

Post::find()->select('title')->where(['user_id' => $userId])->scalar();

SELECT `title` FROM `post` WHERE `user_id` = 1

`SELECT * FROM `post` WHERE `user_id`=1`

public function rules()
{
  return [[title', 'content'],'trim']];
}

use Yii;
use yii\base\Behavior;
use yii\web\Controller;
class NoCsrf extends Behavior
{
  public $actions = [];
  public $controller;
  public function events()
  {
    return [Controller::EVENT_BEFORE_ACTION => 'beforeAction'];
  }
  public function beforeAction($event)
  {
    $action = $event->action->id;
    if (in_array($action, $this->actions)) {
      $this->controller->enableCsrfValidation = false;
    }
  }
}

public function behaviors()
{
  return [
    'csrf' => [
      'class' => NoCsrf::className(),
      'controller' => $this,
      'actions' => [
        'action - name'
      ]
    ]
  ];
}

['like', 'name', 'tester'] Will generate name LIKE ' % tester % '。
['like', 'name', ' % tester', false] => name LIKE ' % tester'
$query = User::find()->where(['LIKE', 'name', $id . ' % ', false]);

$query = new Query;
$query->select('ID, City,State,StudentName')
  ->from('student')
  ->where(['IsActive' => 1])
  ->andWhere(['not', ['State' => null]])
  ->orderBy(['rand()' => SORT_DESC])
  ->limit(10);

Yii::$app->db->transaction(function () {
  $order = new Order($customer);
  $order->save();
  $order->addItems($items);
});
// This is equivalent to the following verbose code:$transaction = Yii::$app->db->beginTransaction();
try {
  $order = new Order($customer);
  $order->save();
  $order->addItems($items);
  $transaction->commit();
} catch (\Exception $e) {
  $transaction->rollBack();
  throw $e;
}

$model = new User();
foreach ($data as $attributes) {
  $_model = clone $model;
  $_model->setAttributes($attributes);
  $_model->save();
}

$model = new User();
foreach ($data as $attributes) {
  $model->isNewRecord = true;
  $model->setAttributes($attributes);
  $model->save() && $model->id = 0;
}

Yii::$app->request->getHostInfo()

Yii::$app->request->getPathInfo()

# /public/?r=news&id=1
Yii::$app->request->url

Yii::$app->request->requestUri

# r=news&id=1
Yii::$app->getRequest()->queryString;

Yii::$app->getRequest()->getQuery('id'); //get parameter 'id'

# /public/
Yii::$app->user->returnUrl;

Yii::$app->request->headers['Referer']

Yii::$app->getRequest()->getReferrer()