- Yii 2.0 输出 SQL 语句
$query = User::find()->where(['id'=>[1,2,3,4])->select(['username'])
// 输出SQL语句
$commandQuery = clone $query;
echo $commandQuery->createCommand()->getRawSql();
$users = $query->all();
- 数据写入
$company = new SysCompanyTyc;
$companyInfo = Yii::$app->tianyancha->get('平安银行股份有限公司');
$company->setAttributes($companyInfo);
if(!$company->save()){ //写入
var_dump(array_values($company->getErrors())[0]);die; //打印错误信息
}
1、使用自带的方法setAttributes()
下面的代码就是把fields处理的数组数据插入到数据库里面去
$pdata = $model->toArray();
$model->setAttributes($pdata);
$model->save()
2、使用对象赋值的方式来给数据元素赋值
$pdata = $model->toArray();
$model->region_name = $pdata['region_name'];
$model->pinyin = $pdata['pinyin'];
$model->save()