YII2学习笔记查询类分析.docxVIP

QueryInterFaceAll()One()Count($q = ‘*’,$db)Exists()indexBy($cloumn) //索引值 或者使用回调函数where($condition)`[type = 1, status = 2]` generates `(type = 1) AND (status = 2)`.`[id = [1, 2, 3], status = 2]` generates `(id IN (1, 2, 3)) AND (status = 2)`.`[status = null] generates `status IS NULL`.`[and, id=1, id=2]` generate `id=1 AND id=2`. `[and, type=1, [or, id=1, id=2]]` generate `type=1 AND (id=1 OR id=2)`.The method will *not* do any quoting or escaping.`[between, id, 1, 10]` generate `id BETWEEN 1 AND 10`.`[in, id, [1, 2, 3]]` generate `id IN (1, 2, 3)`. To create a composite `IN` condition you can use and array for the column name and value, where the values are indexed by the column name:`[in, [id, name], [[id = 1, name = foo], [id = 2, name = bar]] ]`嵌套条件`[in, user_id, (new Query())-select(id)-from(users)-where([active = 1])]``[like, name, tester]`generate `name LIKE %tester%`.`[like, name, [test, sample]]`Generate `name LIKE %test% AND name LIKE %sample%`The method will properly quote the column name and escape special characters in the values.LIKE查询使用了过虑`[exists, (new Query())-select(id)-from(users)-where([active = 1])]` `EXISTS (SELECT id FROM users WHERE active=1)``[=, id, 10]` `id = 10`.addWhere()orWhere()filterWhere(array $condtion)忽略空值的查询andFilterWhere(array $condtion)orFilterWhere(array $condtion)orderBy($cloumns)e.g. id ASC, name DESC) or an arraye.g. `[id = SORT_ASC, name = SORT_DESC]`addOrderBy($cloumns)limit($limit)offset($offset)yii\db\CommandYII的SQL命令创建类 继承:Component执行INSERT UPDATE DELETE 语句 使用 execute()执行 SEELCT 使用 queryAll() queryOne() queryColumn queryScalar()query()exp: $users = $connection-createCommand(‘SELECT * FROM user’)-queryAll()在Command模式下,只要绑定了parameter SQL自动实现 prepared预处理=====================================================属性:$db $pdoStatement$fetchMode = \PDO::FETCH_ASSOC$params = [] 绑定的参数 (name=value) 会产生原生SQL$queryCacheDuration //缓存时间$queryCacheDependency //缓存地点$_pendingParams = [] //等待绑定到 PDO Statement上的参数$_sql方法:Cach