Skip to content

Instantly share code, notes, and snippets.

@chenyongze

chenyongze/get-yii2-ar-raw-sql.php

Forked from dcb9/get-yii2-ar-raw-sql.php
Created September 19, 2016 04:07
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save chenyongze/842ebc8eeaa823da18beca7692ba229b to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save chenyongze/842ebc8eeaa823da18beca7692ba229b to your computer and use it in GitHub Desktop.
Download ZIP
如何获取 YII2 AR 执行的 SQL 语句，直接用程序输出，而不是通过日志去查看
Raw
get-yii2-ar-raw-sql.php
<?php
$query = User::find()
->where(['id'=>[1,2,3,4])
->select(['username'])
// get the AR raw sql in YII2
$commandQuery = clone $query;
echo $commandQuery->createCommand()->getRawSql();
$users = $query->all();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment