CoderFunda
  • Home
  • About us
    • Contact Us
    • Disclaimer
    • Privacy Policy
    • About us
  • Home
  • Php
  • HTML
  • CSS
  • JavaScript
    • JavaScript
    • Jquery
    • JqueryUI
    • Stock
  • SQL
  • Vue.Js
  • Python
  • Wordpress
  • C++
    • C++
    • C
  • Laravel
    • Laravel
      • Overview
      • Namespaces
      • Middleware
      • Routing
      • Configuration
      • Application Structure
      • Installation
    • Overview
  • DBMS
    • DBMS
      • PL/SQL
      • SQLite
      • MongoDB
      • Cassandra
      • MySQL
      • Oracle
      • CouchDB
      • Neo4j
      • DB2
      • Quiz
    • Overview
  • Entertainment
    • TV Series Update
    • Movie Review
    • Movie Review
  • More
    • Vue. Js
    • Php Question
    • Php Interview Question
    • Laravel Interview Question
    • SQL Interview Question
    • IAS Interview Question
    • PCS Interview Question
    • Technology
    • Other

20 February, 2021

Laravel Cheat Sheet for Eloquent ORM Zero To Master

 Programing Coderfunda     February 20, 2021     Cheat Sheet-Laravel     No comments   

 ORM (Object Relational Mapping) is used to facilitate database CRUD operations. Laravel comes with Eloquent ORM. This tutorial was created to provide part of Laravel Eloquent ORM’s frequently used scam sheet

  1. Ordering Eloquent hasMany() relationship

Add ->orderBy() to the hasMany relationship to get ordered output of a specified column.

return $this->hasMany('Detail::class')->orderBy('column');
Code language: PHP (php)
  1. Eloquent’s where() method

Here are some useful cheat sheet for eloquent’s where() method.

$detail = Detail::where("id","!=",50)->get();
// Any of the following may be used as the second parameter (and use the third param for the value)
// =, <, >, <=, >=, <>, !=, LIKE, NOT LIKE, BETWEEN, ILIKE

$detail = Detail::where(function ($query) {
$query->where('a', '=', 1)
->orWhere('b', '=', 1);
})->get();

$detail = Detail::whereRaw('age > ? and votes = 100', array(25))->get();

$detail = Detail::whereRaw(DB::raw("id in (select detail_id from students GROUP BY students.detail_id)"))->get();

$detail = Detail::whereExists(function($query){
$query->select(DB::raw(1))
->from('students')
->whereRaw('students.detail_id = details.id')
->groupBy('students.detail_id')
->havingRaw("COUNT(*) > 0");
})->get();
// Any of the following may be used instead of Detail::whereExists
// ->orWhereExists(), ->whereNotExists(), ->orWhereNotExists()

$detail = Detail::whereIn('column',[1,2,3])->get();
// Any of the following may be used instead of Detail::whereExists
// ->orWhereIn(),

$detail = Detail::whereNotIn('id', function($query){
$query->select('student_id')
->from('students')
->groupBy('students.student_id');
})->get();

// Any of the following may be used instead of Detail::whereExists
// ->whereNotIn(), ->orWhereNotIn
Code language: PHP (php)

Here are some more useful cheat sheet for NULL or NOT NULL in laravel eloquent.

->whereNull('column')
->orWhereNull('column')
->whereNotNull('column')
->orWhereNotNull('column')
Code language: PHP (php)

Cheat sheet to filter by Day, Month, Year, Date options.

->whereDay()
->whereMonth('column', '=', 1)
->whereYear('column', '>', 2019)
->whereDate('column', '>', '2019-05-05')
Code language: PHP (php)
  1. Prevent Eloquent from adding created_at or updated_at timestamps

Disable both created_at and updated_at in the model to disable the timestamps

const UPDATED_AT = null;
const CREATED_AT = null;
Code language: JavaScript (javascript)

Make sure to remove this from the migration

$table->timestamps()
Code language: PHP (php)
  1. restore() soft deleted Eloquent

Use the restore() method to undelete a record.

User::withTrashed()->where("id",1)->restore()
Code language: PHP (php)

Make sure to add following lines in the model to enable SoftDeletes.

use SoftDeletes;
Code language: PHP (php)
  1. Joins in Eloquent

Here are some useful cheat sheet for eloquent’s join() method.

$product = Product:where('id', $productId)
->join('businesses','product.business_id','=','businesses.id')
->select('product.id','businesses.name')->first();

$product = Product:where('id', $productId)
->leftJoin('businesses','product.business_id', '=', 'businesses.id')
->select('product.id','businesses.name')->first();

$product = Product:where('id', $productId)
->join('businesses',function($join) use($cats) {
$join->on('product.business_id', '=', 'businesses.id')
->on('product.id', '=', $cats, 'and', true);})->first();
Code language: PHP (php)
  1. Find an item by Primary Key in Eloquent, or throw a ModelNotFoundException

findOrFail($id) method will find a model by it’s primary key or throw an exception if it’s not available.

$id = 10001;
$user = User::findOrFail($id);
Code language: PHP (php)
  1. Cache in Eloquent

You can retrieve an item from the cache without loading it all the item.

$details = Cache::remember('details', $seconds, function () {
return DB::table('details')->get();
});
Code language: PHP (php)

rememberForever method is used to retrieve an item from the cache or store it forever

$details = Cache::rememberForever('details', function () {
return DB::table('details')->get();
});
    • Share This:  
    •  Facebook
    •  Twitter
    •  Google+
    •  Stumble
    •  Digg
    Email ThisBlogThis!Share to XShare to Facebook
    Newer Post Older Post Home

    0 comments:

    Post a Comment

    Thanks

    Meta

    Popular Posts

    • Credit card validation in laravel
        Validation rules for credit card using laravel-validation-rules/credit-card package in laravel Install package laravel-validation-rules/cr...
    • Write API Integrations in Laravel and PHP Projects with Saloon
      Write API Integrations in Laravel and PHP Projects with Saloon Saloon  is a Laravel/PHP package that allows you to write your API integratio...
    • iOS 17 Force Screen Rotation not working on iPAD only
      I have followed all the links on Google and StackOverFlow, unfortunately, I could not find any reliable solution Specifically for iPad devic...
    • C++ in Hindi Introduction
      C ++ का परिचय C ++ एक ऑब्जेक्ट ओरिएंटेड प्रोग्रामिंग लैंग्वेज है। C ++ को Bjarne Stroustrup द्वारा विकसित किया गया था। C ++ में आने से पह...
    • Python AttributeError: 'str' has no attribute glob
      I am trying to look for a folder in a directory but I am getting the error.AttributeError: 'str' has no attribute glob Here's ...

    Categories

    • Ajax (26)
    • Bootstrap (30)
    • DBMS (42)
    • HTML (12)
    • HTML5 (45)
    • JavaScript (10)
    • Jquery (34)
    • Jquery UI (2)
    • JqueryUI (32)
    • Laravel (1017)
    • Laravel Tutorials (23)
    • Laravel-Question (6)
    • Magento (9)
    • Magento 2 (95)
    • MariaDB (1)
    • MySql Tutorial (2)
    • PHP-Interview-Questions (3)
    • Php Question (13)
    • Python (36)
    • RDBMS (13)
    • SQL Tutorial (79)
    • Vue.js Tutorial (68)
    • Wordpress (150)
    • Wordpress Theme (3)
    • codeigniter (108)
    • oops (4)
    • php (853)

    Social Media Links

    • Follow on Twitter
    • Like on Facebook
    • Subscribe on Youtube
    • Follow on Instagram

    Pages

    • Home
    • Contact Us
    • Privacy Policy
    • About us

    Blog Archive

    • July (2)
    • September (100)
    • August (50)
    • July (56)
    • June (46)
    • May (59)
    • April (50)
    • March (60)
    • February (42)
    • January (53)
    • December (58)
    • November (61)
    • October (39)
    • September (36)
    • August (36)
    • July (34)
    • June (34)
    • May (36)
    • April (29)
    • March (82)
    • February (1)
    • January (8)
    • December (14)
    • November (41)
    • October (13)
    • September (5)
    • August (48)
    • July (9)
    • June (6)
    • May (119)
    • April (259)
    • March (122)
    • February (368)
    • January (33)
    • October (2)
    • July (11)
    • June (29)
    • May (25)
    • April (168)
    • March (93)
    • February (60)
    • January (28)
    • December (195)
    • November (24)
    • October (40)
    • September (55)
    • August (6)
    • July (48)
    • May (2)
    • January (2)
    • July (6)
    • June (6)
    • February (17)
    • January (69)
    • December (122)
    • November (56)
    • October (92)
    • September (76)
    • August (6)

    Loading...

    Laravel News

    Loading...

    Copyright © CoderFunda | Powered by Blogger
    Design by Coderfunda | Blogger Theme by Coderfunda | Distributed By Coderfunda