/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = SocialmediaPlatform::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(['sp_id' => $this->sp_id]); $query->andFilterWhere(['like', 'sp_logo', $this->sp_logo])->andFilterWhere(['like', 'sp_name', $this->sp_name])->andFilterWhere(['like', 'sp_description', $this->sp_description]); return $dataProvider; }
public function actionGetallsocialmediaplatform() { $sp = new SocialmediaPlatform(); $sp = SocialmediaPlatform::find()->all(); return $sp; }
/** * @return \yii\db\ActiveQuery */ public function getSp() { return $this->hasOne(SocialmediaPlatform::className(), ['sp_id' => 'sp_id']); }