Laravel 5 ON creating process on a model i get error

Question

In my controller function want to create a model.

class PropertyController extends AdminController {


  public function langUpdate(Request $request)
  {
      $result = PropertyRltLang::create($request->all());
      return back()->with('resultLangUpdate',$result);
  }
}

PropertyRltLang is a model and it's extend my own model class(it's name is MyBaseModel). There is my extended model class:

class MyBaseModel extends Model{

protected static $onInsertRules = [];

protected static $onUpdateRules = [];

public function __construct()
{
    parent::boot();

    static::creating(function($model)
    {
        $input = Input::all();
        $validate = Validator::make($input, $model::$onInsertRules);
        if($validate->fails()){
            return back()->withErrors($validate->errors());
        }
    });
}
}

With true input values i get this error:

2/2 QueryException in Connection.php line 624: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (educate.property_rlt_lang, CONSTRAINT property_rlt_lang_prop_id_foreign FOREIGN KEY (prop_id) REFERENCES properties (id)) (SQL: insert into property_rlt_lang () values ())

But PropertyRltLang model class if extended from Model (Laravel 5 framework class) request with same values are working successfully. Why? And i how to handle "creating" or "save" events? Because reason of create this MyBaseModel class is getting errors when i send a request with wrong values. How to handle this?

Answer 1

if your only trying to get a valid language, then:

protected static $onInsertRules = array('lang' => 'require');
$input = array('lang' => Input::get('lang_name');

you need to look at the validation documentation to find more on how to validate stuff properly. Here

I'm still not 100% sure on what you are trying to validate. If this dosnt fix, could you update your question with more info on what you are trying to do?

Answer 2

2/2 QueryException in Connection.php line 624: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (educate.property_rlt_lang, CONSTRAINT property_rlt_lang_prop_id_foreign FOREIGN KEY (prop_id) REFERENCES properties (id)) (SQL: insert into property_rlt_lang () values ())

This error suggests that your are trying to fill details which does not have any entry in the foreign table.

Also if you are using create() then please define fillable columns of the table e.g:

protected $fillable = ['name', 'email', 'password'];

Answer 3

I give up from this method. And now doing this controls from Request provider. Thanks for interesting..