예제 #1
0
 public function actionShow()
 {
     // 获取 country 表的所有行并以 name 排序,返回的是一个二维数组
     $world = World::find()->orderBy('id')->all();
     var_dump($world[0]["user"]);
     echo "<br/>";
     var_dump($world[0]->user);
 }
예제 #2
0
 public function actionTest()
 {
     $var = new World();
     echo $var->world();
     $var = World::find()->where(["id" => 1])->one();
     var_dump($var['id']);
     var_dump($var['user']);
     var_dump($var);
     //$command = $connection->createCommand('SELECT * FROM world');
     //var_dump(World::model()->findByPk(1));
     //var_dump($command);
     die;
 }
예제 #3
0
파일: World.php 프로젝트: buchongyu/yii2
 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = WorldModel::find();
     $dataProvider = new ActiveDataProvider(['query' => $query]);
     $this->load($params);
     if (!$this->validate()) {
         // uncomment the following line if you do not want to return any records when validation fails
         // $query->where('0=1');
         return $dataProvider;
     }
     $query->andFilterWhere(['id' => $this->id]);
     $query->andFilterWhere(['like', 'user', $this->user]);
     return $dataProvider;
 }