
Laravel Tips
@Laravel_Tips
Almost daily Laravel tips from @crbdev
You might like
I often see DB::raw being used for subselects, but you can do them in query builder using a closure as the 2nd argument on the where clause.

Need multiple paginators? Just pass a name as the 3rd argument of paginate method. This gets used in querystring. 2nd param is for select

In blade {{$collection->total()}} displays number of records in the whole collection {{$collection->count()}} only gives paginated amount.
When defining relationships, add ->select to slim down what's selected from the relevant table, otherwise Laravel will default to SELECT *

Mysql generated columns allow you to create columns based on your data and complex sql expressions, as always laravel as you covered.

When deploying you can speed up your app by running 'php artisan optimize' as a post deploy step.

In a migration, if you want to start incrementing from a number other than 1 use DB::update('ALTER TABLE tablename AUTO_INCREMENT = 1000');

Watch out for SQL injection issues when using DB::raw, use ? or :named placeholders, One gotcha! Variables are argument on select not raw

If you want to union more than 2 queries in query builder, fluently chain multiple ->union() calls in the final part of your query.

You can create custom messages on your own formRequest objects by adding a messages() method.

Want to get 3 random rows from a table try $RandomProducts = Products::orderByRaw('RAND()')->take(3)->get();
To edit the default Blade files for password resets etc, php artisan vendor:publish will copy the relevant templates to your resources dir
When using whereMonth in an eloquent query, you probably want to also use whereYear otherwise data from all years will be returned
Reset all migrations and reseed your database with one artisan command php artisan migrate:refresh --seed
United States Trends
- 1. Wirtz 46.8K posts
- 2. Elander 3,120 posts
- 3. $TSLA 44K posts
- 4. Tony Vitello 12.1K posts
- 5. Ajax 69.9K posts
- 6. Danny White 2,676 posts
- 7. Estevao 27.6K posts
- 8. East Wing 143K posts
- 9. Caicedo 18.2K posts
- 10. Tosin 8,170 posts
- 11. #YesOnProp50 6,559 posts
- 12. Atalanta 12.3K posts
- 13. SNAP 665K posts
- 14. Juve 18.2K posts
- 15. Frankfurt 47.5K posts
- 16. Hamburger Helper N/A
- 17. Ekitike 24.2K posts
- 18. Vini 19.6K posts
- 19. Vicario 2,170 posts
- 20. Frank Anderson N/A
You might like
-
Larajobs
@laraveljobs -
Laravel News Links
@LaravelLinks -
Bobby Bouwmann
@bobbybouwmann -
The Laravel Podcast
@LaravelPodcast -
LaraconIN
@LaraconIN -
Laracon EU
@LaraconEU -
Laracon AU
@LaraconAU -
MadeWithLaravel
@MadeWithLaravel -
Larachat Slack
@larachatslack -
Stefan Bauer
@stefanbauerme -
Laracasts
@laracasts -
nunomaduro
@enunomaduro -
Caleb Porzio ⚡️
@calebporzio -
Laravel Idea
@laravel_idea -
Mahmoud Zalt
@Mahmoud_Zalt
Something went wrong.
Something went wrong.