{"id":654,"date":"2023-08-26T09:39:03","date_gmt":"2023-08-26T09:39:03","guid":{"rendered":"https:\/\/www.devopssupport.in\/blog\/?p=654"},"modified":"2023-09-01T04:33:18","modified_gmt":"2023-09-01T04:33:18","slug":"how-to-use-the-eloquent-orm-object-relational-mapping","status":"publish","type":"post","link":"https:\/\/www.devopssupport.in\/blog\/how-to-use-the-eloquent-orm-object-relational-mapping\/","title":{"rendered":"How to use the Eloquent ORM (Object-Relational Mapping)"},"content":{"rendered":"\n

In Laravel, you can use the Eloquent ORM (Object-Relational Mapping) to interact with your database using a fluent and expressive query builder. The query builder provides a set of methods that allow you to construct and execute database queries in a convenient and efficient manner. <\/p>\n\n\n\n

Here are some basic queries commonly used in Laravel, along with examples:<\/p>\n\n\n\n

Retrieving All Records:<\/strong><\/p>\n\n\n\n

To retrieve all records from a table, you can use the all<\/code> method. Here’s an example:<\/p>\n\n\n\n

$users = App\\Models\\User::all();\r<\/code><\/pre>\n\n\n\n
This query retrieves all records from the users<\/code> table and assigns them to the $users<\/code> variable.<\/p>\n\n\n\n
Retrieving Specific Columns:<\/strong><\/p>\n\n\n\n
If you only need specific columns from a table, you can use the select<\/code> method. <\/p>\n\n\n\n
Here’s an example:<\/p>\n\n\n\n
$users = App\\Models\\User::select('name', 'email')->get();\r\n<\/code><\/pre>\n\n\n\n
This query retrieves the name<\/code> and email<\/code> columns from the users<\/code> table.<\/p>\n\n\n\n
Retrieving a Single Record:<\/strong><\/p>\n\n\n\n
To retrieve a single record based on a condition, you can use the where<\/code> method. Here’s an example:<\/p>\n\n\n\n
$user = App\\Models\\User::where('id', 1)->first();\r\n<\/code><\/pre>\n\n\n\n
This query retrieves the user with an id<\/code> of 1 from the users<\/code> table.<\/p>\n\n\n\n
Retrieving Records with Conditions:<\/strong><\/p>\n\n\n\n
You can add more conditions to your query using the where<\/code> method. <\/p>\n\n\n\n
Here’s an example:<\/p>\n\n\n\n
$users = App\\Models\\User::where('age', '>', 18)\r\n                ->where('gender', 'female')\r\n                ->get();\r\n<\/code><\/pre>\n\n\n\n
This query retrieves all female users over the age of 18 from the users<\/code> table.<\/p>\n\n\n\n
Ordering Records:<\/strong><\/p>\n\n\n\n
To order records based on a specific column, you can use the orderBy<\/code> method. <\/p>\n\n\n\n
Here’s an example:<\/p>\n\n\n\n
$users = App\\Models\\User::orderBy('name', 'asc')->get();\r\n<\/code><\/pre>\n\n\n\n
This query retrieves all users from the users<\/code> table and orders them in ascending order based on the name<\/code> column.<\/p>\n\n\n\n
Counting Records:<\/strong><\/p>\n\n\n\n
To count the number of records that match certain conditions, you can use the count<\/code> method. Here’s an example:<\/p>\n\n\n\n
$count = App\\Models\\User::where('status', 'active')->count();\r\n<\/code><\/pre>\n\n\n\n
This query counts the number of active users in the users<\/code> table.<\/p>\n","protected":false},"excerpt":{"rendered":"
In Laravel, you can use the Eloquent ORM (Object-Relational Mapping) to interact with your database using a fluent and expressive query builder. The query builder provides a… <\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-654","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/posts\/654","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/comments?post=654"}],"version-history":[{"count":1,"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/posts\/654\/revisions"}],"predecessor-version":[{"id":655,"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/posts\/654\/revisions\/655"}],"wp:attachment":[{"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/media?parent=654"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/categories?post=654"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/tags?post=654"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}