你可能會喜歡
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
![phparch's profile picture. Since 2002, php[architect] publishes a monthly magazine & books, organizes conferences, and provides training dedicated exclusively to the world of PHP.](https://pbs.twimg.com/profile_images/1918389188770385920/BMMCkQnr.jpg)
United States 趨勢
- 1. Austin Reaves 39.6K posts
- 2. Steelers 83.5K posts
- 3. Packers 65K posts
- 4. Tomlin 12.1K posts
- 5. Tucker Kraft 15.1K posts
- 6. Jordan Love 15.9K posts
- 7. #GoPackGo 10.5K posts
- 8. Derry 18.6K posts
- 9. #LakeShow 3,577 posts
- 10. #BaddiesAfricaReunion 8,266 posts
- 11. Aaron Rodgers 19.6K posts
- 12. Pretty P 3,647 posts
- 13. #LaGranjaVIP 66.2K posts
- 14. Teryl Austin 2,133 posts
- 15. Zayne 18.1K posts
- 16. Dolly 12K posts
- 17. #HereWeGo 7,489 posts
- 18. Sabonis 2,360 posts
- 19. Green Bay 10.9K posts
- 20. Karola 4,074 posts
你可能會喜歡
-
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.