yii\db\Query::prepare PHP Method

Query Class Documentation Usage Examples Of yii\db\Query::prepare Show file Open project: yiisoft/yii2

prepare() public method

This method is called by QueryBuilder when it starts to build SQL from a query object. You may override this method to do some final preparation work when converting a query into a SQL statement.

public prepare ( QueryBuilder $builder )
$builder	QueryBuilder

    public function prepare($builder)
    {
        return $this;
    }

Usage Example

Example #1

Show file

File: globals.php Project: nikosid/globals

/**
 * @param \yii\db\Query $select
 * @param \yii\db\Connection $db
 * @return string
 */
function getsql(\yii\db\Query $select, $db = null)
{
    if ($db === null) {
        $db = Yii::$app->getDb();
    }
    return $select->prepare(Yii::$app->db->queryBuilder)->createCommand($db)->rawSql;
}

Query

addGroupBy

addParams

addSelect

all

andFilterCompare

andHaving

andWhere

average

batch

column

count