skip to Main Content

SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint (SQL: alter table – Laravel

i have three migrations 2022_09_20_021431_create_posts_table.php Schema::create('posts', function (Blueprint $table) { $table->increments('id'); $table->string('title', 100); $table->text('body'); }); 2022_09_21_021455_create_category_posts_table.php Schema::create('category_posts', function (Blueprint $table) { $table->unsignedBigInteger('category_id')->nullable(); $table->unsignedBigInteger('post_id')->nullable(); $table->primary(['category_id', 'post_id']); $table->foreign('category_id')->references('id')->on('categories')->onUpdate('cascade')->onDelete('cascade'); $table->foreign('post_id')->references('id')->on('posts')->onUpdate('cascade')->onDelete('cascade'); }); 2022_09_28_021507_create_categories_table.php Schema::create('categories', function (Blueprint $table) { $table->increments('id'); $table->string('name', 100); }); i found…

VIEW QUESTION

Laravel show with relationships

How do you use the show function relationships? i know this works: public show ($id) { Model::with('relationship')->find($id); } but with the new format public show(Model $model) { } how do you include the relationship? i've tried $model->with('relationship')->get(); but it changes…

VIEW QUESTION
Back To Top
Search