this is navigation schema
    Schema::create('navigations', function (Blueprint $table) {
        $table->bigIncrements('id');
        $table->string('name');
        $table->timestamps();
    });
this is sub navigation schema
    Schema::create('sub_navigations', function (Blueprint $table) {
        $table->bigIncrements('id');
        $table->bigInteger('nav_id')->unsigned()->index();
        $table->string('name');
        $table->timestamps();
        $table->foreign('nav_id')->references('id')->on('navigations')->onDelete('cascade');
    });
this is navigation model
public function subnavigations(){
    return $this->hasMany('App\Model\Admin\Sub_navigation');
}
this is sub navigation model
public function navigation(){
    return $this->belongsTo('App\Model\Admin\Navigation');
}
controller's code
public function store(Request $request)
{
    //return $request->all();
    $sub_navigation = new Sub_navigation;
    $sub_navigation->name = $request->name;
    $sub_navigation->nav_id = $request->navigation[0];
    //return $sub_navigation;
    //$sub_navigation->save();
    $navigation = Navigation::find($request->navigation[0]);
    // $navigation->subnavigations()->save($sub_navigation);
    //return $navigation;
    $sub_navigation->navigation()->associate($navigation);
    $sub_navigation->save();
    return redirect()->back();
}
this is error message
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'navigation_id' in 'field list' (SQL: insert into sub_navigations (name, nav_id, navigation_id, updated_at, created_at) values (Philosophy, 2, 2, 2019-11-25 02:17:33, 2019-11-25 02:17:33))
via Chebli Mohamed
 
Aucun commentaire:
Enregistrer un commentaire