关于数据库mysql的使用： 1.查询： salesorderitem::find()-asarray()-where([order_id=$order_id])-all()；salesorderitem::find()-asarray()-where([order_id=$order_id])-one（)；quote::findone([customer_id = $customer_id]); 2.插入： $order = new s
关于数据库mysql的使用：
1.查询：
salesorderitem::find()->asarray()->where(['order_id'=>$order_id])->all()；salesorderitem::find()->asarray()->where(['order_id'=>$order_id])->one（)；quote::findone(['customer_id' => $customer_id]);
2.插入：
$order = new salesorder();$order->order_status = $order_status;$order->store = $store;$order->save();$order_id = yii::$app->db->getlastinsertid(); $db->createcommand('insert into customer (name) values (:name)', [ ':name' => 'qiang',])->execute();
3更新：
3.1
yii::$app->db->createcommand()->update(self::quote_item, ['qty' => $qty,'row_weight'=>$row_weight,'base_row_total'=>$base_row_total,'row_total'=>$row_total,], 'quote_id='.self::$_quote_id.' and item_id='.$item_id )->execute();
3.2// to update an existing customer record
$customer = customer::findone($id);$customer->email = 'james@example.com';$customer->save();
// equivalent to $custmer->update();
4. 删除：
quoteitem::deleteall('quote_id='.self::$_quote_id.' and item_id='.$item_id);
注：使用mysql的时候一定要注意sql注入攻击的屏蔽
# 开始事务
$innertransaction = yii::$app->db->begintransaction(); try { # 保存quoteitems self::removequoteitems($data['item_id']); # 获取quoteitems ，保存到 self::$_quote_items self::getquoteitems(); # 保存 quote self::savequote(); $innertransaction->commit(); } catch (exception $e) { $innertransaction->rollback(); }