yii2 查找一个查询
示例
根据ID查找单个记录。
$model = User::findOne($id);
根据ID选择单列。
$model = User::findOne($id)->name;
根据条件从数据库中检索单个记录。
$model = User::find()->one(); //给出第一记录 $model = User::find()->where(['id' => 2])->one(); //根据ID给出单个记录
根据条件从数据库中选择单列记录。
$model = User::find()->select('name,email_id')->where(['id' => 1])->one();
要么
$model = User::find()->select(['id','name','email_id'])->where(['id' => 1])->one();
按订单
$model = User::find()->select(['id','name','email_id'])->orderBy(['id' => SORT_DESC])->one(); OR $model = User::find()->select(['id','name','email_id'])->orderBy(['id' => SORT_ASC])->one();