Dan's Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== (Laravel) Eloquent Notes ======

   * More detail: https://laravel.com/api/5.3/Illuminate/Database/Eloquent/Model.html

===== Inserting New Row =====

To create a new record in the database, simply create a new model instance, set attributes on the model, then call the save method:

<code php>
  $flight = new Flight;
  $flight->name = $request->name;
  $flight->save();
</code>

===== Update Row =====

he save method may also be used to update models that already exist in the database. To update a model, you should retrieve it, set any attributes you wish to update, and then call the save method. Again, the updated_at timestamp will automatically be updated, so there is no need to manually set its value:

<code php>
  $flight = App\Flight::find(1);
  $flight->name = 'New Flight Name';
  $flight->save();
</code>

===== Mass Updates =====

There are means to update database columns or models. See https://laravel.com/docs/5.3/eloquent

===== Delete Row =====

https://laravel.com/docs/5.3/eloquent#deleting-models
==== If you have the model ==== 

To delete a model, call the delete method on a model instance:

<code php>
  $flight = App\Flight::find(1);
  $flight->delete();
</code>

==== If you have the model's key ====

In the example above, we are retrieving the model from the database before calling the delete method. However, if you know the primary key of the model, you may delete the model without retrieving it. To do so, call the destroy method:

<code php>
  App\Flight::destroy(1);
  App\Flight::destroy([1, 2, 3]);
  App\Flight::destroy(1, 2, 3);
</code>

==== Deleting Models By Query ====

Of course, you may also run a delete statement on a set of models. In this example, we will delete all flights that are marked as inactive. Like mass updates, mass deletes will not fire any model events for the models that are deleted:

<code php>
  $deletedRows = App\Flight::where('active', 0)->delete();
</code>
Dan's Wiki

User Tools

Site Tools

Page Tools
