Guest User

Untitled

a guest
May 27th, 2018
148
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.94 KB | None | 0 0
  1. 1. Creating Records: using ::create with Model
  2.  
  3. method 1:
  4. // create a bear
  5. Bear::create(array(
  6. 'name' => 'Super Cool',
  7. 'type' => 'Black',
  8. 'danger_level' => 1
  9. ));
  10.  
  11. method 2:
  12. // alternatively you can create an object, assign values, then save
  13. $bear = new Bear;
  14.  
  15. $bear->name = 'Super Cool';
  16. $bear->type = 'Black';
  17. $bear->danger_level = 1;
  18.  
  19. // save the bear to the database
  20. $bear->save();
  21.  
  22. method 3:
  23. // find the bear or create it into the database
  24. Bear::firstOrCreate(array('name' => 'Lawly'));
  25.  
  26.  
  27. 2. Getting and Finding Records
  28.  
  29. // get all the bears
  30. $bears = Bear::all();
  31.  
  32. // find a specific bear by id
  33. $bear = Bear::find(1);
  34.  
  35. // find a bear by a specific attribute
  36. $bearLawly = Bear::where('name', '=', 'Lawly')->first();
  37.  
  38. // find a bear with danger level greater than 5
  39. $dangerousBears = Bear::where('danger_level', '>', 5)->get();
  40.  
  41. // First vs Get
  42. // When querying the database and creating where statements, you will have to use get() or first().
  43. // first will return only one record and
  44. // get will return an array of records that you will have to loop over.
  45.  
  46. 3. Updating Records
  47.  
  48. // find the bear
  49. $lawly = Bear::where('name', '=', 'Lawly')->first();
  50.  
  51. // change the attribute
  52. $lawly->danger_level = 10;
  53.  
  54. // save to our database
  55. $lawly->save();
  56.  
  57. 4. Deleting Records
  58.  
  59. // find and delete a record
  60. $bear = Bear::find(1);
  61. $bear->delete();
  62.  
  63. // delete a record
  64. Bear::destroy(1);
  65.  
  66. // delete multiple records
  67. Bear::destroy(1, 2, 3);
  68.  
  69. // find and delete all bears with a danger level over 5
  70. Bear::where('danger_level', '>', 5)->delete();
Add Comment
Please, Sign In to add comment