public function actionChoose($car) { // $query1 = (new Query())->select('model_name')->from('cars'); // $data1=$query1->all(); //$query = (new Query())->select('username')->from('user')->where('dealer=1'); //data=$query->all(); // $dataProvider = new ActiveDataProvider([ // 'query' => Car::find(), // ]); //$model = new RequestForm(); $signup = new SignupForm(); if ($signup->load(Yii::$app->request->post())) { if ($signup->signup2()) { return $this->render('congrats', ['email' => $signup->email]); $modlogin = new LoginForm(); $modlogin->username = $signup->email; $modlogin->password = $signup->password; $user = $signup->email; $use = new User(); $val = $use->findByUsername1($user); $auth = $val->status; $query2 = (new Query())->select('id,car_model,color,variant,city')->from('userrequest')->where('user_id=:id', array(':id' => $val->id)); $data2 = $query->all(); $dataProvider1 = new ActiveDataProvider(['query' => $query]); $dataProvider2 = new ActiveDataProvider(['query' => $query2]); $query3 = (new Query())->select('dealer_name,car_model,price,feature')->from('reply')->where('username=:username', array(':username' => $user)); $dataProvider3 = new ActiveDataProvider(['query' => $query3]); return $this->render('userdashboard', ['dataProvider2' => $dataProvider2, 'dataProvider1' => $dataProvider1, 'dataProvider3' => $dataProvider3, 'data' => $data, 'data1' => $data1, 'data2' => $data2, 'user' => $user, 'auth' => $auth]); } } $signup = new SignupForm(); $mod = new RequestFormindex(); if ($mod->load(Yii::$app->request->post())) { $signup->brand = $mod->brand; $signup->model_name = $mod->model_name; $signup->fuel = $mod->fuel; $email = "*****@*****.**"; \Yii::$app->mailer->compose(['html' => 'use-html'], ['user' => $signup])->setFrom([\Yii::$app->params['supportEmail'] => 'Home Page Request'])->setTo($email)->setSubject('Home Page Request' . \Yii::$app->name)->send(); return $this->render('choose', ['signup' => $signup]); } $mod = new RequestFormindex(); //$var = Car::find()->where(['modebrand' => $car])->one(); $var = Ncars::find()->where(['modebrand' => $car])->one(); $pieces = explode(" ", $car); if ($var) { $signup->brand = $var->model; $signup->model_name = $var->model_name; $email = "*****@*****.**"; \Yii::$app->mailer->compose(['html' => 'use-html'], ['user' => $signup])->setFrom([\Yii::$app->params['supportEmail'] => 'Home Page Request'])->setTo($email)->setSubject('Home Page Request')->send(); return $this->render('choose', ['mod' => $mod, 'car' => $car, 'signup' => $signup]); } else { return $this->redirect('../index', ['mod' => $mod]); } }