yii2

I'm trying to connect a relation table, and and get the max value $query->joinWith('hotelPrices') ->andWhere([HotelPrice::tableName() . '.price' => $form->prices]) ->max(HotelPrice::tableName() . '.price'); but i get this error SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'hotel_price' how to…

I'm trying to get data from a model. $profile = Profile::findOne(['user_id'=>$appointment->user_id]); $diabetes = $profile->diabetes; I get an error Trying to get property 'diabetes' of non-object. Tried to check the availability of data through: $profile->getAttributes(['diabetes']) Data present! But I can't use…

There is my Function to download backup is sql format public function actionBackup() { // Set the database access credentials $db_host = 'localhost'; $db_username = 'root'; $db_password = ''; $db_name = 'fads'; // Set the backup filename and path $backup_file…

There is my controller code if ($this->request->isPost) { $model->created_by = Yii::$app->user->identity->id; $model->created_at = date('Y/m/d'); // echo $model->created_at;die; if ($model->load($this->request->post()) && $model->save()) { return $this->redirect(['index', 'id' => $model->id]); } } and there is my model rule public function rules() { return…

I have a main model and it has a field rules: class User extends yiidbActiveRecord { /** * {@inheritdoc} */ public static function tableName() { return 'users'; } /** * {@inheritdoc} */ public function rules() { return [ [['username', 'email'],…