{"flag":true,"single":true,"pageTitle":"Eloquent ORM Model, CRUD operations,","post":{"id":18,"user_id":"1","slug":"eloquent-crud-nvwb","title":"Eloquent ORM Model, CRUD operations,","body":"

Laravel includes Eloquent, an object-relational mapper (ORM) that  interact with database. Each database table has a corresponding \"Model\" that is used to interact with that table.<\/p>\r\n

Eloquent models allow you to insert, update, and delete records<\/strong> from the table as well.<\/p>\r\n

You can create model using<\/p>\r\n

Model stays app\\Models <\/strong>directory<\/p>\r\n

php artisan make:model Flight<\/code><\/pre>\r\n
php artisan make:model Flight --migration \/\/model with migration<\/code><\/pre>\r\n
php artisan make:model Flight --factory \/\/model with factory<\/code><\/pre>\r\n
php artisan make:model Flight --seed \/\/model with seeder<\/code><\/pre>\r\n
php artisan make:model Flight --controlle\/\/model with controller<\/code><\/pre>\r\n
# Shortcut to generate a model, migration, factory, seeder, policy, controller, and form requests...\r\nphp artisan make:model Flight --all<\/code><\/pre>\r\n
Created Model look like<\/p>\r\n
<?php\r\nnamespace App\\Models;\r\nuse Illuminate\\Database\\Eloquent\\Model;\r\nclass Flight extends Model\r\n{\r\n    \/\/\r\n}<\/code><\/pre>\r\n
by default flights table created. If you want custom you can use <\/p>\r\n
class Flight extends Model\r\n{\r\n    protected $table = 'my_flights'; \/\/custom table name\r\n    protected $primaryKey = 'flight_id'; \/\/custom primary key\r\n    public $incrementing = false; \/\/if need increment false\r\n    public $timestamps = false; \/\/timestamps not add \r\n   protected $guarded = []; \/\/ allow all fields to insert \/update\r\n    protected $attributes = [ \/\/default value of delayed column\r\n        'delayed' => false,\r\n    ];\r\n}<\/code><\/pre>\r\n
_____________________________<\/p>\r\n
Eloquent return data as Illuminate\\Database\\Eloquent\\Collection, <\/strong><\/p>\r\n
>>1.Get data: use below command in controller or view <\/strong><\/p>\r\n
$data = \\App\\Models\\User::all();  \/\/return all users in users table using model User\r\nforeach ($data as $key => $user) {\r\n\techo $user->name;\r\n}<\/code><\/pre>\r\n
>> GET data using where<\/strong><\/p>\r\n
$data = \\App\\Models\\User::where('email', 'rizikmw@gmail.com')\r\n               ->orderBy('id')\r\n               ->take(10)\r\n               ->get(); \/\/take means only 10 rows return<\/code><\/pre>\r\n
>> Nested if condition<\/strong><\/p>\r\n
\\App\\Models\\User::where('email', 'abc@gmail.com')\r\n   ->where(function($query) {\r\n      $query->where('typeis', 'like', 'admin%')\r\n            ->orWhere('typeis', \"like\", \"%\".\"super admin\".\"%\");\r\n   });<\/code><\/pre>\r\n
>> Count data <\/strong><\/p>\r\n
$count = \\App\\Models\\User::where('votes', '>', 100)->count();\r\nOR\r\n$count = \\App\\Models\\User::where('votes', 100)->count();<\/code><\/pre>\r\n
>> JSON Selection <\/strong><\/p>\r\n
public function user_det($name){\r\n        $names = \\App\\Models\\User::where('name', 'like', $name.'%')\r\n            ->selectRaw('name')\r\n            ->distinct()\r\n           ->take(10)\r\n           ->get()->toArray();\r\n        if($names){\r\n            return response()->json(['flag' => true, 'locations' => $names],200);\r\n        }else{\r\n            return response()->json(['flag' => false, 'locations' => \"\"],200);\r\n        };\r\n    }<\/code><\/pre>\r\n
>> Get column values<\/strong><\/p>\r\n
$user_names= \\App\\Models\\User::distinct()->pluck('name');<\/code><\/pre>\r\n
Insert Data<\/strong><\/p>\r\n
Before Insert data must add this in model: <\/strong>It helps prevent unintended or malicious modification of model attributes. protected $fillable is a property in Laravel's Eloquent models that is used to specify which attributes on the model can be mass-assigned using the create() and update() methods. <\/p>\r\n
protected $fillable = [\r\n        'name',\r\n        'email',\r\n    ];<\/code><\/pre>\r\n
$user = new \\App\\Models\\User;\r\n$user->name = \"MR DUMMY\";\r\n$user->email = \"dummy@gmail.com\";\r\n$user->password = \"dummy@gmail.com\";\r\n$user->save();<\/code><\/pre>\r\n
OR<\/p>\r\n
$flight = \\App\\Models\\User::create([\r\n    'name' => 'name to Paris',\r\n    'email'=>\"dummyp@gmail.com\",\r\n    'password'=>\"mrbbbbb\"\r\n]);<\/code><\/pre>\r\n
UPDATE<\/strong><\/p>\r\n
$user = \\App\\Models\\User::find(1); \/\/get user by ID\r\n$user->name = 'Rizwan AG';\r\n$user->save(); \/\/update\r\n\r\nOR\r\n\r\n\\App\\Models\\User::where('email', \"rizikmw@gmail.com\")\r\n      ->update(['name' => \"R GONDAL\"]);<\/code><\/pre>\r\n
updateOrCreate<\/strong><\/p>\r\n
$user = \\App\\Models\\User::updateOrCreate(\r\n\t['email' => 'rizikmw2@gmail.com'],\r\n\t ['name' => \"updated rizi\",\"password\"=>\"123\",\"email\"=>\"rizikmw2@gmail.com\"]\r\n);\r\n\r\n\/\/if email rizikmw2@gmail.com exist update the name,password, and email else, insert<\/code><\/pre>\r\n
DELETE<\/strong><\/p>\r\n
$user = \\App\\Models\\User::find(1);\r\n$user->delete();\r\n\/\/OR\r\n \\App\\Models\\User::destroy(1); \/\/ONLY primary key accepted\r\n \\App\\Models\\User::destroy([1, 2, 3]);\r\n\/\/OR CONDITION\r\n$deleted = \\App\\Models\\User::where('email', 'admin@test.com')->delete();<\/code><\/pre>\r\n
soft-deleting: <\/strong>NOT DELETE BUT deleted_at colum add: 
https:\/\/laravel.com\/docs\/9.x\/eloquent#soft-deleting<\/p>\r\n
 <\/p>\r\n
Truncate Table<\/strong><\/p>\r\n
\\App\\Models\\User::truncate();<\/code><\/pre>\r\n
pruning-models: <\/strong>periodically delete records ie delete daily users that not verify there emails<\/strong><\/p>\r\n
 <\/p>\r\n
ACCESS MODEL FUNCTION IN CONTROLLER<\/strong><\/span><\/span><\/p>\r\n
Step 1: Define a Public Function in the Model<\/strong><\/span><\/p>\r\n
namespace App\\Models;\r\nuse Illuminate\\Database\\Eloquent\\Model;\r\nclass User extends Model\r\n{\r\n    public function getUserByName($name)\r\n    {\r\n        return $this->where('name', $name)->first();\r\n    }\r\n\r\n   public static function getUserByEmail($email)\r\n    {\r\n        return self::where('name', $email)->first();\r\n    }\r\n}\r\n<\/code><\/pre>\r\n
Step 2: Access the Public Function in the Controller<\/strong><\/span><\/p>\r\n
class UserController extends Controller\r\n{\r\n    public function getUserByName($name)\r\n    {\r\n        $userModel = new \\App\\Models\\User();        \/\/ Create an instance of the User model\r\n        $user = $userModel->getUserByName(\"ABC\");\r\n        $user = \\App\\Models\\User::getUserByEmail(\"abc@gmail.com\"); \/\/ WITHOUT creating user instance we can access static function\r\n    }\r\n}<\/code><\/pre>\r\n
https:\/\/laravel.com\/docs\/9.x\/eloquent#pruning-models<\/p>","category_id":"2","is_private":"0","created_at":"2023-03-14T04:20:49.000000Z","updated_at":"2024-08-24T05:19:56.000000Z","category":{"id":2,"user_id":"1","name":"Laravel Core","slug":"laravel-nhyt","parent_id":"1","created_at":"2023-03-14T03:58:27.000000Z","updated_at":"2023-03-20T11:30:50.000000Z"},"user":{"id":1,"name":"R GONDAL","email":"rizikmw@gmail.com","email_verified_at":null,"two_factor_confirmed_at":null,"current_team_id":"1","profile_photo_path":null,"created_at":"2023-03-12T10:49:33.000000Z","updated_at":"2025-01-10T12:59:00.000000Z","profile_photo_url":"https:\/\/ui-avatars.com\/api\/?name=R+G&color=7F9CF5&background=EBF4FF"}},"pageDesc":"Laravel includes Eloquent, an object-relational mapper (ORM) that  interact with database. Each database table has a corresponding \"Mod - Eloquent ORM Model, CRUD operations, (Updated: August 24, 2024) - Read more about Eloquent ORM Model, CRUD operations, at my programming site [SITE]","categories":[]}