Skip to content

Latest commit

 

History

History
105 lines (72 loc) · 2.55 KB

ORM.md

File metadata and controls

105 lines (72 loc) · 2.55 KB

Laravel provides a powerful ORM (Object-Relational Mapping) called Eloquent, which allows you to interact with your database tables using PHP code. Here are some common Eloquent queries and how to use them:

  1. Retrieve Records:

    • Retrieve all records from a table:

      $records = YourModel::all();

    • Retrieve a single record by its primary key:

      $record = YourModel::find($id);

    • Retrieve the first record that matches a condition:

      $record = YourModel::where('column', 'value')->first();

    • Retrieve multiple records that match a condition:

      $records = YourModel::where('column', 'value')->get();

  2. Create Records:

    • Create a new record and save it to the database:

      $newRecord = new YourModel();
$newRecord->column1 = 'value1';
$newRecord->column2 = 'value2';
$newRecord->save();

    • Create a new record and save it in one line using the create method:

      $newRecord = YourModel::create([
    'column1' => 'value1',
    'column2' => 'value2',
]);

  3. Update Records:

    • Update a specific record:

      $record = YourModel::find($id);
$record->column = 'new value';
$record->save();

    • Update multiple records that match a condition:

      YourModel::where('column', 'value')->update([
    'column1' => 'new value 1',
    'column2' => 'new value 2',
]);

  4. Delete Records:

    • Delete a specific record:

      $record = YourModel::find($id);
$record->delete();

    • Delete multiple records that match a condition:

      YourModel::where('column', 'value')->delete();

  5. Count Records:

    • Count the number of records that match a condition:

      $count = YourModel::where('column', 'value')->count();

  6. Order Records:

    • Order records by a specific column in ascending order:

      $records = YourModel::orderBy('column')->get();

    • Order records by a specific column in descending order:

      $records = YourModel::orderByDesc('column')->get();

These are some of the basic Eloquent queries you can use in Laravel. Eloquent provides many other query building methods and advanced features for handling relationships, aggregations, and more. You can refer to the official Laravel documentation for a comprehensive guide on using Eloquent: https://laravel.com/docs/8.x/eloquent