yii2 + mysql 常用增删改查操作语法以及事务

关于数据库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()->wh<div style="color:transparent">本文来源gaodai^.ma#com搞#代!码网</div>ere(['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 = '[email protected]';$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();        }

喜欢 (0)赏

[搞代码]

分享 (0)