restlin/yii2-query-insert

Class for Yii2 PHP framework helps to generate insert sql query from other tables.

1.0.1 2018-02-12 15:18 UTC

Requires

• yiisoft/yii2: *

GPL-3.0-or-later

• Ilya Shumilov

• db
• extension
• query builder
• yii2

README

Class for Yii2 PHP framework helps to generate insert sql query from other tables.

This class helps to create query as below:

insert into rights_cache(id,login,type,date_in)
select id,login,type,now()
from rights 
where date_in>date_trunc('day',now());

Example usage:

$query = new QueryInsert;
$query->select(['login','docid'])
->from($tblTemp)
->where(['in','docid' , $docids]);
$query->insert(DA::tableName(),['login','docid']);