Saving Form Data Into Database Table YII2

Question

So I'm trying to get information through a Yii2 form and save it into the database, though it won't work. I'm getting the success flash message, but no changes are made into the database.

Controller file:

<?php

namespace frontend\modules\portfolio\controllers;

use Yii;
use yii\web\Controller;
use frontend\modules\portfolio\models\LandingPage;
use common\models\HelloMessage;

class HelloController extends Controller {

    public function actionIndex() {

        $form_model = new HelloMessage();
        $request    = Yii::$app->request; 

        if ($form_model->load(Yii::$app->request->post())) {
            $form_model->name = $request->post('name');
            $form_model->email = $request->post('email');
            $form_model->message = $request->post('message');

            $form_model->save();
            Yii::$app->getSession()->setFlash('success', 'Your message has been successfully recorded.');
        }

        return $this->render('index', [
            'form_model' => $form_model
        ]);
    }

}

And this would be the View file:

        <div class="box">
            <?= Yii::$app->session->getFlash('success'); ?>

            <?php $form = ActiveForm::begin(); ?>

            <?= $form->field($form_model, 'name')->textInput(['maxlength' => true]) ?>

            <?= $form->field($form_model, 'email')->textInput(['maxlength' => true]) ?>

            <?= $form->field($form_model, 'message')->textarea(['maxlength' => true]) ?>

            <div class="form-group">
                <?= Html::submitButton('Submit', ['name' => 'contact-button']); ?>
            </div>

            <?php ActiveForm::end(); ?>
        </div>

Why are you not checking if save() returned true?

Bizley
– Bizley

2017-05-03 08:44:26 +00:00
Commented May 3, 2017 at 8:44 — Bizley
– Bizley, Commented May 3, 2017 at 8:44

Elmi Ahmadov · Accepted Answer · 2017-05-03 10:01:37Z

2

change your index action like that

    $form_model = new HelloMessage();
    $postData   = Yii::$app->request->post(); 

    if ($form_model->load($postData)) {
        if (!$form_model->save()) 
            print_r($form_model->getErrors()); // this would be helpful to find problem.
        else 
            Yii::$app->getSession()->setFlash('success', 'Your message has been successfully recorded.');
    }

    return $this->render('index', [
        'form_model' => $form_model
    ]);
}

answered May 3, 2017 at 10:01

Elmi Ahmadov

1,0455 gold badges14 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

gmc · Accepted Answer · 2018-01-10 21:35:10Z

1

Most likely your model fails validation. You can turn if off using $form_model->save(false), but it is better to know why it is not validating. Do this:

if (!$form_model->validate()) {
  return $this->render('index', [
            'form_model' => $form_model
        ]);
}

edited Jan 10, 2018 at 21:35

answered May 3, 2017 at 8:35

gmc

4,0303 gold badges34 silver badges47 bronze badges

3 Comments

Moldovan Andrei Over a year ago

Not getting any errors whatsoever. I've var dumped the form fields in the view file - after form submission, no data is present in the $form_model->name.

gmc Over a year ago

Remove the lines where you assign values to your model fields, let it with just the load method

Moldovan Andrei Over a year ago

The $form_model->save() doesn't work for some reason. The model fields are not empty, so the information is transmitted with the $_POST method.

Moldovan Andrei · Accepted Answer · 2017-05-03 10:11:41Z

0

Ok, so I've found the solution: $model->save(false) - without any validation. Will try to sort out the validation rules in the future.

answered May 3, 2017 at 10:11

Moldovan Andrei

3151 gold badge6 silver badges19 bronze badges

Collectives™ on Stack Overflow

Saving Form Data Into Database Table YII2

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related