I have 3 tables.
- posts
- categories
- category_post.
I want to add category_id and post_id in my category_post table when make a post with categories. I have checkbox for categories.
Main theme is, I want to create post with multiple categories. So i want to add category_id and post_id in category_post table.
is it possible with laravel???
I have seen many tutorial and now i am tired. Please help me.
Please see the code below.
My migrations tables:
<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
class CreateCategoriesTable extends Migration {
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('categories', function(Blueprint $table) {
$table->increments('id');
$table->string('name');
$table->string('category_slug');
$table->timestamps();
});
}
public function up()
{
Schema::create('posts', function(Blueprint $table) {
$table->increments('id');
$table->string('title');
$table->string('slug');
$table->string('meta');
$table->text('body');
$table->string('image');
$table->timestamps();
});
}
public function up()
{
Schema::create('category_post', function(Blueprint $table) {
$table->increments('id');
$table->integer('category_id')->unsigned()->index();
$table->foreign('category_id')->references('id')->on('categories')->onDelete('cascade');
$table->integer('post_id')->unsigned()->index();
$table->foreign('post_id')->references('id')->on('posts')->onDelete('cascade');
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('categories');
}
public function down()
{
Schema::drop('posts');
}
public function down()
{
Schema::drop('category_post');
}
}
My post Controller:
<?php
class PostsController extends \BaseController {
/**
* Display a listing of posts
*
* @return Response
*/
public function index()
{
$posts = Post::all();
return View::make('admin.posts.index', compact('posts'));
}
/**
* Show the form for creating a new post
*
* @return Response
*/
public function create()
{
$categories = Category::all();
return View::make('admin.posts.create',compact('categories'));
}
/**
* Store a newly created post in storage.
*
* @return Response
*/
public function store()
{
$validator = Validator::make($data = Input::all(), Post::$rules);
if ($validator->fails())
{
return Redirect::back()->withErrors($validator)->withInput();
}
Post::create($data);
return Redirect::route('admin.posts.index');
}
/**
* Display the specified post.
*
* @param int $id
* @return Response
*/
public function show($id)
{
$post = Post::findOrFail($id);
return View::make('admin.posts.show', compact('post'));
}
/**
* Show the form for editing the specified post.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
$post = Post::find($id);
return View::make('admin.posts.edit', compact('post'));
}
/**
* Update the specified resource in storage.
*
* @param int $id
* @return Response
*/
public function update($id)
{
$post = Post::findOrFail($id);
$validator = Validator::make($data = Input::all(), Post::$rules);
if ($validator->fails())
{
return Redirect::back()->withErrors($validator)->withInput();
}
$post->update($data);
return Redirect::route('admin.posts.index');
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
Post::destroy($id);
return Redirect::route('admin.posts.index');
}
}
My Post Model:
<?php
class Post extends \Eloquent {
// Add your validation rules here
public static $rules = [
'title'=>'required|min:2',
'image'=>'required|image|mimes',
'body' =>'required'
];
// Don't forget to fill this array
protected $fillable = ['title','meta','slug','image','body'];
public function categories()
{
return $this->belongsToMany('Category');
}
}
My Category Controller:
<?php
class CategoriesController extends \BaseController {
public function __construct()
{
$this->beforeFilter('csrf',['on'=>'post']);
}
/**
* Display a listing of categories
*
* @return Response
*/
public function index()
{
$categories = Category::all();
return View::make('admin.categories.index', compact('categories'));
}
/**
* Show the form for creating a new category
*
* @return Response
*/
public function create()
{
return View::make('admin.categories.create');
}
/**
* Store a newly created category in storage.
*
* @return Response
*/
public function store()
{
$validator = Validator::make($data = Input::all(), Category::$rules);
if ($validator->fails())
{
return Redirect::back()->withErrors($validator)->withInput();
}
Category::create($data);
return Redirect::route('admin.categories.index');
}
/**
* Display the specified category.
*
* @param int $id
* @return Response
*/
public function show($id)
{
$category = Category::findOrFail($id);
return View::make('admin.categories.show', compact('category'));
}
/**
* Show the form for editing the specified category.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
$category = Category::find($id);
return View::make('admin.categories.edit', compact('category'));
}
/**
* Update the specified resource in storage.
*
* @param int $id
* @return Response
*/
public function update($id)
{
$category = Category::findOrFail($id);
$validator = Validator::make($data = Input::all(), Category::$rules);
if ($validator->fails())
{
return Redirect::back()->withErrors($validator)->withInput();
}
$category->update($data);
return Redirect::route('admin.categories.index');
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
Category::destroy($id);
return Redirect::route('admin.categories.index');
}
}
My Category Model:
<?php
class Category extends \Eloquent {
protected $fillable = ['name','category_slug'];
public static $rules = ['name'=>'required|min:3','category_slug'=>'required|min:3'];
public function posts()
{
return $this->belongsToMany('Post');
}
}
My Create Post View:
@extends('admin.layouts.main')
@section('content')
<h2>Create Post</h2>
@if ($errors->has())
<div class="error">
<p>The Following errors have</p>
<ul>
@foreach ($errors->all() as $error)
<li>{{ $error }}</li>
@endforeach
</ul>
</div>
@endif
{{ Form::open(array('action' => 'PostsController@store')) }}
<p>
{{ Form::label('title') }}
{{ Form::text('title') }}
</p>
<p>
{{ Form::label('meta') }}
{{ Form::text('meta') }}
</p>
<p>
{{ Form::label('slug') }}
{{ Form::text('slug') }}
</p>
<p>
{{ Form::label('body') }}
{{ Form::text('body') }}
</p>
<p>
@foreach ($categories as $category)
{{ Form::checkbox('category_id', $category->id) }}
{{ Form::label($category->name) }}
@endforeach
</p>
<p>
{{ Form::label('image') }}
{{ Form::text('image') }}
</p>
{{ Form::submit('Crate Post') }}
{{ Form::close() }}
@stop
My Route:
<?php
/*
|--------------------------------------------------------------------------
| Application Routes
|--------------------------------------------------------------------------
|
| Here is where you can register all of the routes for an application.
| It's a breeze. Simply tell Laravel the URIs it should respond to
| and give it the Closure to execute when that URI is requested.
|
*/
Route::get('/', function()
{
return View::make('hello');
});
Route::resource('admin/categories', 'CategoriesController');
Route::resource('admin/posts', 'PostsController');
Please help me. How do i add category_id and post_id in categoy_post table ????????