PHP yii\db ActiveRecord::findBySql 예제들

findBySql() 공개 정적인 메소드

Note that because the SQL statement is already specified, calling additional query modification methods (such as where(), order()) on the created ActiveQuery instance will have no effect. However, calling with(), asArray() or indexBy() is still fine. Below is an example: php $customers = Customer::findBySql('SELECT * FROM customer')->all();

public static findBySql ( string $sql, array $params = [] ) : ActiveQuery
$sql	string	the SQL statement to be executed
$params	array	parameters to be bound to the SQL statement during execution.
리턴	ActiveQuery	the newly created [[ActiveQuery]] instance

예제 #1

파일: XiiArPlus.php 프로젝트: keigonec/XiiBackend

 public static function execSql($sql, $obj = false)
 {
     return $obj ? parent::findBySql($sql)->all() : parent::findBySql($sql)->asArray()->all();
 }