-
$order=$customer->getOrders(); //下面的等同于上面的代碼 $order=$customer->orders; //即使orders在customer沒(méi)有定義過(guò)，yii2 使用__get() 函數(shù)，生成getOrders() 再補(bǔ)全all() 函數(shù)。 所以在1對(duì)多的getOrders() 函數(shù)中,不必需要在后面加上all() 方法了。 $orders=$this->hasMany(Order::className(),["customer_id"=>"id"])->asArray(); return $orders;查看全部
-
一對(duì)多查詢 $test=Customer::find()->where(["name"=>"張三"])->one(); $res=$test->hasMany("app\models\Order",["customer_id"=>"id"])->all(); // 或者 把 “app\models\order”替換成 "Order::claaName()"查看全部
-
修改數(shù)據(jù) $test=Test::find()->where->(["name"=>"hehys"])->one(); $test->name="上島費(fèi)"; $test->save();查看全部
-
$sql="select * from test where id=:id" 占位符 防止sql 攻擊 $results=Test::findBySql("$sql",array(":id"=>1))->all();查看全部
-
like between查看全部
-
關(guān)聯(lián)查詢結(jié)果緩存 unset($customer->orders) //關(guān)聯(lián)查詢的多次查詢 $customers = Customer::find()->with('orders')->all() foreach($customers as $customer){ $orders = $customer->orders }查看全部
-
public function getOrders(){ $orders = $this->hasMany(Order:className(),['customer_id'=>'id'])->asArray()->all() return $orders; }查看全部
-
hasMany:一對(duì)多，hasone一對(duì)一 ， $customer = Customer::find()->where(['name'=>'zhangsan'])->all()//返回?cái)?shù)組 $customer = Customer::find()->where(['name'=>'zhangsan'])->one()//返回對(duì)象 $customer->hasMany('app\models\Order',['customer_id'=>'id'])->all();查看全部
-
//$results = Test::find()->where(['id'=>1])->all(); $results[0]->delete(); Test::deleteAll('id>:id',array(':id'=>0))查看全部
-
查詢結(jié)果變成數(shù)組$results = Test::find()->where(['between','id',1,2])->asArray()->all();查看全部
-
//id=1 $results = Test::find()->where(['id'=>1])->all(); //id>0 $results = Test::find()->where(['>','id',0])->all(); //id>=0且id<=2 $results = Test::find()->where(['between','id',1,2])->all();查看全部
-
findBySql提供占位符，防止sql注入查看全部
-
<?php namespace app\Controllers use yii\web\Controller use app\models\Test查看全部
-
namespace app\models use yii\db\ActiveRecord class Test extends ActiveRecord{}//與數(shù)據(jù)庫(kù)中表的名字一致查看全部
-
如果一個(gè)頁(yè)面向另一個(gè)頁(yè)面?zhèn)鬟f參數(shù)，這個(gè)頁(yè)面直接用<?對(duì)應(yīng)的變量名稱?>來(lái)接受查看全部
舉報(bào)
0/150
提交
取消