Laravel one to many eloquent relationship tutorial example – onlinecode

Laravel one to many eloquent relationship tutorial example – onlinecode

In this post we will give you information about Laravel one to many eloquent relationship tutorial example – onlinecode. Hear we will give you detail about Laravel one to many eloquent relationship tutorial example – onlinecodeAnd how to use it also give you demo for it if it is necessary.

In this tutorial, today we discuss laravel one to many Eloquent relationships. Eloquent ORM means Object-relational Mapping and laravel provides a beautiful ActiveRecord structure. so we can easy to interact with the application database. let’s start about one to many eloquent relationships.

Laravel one to many relationships is based work on the one table row connected with multiple tables rows. For example, the category has multiple products.

Setting Database Configuration

After complete installation of laravel. we have to database configuration. now we will open the .env file and change the database name, username, password in the .env file. See below changes in a .env file.

PHP
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=Enter_Your_Database_Name(one_to_many_relation)
DB_USERNAME=Enter_Your_Database_Username(root)
DB_PASSWORD=Enter_Your_Database_Password(root)

Create Table using migration

Now, We need to create a migration. so we will below command using create the categories and products table migration.

PHP
php artisan make:migration create_categories_table --create=categories
php artisan make:migration create_products_table --create=products

After complete migration. we need below changes in the database/migrations/create_categories_table and database/migrations/create_products_table file..

create_categories_table.php

PHP
<?php
use IlluminateSupportFacadesSchema;
use IlluminateDatabaseSchemaBlueprint;
use IlluminateDatabaseMigrationsMigration;
class CreateCategoriesTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('categories', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->string('name');
            $table->timestamps();
        });
    }
    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('categories');
    }
}
?>

create_products_table.php

PHP
<?php
use IlluminateSupportFacadesSchema;
use IlluminateDatabaseSchemaBlueprint;
use IlluminateDatabaseMigrationsMigration;
class CreateProductsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('products', function (Blueprint $table) {
            $table->bigIncrements('id');
			$table->integer('category_id')->unsigned();
            $table->string('title');
            $table->timestamps();
			$table->foreign('category_id')->references('id')->on('categories')->onDelete('cascade');
        });
    }
    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('products');
    }
}
?>

Run the below command. after the changes above file.

php artisan migrate

Create Model

Here below command help through we will create the Category and Product model. we will also use “hasMany()” for a category model and “belongsTo()” for a product model.

PHP
php artisan make:model Category
php artisan make:model Product

Category.php

PHP
<?php
namespace App;
use IlluminateDatabaseEloquentModel;
class Category extends Model
{
    protected $fillable = [
        'name'
    ];
	
	/**
     * Get the products for the category.
     */
    public function products()
    {
        return $this->hasMany('AppProduct');
    }
}
?>

Product.php

PHP
<?php
namespace App;
use IlluminateDatabaseEloquentModel;
class Product extends Model
{
    /**
     * Get the category that owns the product.
     */
    public function category()
    {
        return $this->belongsTo('AppCategory');
    }
}

?>

Route and Controller

We have to need put below code route in routes/web.

PHP
<?php
 
/*
|--------------------------------------------------------------------------
| Web Routes
|--------------------------------------------------------------------------
|
| Here is where you can register web routes for your application. These
| routes are loaded by the RouteServiceProvider within a group which
| contains the "web" middleware group. Now create something great!
|
*/
 
Route::get('/', function () {
    return view('welcome');
});
 
Route::get('product','productsController@index');

?>

Here below command help to create the product controller.

PHP
php artisan make:controller ProductsController

ProductsController.php

PHP
<?php
namespace AppHttpControllers;
use AppProduct;
use AppCategory;
use IlluminateHttpRequest;
class ProductsController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return IlluminateHttpResponse
     */
    public function index()
    {
        //get Products data
        $product = Category::find(1)->products;
	dd($product);
		
	//get categories data
	$category = Product::find(1)->category;
	dd($category);
    }

}
?>

Please follow and like us:

Hope this code and post will helped you for implement Laravel one to many eloquent relationship tutorial example – onlinecode. if you need any help or any feedback give it in comment section or you have good idea about this post you can give it comment section. Your comment will help us for help you more and improve us. we will give you this type of more interesting post in featured also so, For more interesting post and code Keep reading our blogs

For More Info See :: laravel And github

Leave a Comment

Your email address will not be published. Required fields are marked *

1  +    =  9

We accept paid advance and paid guest Posting on our Site : Contact US