Eloquent CheatSheet

 PHP 

Laravel Eloquent Cheat Sheet

🚀 1. Basic Retrieval

User::all();
User::find(5);
User::findOrFail(5);
User::where('status', 'active')->first();

🔍 2. Filtering Queries

// Simple where
User::where('status', 'active')->get();

// Multiple conditions
User::where('status', 'active')->where('role', 'admin')->get();

// OR
User::where('role', 'admin')->orWhere('role', 'manager')->get();

// whereIn
User::whereIn('id', [1,2,3])->get();

// whereBetween
Order::whereBetween('amount', [100, 500])->get();

// whereNull
User::whereNull('email_verified_at')->get();

✏️ 3. Insert / Update / Delete

// Create
User::create([
    'name' => 'Ranjit',
    'email' => 'ranjit@example.com',
    'password' => bcrypt('123456')
]);

// Save
$user = new User();
$user->name = 'Ranjit';
$user->email = 'ranjit@example.com';
$user->password = bcrypt('123456');
$user->save();

// Update
User::where('id', 5)->update(['name' => 'Updated Name']);

// Delete
User::find(5)->delete();
User::destroy([1,2,3]);

📊 4. Aggregates

User::count();
Order::max('amount');
Order::min('amount');
Order::sum('amount');
Order::avg('amount');

🔗 5. Relationships

➤ One-to-One

public function profile() {
    return $this->hasOne(Profile::class);
}

➤ One-to-Many

public function comments() {
    return $this->hasMany(Comment::class);
}

➤ Belongs To

public function post() {
    return $this->belongsTo(Post::class);
}

➤ Many-to-Many

public function courses() {
    return $this->belongsToMany(Course::class);
}

⚡ 6. Eager Loading

Post::with('comments', 'category')->get();
$post->load('comments');

---

📄 7. Pagination

User::paginate(10);
User::simplePaginate(15);

🗂️ 8. Soft Deletes

Model Setup

use Illuminate\Database\Eloquent\SoftDeletes;

class User extends Model {
    use SoftDeletes;
}

Soft Delete Queries

User::withTrashed()->get();
User::onlyTrashed()->get();
User::withTrashed()->find(5)->restore();