Eloquent ORM is Laravel\u2019s built-in Object Relational Mapping system that allows developers to interact with databases using PHP syntax instead of writing complex SQL queries.<\/p>\n\n\n\n
Eloquent makes database operations simple, readable, and efficient by representing database tables as models and records as objects.<\/p>\n\n\n\n
It is one of the most powerful features of the Laravel framework and is widely used for modern web application development.<\/p>\n\n\n\n
By the end of this training, you will be able to:<\/p>\n\n\n\n
ORM stands for Object Relational Mapping.<\/p>\n\n\n\n
It is a programming technique that connects database tables with object-oriented programming languages.<\/p>\n\n\n\n
Instead of writing SQL queries manually, developers can use PHP classes and methods to interact with the database.<\/p>\n\n\n\n
Example:<\/p>\n\n\n\n
Traditional SQL Query:<\/p>\n\n\n\n
SELECT * FROM users;<\/code><\/pre>\n\n\n\nEloquent ORM Query:<\/p>\n\n\n\n
$users = User::all();<\/code><\/pre>\n\n\n\nFeatures of Eloquent ORM<\/h2>\n\n\n\nSimple Database Interaction<\/h3>\n\n\n\n
Eloquent allows developers to insert, update, delete, and retrieve data using clean syntax.<\/p>\n\n\n\n
Active Record Pattern<\/h3>\n\n\n\n
Each database table is connected to a model class.<\/p>\n\n\n\n
Built-in Relationships<\/h3>\n\n\n\n
Eloquent supports one-to-one, one-to-many, many-to-many, and polymorphic relationships.<\/p>\n\n\n\n
Query Builder Integration<\/h3>\n\n\n\n
Eloquent includes Laravel\u2019s powerful query builder for advanced database queries.<\/p>\n\n\n\n
Secure and Efficient<\/h3>\n\n\n\n
It helps protect applications from SQL injection attacks through parameter binding.<\/p>\n\n\n\n
Creating an Eloquent Model<\/h2>\n\n\n\n
Models represent database tables in Laravel.<\/p>\n\n\n\n
Command to create a model:<\/p>\n\n\n\n
php artisan make:model User<\/code><\/pre>\n\n\n\nExample Model:<\/p>\n\n\n\n
<?php
namespace App\\Models;
use Illuminate\\Database\\Eloquent\\Model;
class User extends Model
{
protected $table = 'users';
}<\/code><\/pre>\n\n\n\nDatabase Configuration<\/h2>\n\n\n\n
Database settings are stored in the .env<\/code> file.<\/p>\n\n\n\nExample:<\/p>\n\n\n\n
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=training_db
DB_USERNAME=root
DB_PASSWORD=<\/code><\/pre>\n\n\n\nRetrieving Data with Eloquent<\/h2>\n\n\n\nGet All Records<\/h3>\n\n\n\n$users = User::all();<\/code><\/pre>\n\n\n\nFind Record by ID<\/h3>\n\n\n\n$user = User::find(1);<\/code><\/pre>\n\n\n\nRetrieve First Record<\/h3>\n\n\n\n$user = User::first();<\/code><\/pre>\n\n\n\nUsing Conditions<\/h3>\n\n\n\n$users = User::where('status', 'active')->get();<\/code><\/pre>\n\n\n\nInserting Data<\/h2>\n\n\n\n$user = new User();
$user->name = 'Ali';
$user->email = 'ali@example.com';
$user->save();<\/code><\/pre>\n\n\n\nUpdating Data<\/h2>\n\n\n\n$user = User::find(1);
$user->name = 'Ahmed';
$user->save();<\/code><\/pre>\n\n\n\nDeleting Data<\/h2>\n\n\n\n$user = User::find(1);
$user->delete();<\/code><\/pre>\n\n\n\nMass Assignment<\/h2>\n\n\n\n
Eloquent allows mass assignment for inserting multiple fields.<\/p>\n\n\n\n
class User extends Model
{
protected $fillable = ['name', 'email'];
}<\/code><\/pre>\n\n\n\nExample:<\/p>\n\n\n\n
User::create([
'name' => 'Ali',
'email' => 'ali@example.com'
]);<\/code><\/pre>\n\n\n\nEloquent Relationships<\/h2>\n\n\n\nOne-to-One Relationship<\/h3>\n\n\n\npublic function profile()
{
return $this->hasOne(Profile::class);
}<\/code><\/pre>\n\n\n\nOne-to-Many Relationship<\/h3>\n\n\n\npublic function posts()
{
return $this->hasMany(Post::class);
}<\/code><\/pre>\n\n\n\nMany-to-Many Relationship<\/h3>\n\n\n\npublic function roles()
{
return $this->belongsToMany(Role::class);
}<\/code><\/pre>\n\n\n\nUsing Migrations with Eloquent<\/h2>\n\n\n\n
Migration command:<\/p>\n\n\n\n
php artisan make:migration create_users_table<\/code><\/pre>\n\n\n\nExample Migration:<\/p>\n\n\n\n
Schema::create('users', function ($table) {
$table->id();
$table->string('name');
$table->string('email');
$table->timestamps();
});<\/code><\/pre>\n\n\n\nRun migration:<\/p>\n\n\n\n
php artisan migrate<\/code><\/pre>\n\n\n\nEloquent Query Builder<\/h2>\n\n\n\nOrdering Data<\/h3>\n\n\n\n$users = User::orderBy('name', 'ASC')->get();<\/code><\/pre>\n\n\n\nLimiting Results<\/h3>\n\n\n\n$users = User::take(5)->get();<\/code><\/pre>\n\n\n\nCounting Records<\/h3>\n\n\n\n$count = User::count();<\/code><\/pre>\n\n\n\nAdvantages of Eloquent ORM<\/h2>\n\n\n\n\n- Easy to learn and use<\/li>\n\n\n\n
- Reduces SQL complexity<\/li>\n\n\n\n
- Clean and readable code<\/li>\n\n\n\n
- Faster application development<\/li>\n\n\n\n
- Secure database interaction<\/li>\n\n\n\n
- Supports powerful relationships<\/li>\n\n\n\n
- Integrated with Laravel framework<\/li>\n<\/ul>\n\n\n\n
Best Practices<\/h2>\n\n\n\n\n- Use meaningful model names<\/li>\n\n\n\n
- Protect fields using fillable property<\/li>\n\n\n\n
- Use migrations for database management<\/li>\n\n\n\n
- Optimize queries to improve performance<\/li>\n\n\n\n
- Use relationships instead of manual joins where possible<\/li>\n<\/ul>\n\n\n\n
Real World Applications<\/h2>\n\n\n\n
Eloquent ORM is commonly used in:<\/p>\n\n\n\n
\n- E-commerce applications<\/li>\n\n\n\n
- Content management systems<\/li>\n\n\n\n
- Learning management systems<\/li>\n\n\n\n
- CRM software<\/li>\n\n\n\n
- Inventory systems<\/li>\n\n\n\n
- Social media platforms<\/li>\n<\/ul>\n\n\n\n
Career Opportunities<\/h2>\n\n\n\n
Learning Eloquent ORM can help you become:<\/p>\n\n\n\n
\n- Laravel Developer<\/li>\n\n\n\n
- Backend Developer<\/li>\n\n\n\n
- Full Stack Web Developer<\/li>\n\n\n\n
- PHP Application Developer<\/li>\n\n\n\n
- API Developer<\/li>\n<\/ul>\n\n\n\n
Final Presentation<\/h2>\n\n\n\n
In your final presentation, explain:<\/p>\n\n\n\n
\n- What Eloquent ORM is<\/li>\n\n\n\n
- Benefits of ORM in web development<\/li>\n\n\n\n
- How Eloquent interacts with databases<\/li>\n\n\n\n
- CRUD operations using Eloquent<\/li>\n\n\n\n
- Relationships in Eloquent ORM<\/li>\n\n\n\n
- Real-world usage of Eloquent in Laravel applications<\/li>\n<\/ul>\n\n\n