Best Laravel Eloquent Tips and Tricks

1. www.techtic.com | info@techtic.com

2. Laravel Tips List of Laravel Tips 1. Increments and Decrements 13. Raw query methods 2. XorY methods 14. Replicate: make a copy of a row 3. Model boot() method 15. Chunk() method for big tables 4. Relationship with conditions and ordering 16. Create additional things when creating a 5. Model properties: timestamps, appends etc. model 6. Find multiple entries 17. Override updated_at when saving 7. WhereX 18. What is the result of an update()? 8. Order by relationship 19. Transform brackets into an Eloquent query 9. Eloquent::when() – no more if-else’s 20. orWhere with multiple parameters 10. BelongsTo Default Models 21. onDelete('set null') 11. Order by Mutator 22. dropForeign([]); 12. Default ordering in global scope 23. Model Validation www.techtic.com | info@techtic.com

3. Laravel Tips 1. Increments and Decrements Instead of this: Do this: Also these will work: www.techtic.com | info@techtic.com

4. Laravel Tips 2. XorY Methods Eloquent has quite a few functions that combine two methods, like “please do X, otherwise do Y”. Ex 1 – findOrFail(): Instead of: Do this: www.techtic.com | info@techtic.com

5. Laravel Tips 2. XorY Methods Ex 2 – firstOrCreate(): Instead of: Do this: www.techtic.com | info@techtic.com

6. Laravel Tips 3. Model boot() method There is a magical place called boot() in an Eloquent model where you can override default behavior: Probably one of the most popular examples is setting some field value at the moment of creating the model object. www.techtic.com | info@techtic.com

7. Laravel Tips 4. Relationship with conditions and ordering Define Relationship: Already add where or orderBy? For example, if you want a specific relationship for some type of users, also ordered by email, you can do this: www.techtic.com | info@techtic.com

8. Laravel Tips 5. Model properties: timestamps, appends etc. There are a few “parameters” of an Eloquent model, in the form of properties of that class. The most popular ones are probably these: there’s more: www.techtic.com | info@techtic.com

9. Laravel Tips 6. Find multiple entries find() Method Few people know about that it can accept multiple IDs as an array: www.techtic.com | info@techtic.com

10. Laravel Tips 7. WhereX There’s an elegant way to turn this: Do this: Also, there are some pre-defined methods in Eloquent, related to date/time: www.techtic.com | info@techtic.com

11. Laravel Tips 8. Order by Relationship Separate relationship for the latest post on the topic: And then, in our controller, we can do this “magic”: www.techtic.com | info@techtic.com

12. Laravel Tips 9 Eloquent::when() – no more if-else’s write conditional queries with “if-else”, something like this: there’s a better way – to use when(): www.techtic.com | info@techtic.com

13. Laravel Tips 9 Eloquent::when() – no more if-else’s It may not feel shorter or more elegant, but the most powerful is passing of the parameters: www.techtic.com | info@techtic.com

14. Laravel Tips 10 BelongsTo Default Models Post belonging to Author and then Blade code: But what if the author is deleted, or isn’t set for some reason? You will get an error, something like “property of non-object”. Of course, you can prevent it like this: But you can do it on Eloquent relationship level: www.techtic.com | info@techtic.com

15. Laravel Tips 11 Order by Mutator Guess you have this: Now, you want to order by that full_name? This won’t work: Solution is simple. We need to order the results after we get them. Function name is different – it’s not orderBy, it’s sortBy. www.techtic.com | info@techtic.com

16. Laravel Tips 12 Default ordering in global scope What if you want to have User::all() always be ordered by name field? You can assign a global scope. Let’s go back to the boot() method, which we mentioned already above. www.techtic.com | info@techtic.com

17. 13 Raw query methods Add raw queries to our Eloquent statements. functions for that. www.techtic.com | info@techtic.com

18. Laravel Tips 14 Replicate: make a copy of a row Short one. Without deep explanations, here’s the best way to make a copy of database entry: www.techtic.com | info@techtic.com

19. Laravel Tips 15 Chunk() method for big tables Still powerful – to process bigger datasets, you can chunk them into pieces. Instead of: Do this: www.techtic.com | info@techtic.com

20. Laravel Tips 16 Create additional things when creating a model This Artisan command: There are three useful flags to generate related files to the model?  m will create a migration file  c will create a controller  r will indicate that controller should be resourceful www.techtic.com | info@techtic.com

21. Laravel Tips 17 Override updated_at when saving ->save() method can accept parameters? As a result, we can tell it to “ignore” updated_at default functionality to be filled with current timestamp. See this: Overriding default updated_at with our pre-defined one. www.techtic.com | info@techtic.com

22. Laravel Tips 18 What is the result of an update()? This code actually returns? what would that $result contain? The answer is affected rows. So if you need to check how many rows were affected, you don’t need to call anything else – update() method will return this number for you. www.techtic.com | info@techtic.com

23. Laravel Tips 19 Transform brackets into an Eloquent query and-or mix SQL query, like this: How to translate it into Eloquent? This is the wrong way: The order will be incorrect. The right way is a little more complicated, using closure functions as sub-queries: www.techtic.com | info@techtic.com

24. Laravel Tips 20 orWhere with multiple parameters pass an array of parameters to orWhere(). “Usual” way: Do this: www.techtic.com | info@techtic.com

25. Laravel Tips 21 onDelete('set null') Used onDelete('cascade'); on foreign keys in Laravel migrations, know about 'set null'? This allows you to preserve models when their related model is deleted. www.techtic.com | info@techtic.com

26. Laravel Tips 22 dropForeign([]); when rolling back multiple foreign keys using array syntax didn't work. the array syntax on dropForeign is for dropping a foreign key using a shorthand column name. www.techtic.com | info@techtic.com

27. Laravel Tips 22 dropForeign([]); Here is drop foreign: www.techtic.com | info@techtic.com

28. Laravel Tips 22 dropForeign([]); abstracted call to dropIndexCommand which looks like this: www.techtic.com | info@techtic.com

29. Laravel Tips 23 Model Validation This approach was inspired by the Elixir framework, Phoenix. www.techtic.com | info@techtic.com

30. Laravel Tips 23 Model Validation www.techtic.com | info@techtic.com

31. Laravel Tips 23 Model Validation if your front-end only ends values that have changes for updating, you don't want all fields marked as required. www.techtic.com | info@techtic.com

32. Techtic Solutions, Inc. is one of the most trusted Laravel development company with 10+ years of web development experience. Our team of experienced Laravel developers are adept at building simple to the most complex website apps seamlessly using Laravel PHP frameworks. Our clients swear by the codes we write – they are simple, expressive and scalable. We help build sophisticated websites that help maximize ROI for your business. Get in touch if you are looking to hire Certified Laravel developers to deliver, secure, high performance and faster web applications. Our Services: Laravel Customization Laravel Theme/Template Design Laravel Plugin Development Laravel REST API Development Laravel Support & Maintenance Custom Laravel Web Development Laravel CMS development Laravel Application Development Laravel Ecommerce Development Laravel Enterprise Solution www.techtic.com | info@techtic.com

33. About Techtic Solutions About Techtic Solutions Techtic Solutions is a 9+ years young IT firm offering solutions to various verticals for branding, online marketing, web and mobile applications design & development. With the vast experience of designing & developing 3000+ web projects, 150+ mobile app development projects & 200+ digital marketing projects. Our efficient team of 50+ engineers, marketers, designers & business analysts have track record of offering the most intuitive, efficient & winning solutions to the small, medium and large businesses & corporatesto successfully address their business models accuracy & enhancements. Enabling businesses with technological advancements to improve the business model, increase sales channels is the vision of Techtic Solutions. Our professionals work in some of the most innovative areas like Ionic, Swift, iOS, Android, Magento 2.X, Laravel, Yii, AngularJS, CodeIgniter, WordPress and many other open source technologies. Our efficient team management, quality control and willingness to deliver the most innovative solutions to our customers are what set us apart from other I.T. vendors. Continued on Next Page www.techtic.com | info@techtic.com

34. About Techtic Solutions About Techtic Solutions Techtic is an innovative technology agency with a cavalry of multi-talented and pulsating professionals in quest of challenges to deliver quality digital products. We use leading project development methodology, super efficient process and most advanced tool chain. Industries we serve Industries we serve Services Services Mobile App Development React Native Development Full Stack Development Laravel Development Node.JS Development Angular Development React JS Development WorkPressDevelopment Magento Development IOT Development Digital Marketing Travel Social Networking Life Style Health & Fitness Productivity Business Navigation Entertainment Advertising Real Estate www.techtic.com | info@techtic.com

35. Contact Us Contact Us Visit us: https://www.techtic.com Email: info@techtic.com Phone: +1 201.793.8324 Source by: https://laravel-news.com/eloquent-tips-tricks