LARAVEL TIPS & TUTORIALS FREE E-book: 100 Laravel Quick Tips (and counting) April 20, 2020. 16. Laravel is full of hidden gems, undocumented or less-known features, functions parameters and "hacks". While finding them in work of my team, I decided to compile them into an e-book. ADVANCED LARAVEL: 14 TOPICS AND LINKS TO LEARN THEM Topic 3. Advanced Eloquent and DB Operations. Eloquent is a great Laravel mechanism to deal with the database, but there’s so many less-known functions under the hood, like: Observers, Accessors/Mutators, Seeding, “magic methods” like firstOrCreate (), Collections etc. Sub-topics and links: Eloquent: Expert Level – my course on the topic; ELOQUENT WITHCOUNT(): GET RELATED RECORDS AMOUNT Eloquent has one less-known function called withCount(): it helps to get the amount of related records inside of the main object.It also works with two layers deep, inside of hasManyThrough relations. Let’s take a look. In our example mini-project, we will have three models: User, Post and Comment.All relationships can be described, looking at app/User.php model: NEW PACKAGE LARAVEL-SEARCHABLE: EASILY SEARCH IN MULTIPLE Spatie team is still on fire with new packages. This week they released another one called Laravel Searchable, created mainly by AlexVanderbist. I've tried it LARAVEL BLADE @INCLUDE: THREE ADDITIONAL "HELPERS 3. @includeFirst: Fallback “Default” View. This is relevant for projects with multiple “themes” of Blade views. Let’s say, you want to load a header for a particular theme, but it may not exist, so you fallback to the “default” header. In this case, Laravel will

try to

LARAVEL AUTH: LOGIN WITH EMAIL OR USERNAME (IN ONE FIELD Quick tip for you guys. What if in your project users can login not only with email but also with some other field, like "username" or "user_id" or whatever? By default Laravel allows only one field like 'email'. That's actually easy to change. LARAVEL GROUP QUERY RESULT BY DAY/MONTH/YEAR Quick tip for those who want to list some events, grouping them by some date value – by day, month, year etc. Let’s take a look at example – we have this database structure of appointments. LARAVEL SIMPLEPAGINATE: MORE EFFECTIVE WITH BIGGER DATA Laravel pagination is quite a simple thing to use, but to determine the amount of pages it makes additional query to the database, which may be a problem for bigger amount of data. And you can actually avoid it. Let’s take a simple pagination example from a table with 5000 customers: Here’s how the queries look in Laravel Debugbar. HOW TO CREATE ZIP ARCHIVE WITH FILES AND DOWNLOAD IT IN If you need your users to be able to download multiple files at once, it's better to create one archive and let them download it. Here's how to do it in Laravel.

INVOICE NINJA

Invoice Ninja – Laravel-powered solution for better invoicing. November 7, 2016. We continue the series of reviews for Laravel-based projects and apps. Today we have Invoice Ninja – a really powerful tool for, you guessed it, invoicing. It really impressed me, let me tell you how. Other reviews in this series: FlarePoint: Laravel-based

free

LARAVEL TIPS & TUTORIALS FREE E-book: 100 Laravel Quick Tips (and counting) April 20, 2020. 16. Laravel is full of hidden gems, undocumented or less-known features, functions parameters and "hacks". While finding them in work of my team, I decided to compile them into an e-book. ADVANCED LARAVEL: 14 TOPICS AND LINKS TO LEARN THEM Topic 3. Advanced Eloquent and DB Operations. Eloquent is a great Laravel mechanism to deal with the database, but there’s so many less-known functions under the hood, like: Observers, Accessors/Mutators, Seeding, “magic methods” like firstOrCreate (), Collections etc. Sub-topics and links: Eloquent: Expert Level – my course on the topic; ELOQUENT WITHCOUNT(): GET RELATED RECORDS AMOUNT Eloquent has one less-known function called withCount(): it helps to get the amount of related records inside of the main object.It also works with two layers deep, inside of hasManyThrough relations. Let’s take a look. In our example mini-project, we will have three models: User, Post and Comment.All relationships can be described, looking at app/User.php model: NEW PACKAGE LARAVEL-SEARCHABLE: EASILY SEARCH IN MULTIPLE Spatie team is still on fire with new packages. This week they released another one called Laravel Searchable, created mainly by AlexVanderbist. I've tried it LARAVEL BLADE @INCLUDE: THREE ADDITIONAL "HELPERS 3. @includeFirst: Fallback “Default” View. This is relevant for projects with multiple “themes” of Blade views. Let’s say, you want to load a header for a particular theme, but it may not exist, so you fallback to the “default” header. In this case, Laravel will

try to

LARAVEL AUTH: LOGIN WITH EMAIL OR USERNAME (IN ONE FIELD Quick tip for you guys. What if in your project users can login not only with email but also with some other field, like "username" or "user_id" or whatever? By default Laravel allows only one field like 'email'. That's actually easy to change. LARAVEL GROUP QUERY RESULT BY DAY/MONTH/YEAR Quick tip for those who want to list some events, grouping them by some date value – by day, month, year etc. Let’s take a look at example – we have this database structure of appointments. LARAVEL SIMPLEPAGINATE: MORE EFFECTIVE WITH BIGGER DATA Laravel pagination is quite a simple thing to use, but to determine the amount of pages it makes additional query to the database, which may be a problem for bigger amount of data. And you can actually avoid it. Let’s take a simple pagination example from a table with 5000 customers: Here’s how the queries look in Laravel Debugbar. HOW TO CREATE ZIP ARCHIVE WITH FILES AND DOWNLOAD IT IN If you need your users to be able to download multiple files at once, it's better to create one archive and let them download it. Here's how to do it in Laravel.

INVOICE NINJA

Invoice Ninja – Laravel-powered solution for better invoicing. November 7, 2016. We continue the series of reviews for Laravel-based projects and apps. Today we have Invoice Ninja – a really powerful tool for, you guessed it, invoicing. It really impressed me, let me tell you how. Other reviews in this series: FlarePoint: Laravel-based

free

EMBED AND PARSE YOUTUBE/VIMEO VIDEOS WITH LARAVEL EMBED I’ve recently found a simple package that helps to transform any URL into embeddable HTML, the best examples are Youtube and Vimeo videos. Let’s imagine you have a video input text field (not uploadable video but URL), which you than need to transform into HTML code, depending on the platform.. So, some users may specify Youtube video:. Others may add a link from Vimeo platform: LARAVEL GROUP QUERY RESULT BY DAY/MONTH/YEAR Quick tip for those who want to list some events, grouping them by some date value – by day, month, year etc. Let’s take a look at example – we have this database structure of appointments. ROUTE FALLBACK: IF NO OTHER ROUTE IS MATCHED Laravel 5.5.5 introduced a new feature in routing, called Route::fallback(). Basically, if no route is matched, then fallback function is a way to override default 404 page and introduce additional logic. Here’s how it works. In your routes/web.php file, at the very end, after all the routes, you can specify something like

this: And if

SELECT WITH DB::RAW() When selecting data form the database, sometimes you need to make some extra filtering with results - with some if-else statements and similar. With Laravel - you can achieve that with Accessor fields or just looping through results in PHP. But there is a more effective way - to move the filters to the database query itself. ELOQUENT::WHEN(): NO MORE IF-ELSES FOR CONDITIONAL QUERIES Wait, there’s more. In the example below we will filter users only if the role was passed as a request option. This means – as long as there is no parameter or it’s false/null – you will see all of the users but if it becomes a value, lets say “1” for administrator – you will only see administrators. LARAVEL VALIDATION RULES: PRESENT AND FILLED Laravel Validation Rules: PRESENT and FILLED. December 18, 2018. There is a well-known Laravel validation rule required. But did you know there a few similar rules called present and filled? In this short video, I’m showing the differences and use-cases. YouTube. Laravel

Daily.

INVOICE NINJA

Invoice Ninja – Laravel-powered solution for better invoicing. November 7, 2016. We continue the series of reviews for Laravel-based projects and apps. Today we have Invoice Ninja – a really powerful tool for, you guessed it, invoicing. It really impressed me, let me tell you how. Other reviews in this series: FlarePoint: Laravel-based

free

DATATABLES STATESAVE OPTION: "REMEMBER" SEARCH AND FILTERS Not Laravel related, but today encountered the situation, so sharing with you. You probably know Datatables, right? It allows to quickly search and filter the table of data. But what if user then navigates away (for Edit, for example) and then wants to go back and have the same search parameters he had before? Easy. CRUD: HOW TO AVOID BUILDING WHOLE FORM FOR DELETE BUTTON To “fake” form submission with JavaScript. So “Delete” button would actually be a link, and then you catch its click by its class or some data-xxx property. Then you read the URL of the link, form the JS parameters and send the request to real Delete URL (by the way, did you know that there’s actually no DELETE method, it’s a POST ). FILTERING QUERY RESULTS WITH DIFFERENT CONDITIONS ON THE Hi, I am new to learning Laravel. I presume the filter function is based on code (php) processing not database query. If the table contains a lot of records, say thousands if not millions, the penalty could be very high since DB query is surely much faster then looping

all records.

LARAVEL TIPS & TUTORIALS FREE E-book: 100 Laravel Quick Tips (and counting) April 20, 2020. 16. Laravel is full of hidden gems, undocumented or less-known features, functions parameters and "hacks". While finding them in work of my team, I decided to compile them into an e-book. ELOQUENT WITHCOUNT(): GET RELATED RECORDS AMOUNT Eloquent has one less-known function called withCount(): it helps to get the amount of related records inside of the main object.It also works with two layers deep, inside of hasManyThrough relations. Let’s take a look. In our example mini-project, we will have three models: User, Post and Comment.All relationships can be described, looking at app/User.php model: LARAVEL AUTH: LOGIN WITH EMAIL OR USERNAME (IN ONE FIELD Quick tip for you guys. What if in your project users can login not only with email but also with some other field, like "username" or "user_id" or whatever? By default Laravel allows only one field like 'email'. That's actually easy to change. 100 (AND COUNTING) LARAVEL QUICK TIPS 100 (and counting) Laravel Quick Tips P r e p a r e d b y : P o vi l a s K o ro p / L a ra ve l D a i l y T e a m w w w . l a ra ve l d a i l

y. co m

AND-OR-AND + BRACKETS WITH ELOQUENT Eloquent is a great thing - you can build your query step-by-step and then call get() method. But sometimes it gets a little tricky for more complicated queries - for example, if you have multiple AND-OR conditions and you want to put brackets, how to do it properly? LARAVEL API ERRORS AND EXCEPTIONS: HOW TO RETURN RESPONSES Tip 1. Switch APP_DEBUG=false Even Locally. There’s one important setting in .env file of Laravel – it’s APP_DEBUG which can be false or true. If you turn it on as true, then all your errors will be shown with all the details, including names of the classes, DB tables

etc.

LARAVEL EXCEPTIONS: HOW TO CATCH, HANDLE AND CREATE YOUR Quite often web-developers don’t care enough about errors. If something goes wrong, you often see default Laravel texts like “Whoops, something went wrong” or, even worse, the exception code, which is not helpful at all to the visitor. QUICK TIP FOR MIGRATIONS: CHECK IF TABLE/COLUMN ALREADY Solution to this is Schema::hasTable () method. So, if table flights does not exist, then we create it. Of course, it can be used in a positive way – for example, if we want to add a new column to existing table, then we may check if table does exist. Let’s combine this with another example and with another method Schema::hasColumn LIMIT FAILED LOGIN ATTEMPTS ON LARAVEL AUTH Did you know that Laravel Auth system allows you to block the user after X bad attempts to log in? Even more, you can change that limit! This trick works with out of the box Laravel Auth system and all you have to do is modify one file. HOW TO CHANGE DATE FORMAT IN LARAVEL AND JQUERY UI One of the most often things to change in web-projects is adapting it to a certain geographical area - language and timezones are two examples. But also there's a date format, which can be pretty different in certain parts of the world. How to handle it properly in

Laravel?

LARAVEL TIPS & TUTORIALS FREE E-book: 100 Laravel Quick Tips (and counting) April 20, 2020. 16. Laravel is full of hidden gems, undocumented or less-known features, functions parameters and "hacks". While finding them in work of my team, I decided to compile them into an e-book. ELOQUENT WITHCOUNT(): GET RELATED RECORDS AMOUNT Eloquent has one less-known function called withCount(): it helps to get the amount of related records inside of the main object.It also works with two layers deep, inside of hasManyThrough relations. Let’s take a look. In our example mini-project, we will have three models: User, Post and Comment.All relationships can be described, looking at app/User.php model: LARAVEL AUTH: LOGIN WITH EMAIL OR USERNAME (IN ONE FIELD Quick tip for you guys. What if in your project users can login not only with email but also with some other field, like "username" or "user_id" or whatever? By default Laravel allows only one field like 'email'. That's actually easy to change. 100 (AND COUNTING) LARAVEL QUICK TIPS 100 (and counting) Laravel Quick Tips P r e p a r e d b y : P o vi l a s K o ro p / L a ra ve l D a i l y T e a m w w w . l a ra ve l d a i l

y. co m

AND-OR-AND + BRACKETS WITH ELOQUENT Eloquent is a great thing - you can build your query step-by-step and then call get() method. But sometimes it gets a little tricky for more complicated queries - for example, if you have multiple AND-OR conditions and you want to put brackets, how to do it properly? LARAVEL API ERRORS AND EXCEPTIONS: HOW TO RETURN RESPONSES Tip 1. Switch APP_DEBUG=false Even Locally. There’s one important setting in .env file of Laravel – it’s APP_DEBUG which can be false or true. If you turn it on as true, then all your errors will be shown with all the details, including names of the classes, DB tables

etc.

LARAVEL EXCEPTIONS: HOW TO CATCH, HANDLE AND CREATE YOUR Quite often web-developers don’t care enough about errors. If something goes wrong, you often see default Laravel texts like “Whoops, something went wrong” or, even worse, the exception code, which is not helpful at all to the visitor. QUICK TIP FOR MIGRATIONS: CHECK IF TABLE/COLUMN ALREADY Solution to this is Schema::hasTable () method. So, if table flights does not exist, then we create it. Of course, it can be used in a positive way – for example, if we want to add a new column to existing table, then we may check if table does exist. Let’s combine this with another example and with another method Schema::hasColumn LIMIT FAILED LOGIN ATTEMPTS ON LARAVEL AUTH Did you know that Laravel Auth system allows you to block the user after X bad attempts to log in? Even more, you can change that limit! This trick works with out of the box Laravel Auth system and all you have to do is modify one file. HOW TO CHANGE DATE FORMAT IN LARAVEL AND JQUERY UI One of the most often things to change in web-projects is adapting it to a certain geographical area - language and timezones are two examples. But also there's a date format, which can be pretty different in certain parts of the world. How to handle it properly in

Laravel?

QUICK TIP FOR MIGRATIONS: CHECK IF TABLE/COLUMN ALREADY Solution to this is Schema::hasTable () method. So, if table flights does not exist, then we create it. Of course, it can be used in a positive way – for example, if we want to add a new column to existing table, then we may check if table does exist. Let’s combine this with another example and with another method Schema::hasColumn AND-OR-AND + BRACKETS WITH ELOQUENT Eloquent is a great thing - you can build your query step-by-step and then call get() method. But sometimes it gets a little tricky for more complicated queries - for example, if you have multiple AND-OR conditions and you want to put brackets, how to do it properly? CREATE CONTROLLER AND MODEL IN ONE ARTISAN COMMAND Laravel is full of little tricks, and quick ways to generate code with Artisan. One of the recent ones I've found is when you're creating a CRUD record and need to create Model + Controller. You don't need two separate commands for that. 8 TRICKS WITH LARAVEL TIMESTAMPS 6. Update without touching updated_at. Whenever you update Eloquent record, it automatically saves current timestamp into updated_at column, and that’s a great feature.. But sometimes you want to avoid it, like you increment some value LARAVEL EXCEL EXPORT: FORMATTING AND STYLING CELLS Laravel-Excel package is great for exporting data. But not a lot of info there about formatting Excel cells - widths, word wraps, fonts etc. So when I encountered this in a client's project, I decided to write this article with a few tips on this topic. SELECT WITH DB::RAW() When selecting data form the database, sometimes you need to make some extra filtering with results - with some if-else statements and similar. With Laravel - you can achieve that with Accessor fields or just looping through results in PHP. But there is a more effective way - to move the filters to the database query itself. LARAVEL: FIND ADDRESSES WITH COORDINATES VIA GOOGLE MAPS Quite often we need to save addresses in the database, and we want them to be accurate. Probably, the best way to ensure it is to provide customers with input field where they choose the address from auto-completed values as they type. This article will show you how to achieve it in Laravel, let's build a "location picker" with Google

Maps API.

LARAVEL: UPLOAD FILE AND HIDE REAL URL FOR SECURE DOWNLOAD File uploads are one of the essential things in web apps these days. But secure download of these files is sometimes even more important. So how to store files securely so people wouldn't have access to them or guess their URLs or IDs of their records? Here's a small demo

tutorial.

LARAVEL AUTH: AFTER-REGISTRATION REDIRECT TO PREVIOUS Laravel Auth features a function to redirect logged-in user to the same page they were visiting before. So, for example, if you visit /posts, you get automatically redirected to /login and then enter your data successfully, Laravel will “remember” and redirect you back to /posts instead of default /home.But it doesn’t work with new user registration, let’s see how we can change it. VALIDATE MAX FILE SIZE IN LARAVEL, PHP AND WEB-SERVER Nginx and Apache Settings. By default Laravel Forge creates servers with LEMP stack, which uses Nginx as a web-server. Even without knowing how to configure it, you need to care about one setting in nginx.conf file: client_max_body_size.. Here’s a screenshot from official documentation:

__

__ __

__

__

Sign in

* Laravel Tutorials

* Laravel Courses

* About Author

__

Sign in

__

Welcome!Log into your account

your username

your password

Forgot your password?

__

Password recovery

Recover your password

your email

__

Search

__

Sign in

Welcome! Log into your account

your username

your password

Forgot your password? Get help

Password recovery

Recover your password

your email

A password will be e-mailed to you.

LARAVEL DAILY

__

* Laravel Tutorials

* Laravel Courses

* About Author

__ __

FREE E-BOOK: 100 LARAVEL QUICK TIPS (AND COUNTING)

April 20, 2020

8 TRICKS WITH LARAVEL TIMESTAMPS LARAVEL TWO-STEP REGISTRATION: OPTIONAL FIELDS FOR COUNTRY AND BIO HOW TO STRUCTURE ROUTES IN LARGE LARAVEL PROJECTS?

NEWEST ARTICLES

FREE E-BOOK: 100 LARAVEL QUICK TIPS (AND COUNTING)

April 20, 2020

16

Laravel is full of hidden gems, undocumented or less-known features, functions parameters and "hacks". While finding them in work of my team, I decided to compile them into an e-book. 8 TRICKS WITH LARAVEL TIMESTAMPS

December 31, 2019

14

By default, Laravel Eloquent models assume your table has timestamp fields - created_at and updated_at. But there's plenty of things you

can...

TAYLOR OTWELL: LARAVEL 7 WILL MOVE AUTH CONTROLLERS INTO UI PACKAGE

December 27, 2019

0

I've been listening to Laravel Snippet podcast by Taylor Otwell, and heard some news about upcoming Laravel 7, which I think is pretty important for blog readers to know. So, changes are coming to Auth

scaffolding.

UPLOAD AND PARSE CSV WITH LARAVEL MEDIALIBRARY AND SPREADSHEETREADER

August 25, 2019

3

Quick example of a code I had to write recently. Task is simple - upload CSV and parse it. Also save that file and the record, which user uploaded it. Let's take a look. ELOQUENT: RECURSIVE HASMANY RELATIONSHIP WITH UNLIMITED SUBCATEGORIES

August 18, 2019

49

Quite often in e-shops you can see many level of categories and subcategories, sometimes even unlimited. This article will show you

how...

THE BIGGEST PROBLEM WITH ELOQUENT ACCESSORS “MAGIC”

August 17, 2019

23

I confess - during five years of working with Laravel, I've been fascinated by its "magic" and how little code is needed to actually make things work. But recently, as my projects grew in size, that "magic" started to become a problem. One of the typical example is Eloquent Accessors, so in this article I will put an argument against using them, and what to do instead. GET ARRAY OF IDS FROM ELOQUENT COLLECTION: PLUCK() OR MODELKEYS()

August 8, 2019

0

There are situations where you need to get array of IDs for some records in collection/table. I will show you two quick ways to do it - one is pretty popular, and another is a function which I found out

only today.

LARAVEL: GET NEWEST/OLDEST RECORDS FROM PIVOT TABLE IN BELONGSTOMANY

August 6, 2019

0

Default belongsToMany relationship in Laravel works really well - you can easily attach, detach or sync records. But what if you want to order pivot records by newest or oldest? This article will show you

how.

LARAVEL TWO-STEP REGISTRATION: OPTIONAL FIELDS FOR COUNTRY AND BIO

July 24, 2019

2

Nowadays, we have a lot of Laravel tutorial about some syntax or package, but I think there's not enough written with real-life mini-projects, close to real demands of the clients. So will try to write more of these, and this is one of them: imagine a project where you need to have two-step registration process, with some optional fields in the second step. Let's build it in Laravel. LARAVEL: LOGIN AND REGISTER FORMS ON THE SAME PAGE

July 1, 2019

8

Quite often, especially in e-shop projects, you can see a page to login or register before finishing the purchase. But Laravel has these two routes as separate login and register pages. So how to merge them together and avoid conflicts?

____

STAY CONNECTED

2,225FansLike

14,676FollowersFollow 11,800SubscribersSubscribe

NEWEST VIDEOS

TOP 5 ALL-TIME MUST-WATCH VIDEOS FROM LARACON HOW MUCH I EARN FROM THIS LARAVELDAILY BLOG LARAVEL WINK PACKAGE: WORDPRESS MINI-ALTERNATIVE FOR LARAVEL? ELOQUENTFILTER PACKAGE REVIEW: PROCESS GET QUERY WITHOUT IF STATEMENTS

RANDOM ARTICLES

HOW TO CHANGE DATE FORMAT IN LARAVEL AND JQUERY UI DATEPICKER

July 25, 2018

WHY USE $APPENDS WITH ACCESSORS IN ELOQUENT?

July 9, 2015

THE BIGGEST PROBLEM WITH ELOQUENT ACCESSORS “MAGIC”

August 17, 2019

AND-OR-AND + BRACKETS WITH ELOQUENT

June 24, 2015

LARAVEL ROUTE FILTERING WITH REGULAR EXPRESSIONS

February 14, 2019

NEW: LARAVEL DAILY VIDEO – SHORT EPISODE EVERY DAY

March 12, 2017

8 THINGS YOU CAN CUSTOMIZE IN LARAVEL REGISTRATION

January 2, 2019

HOW TO CONVERT WORDPRESS THEME TO LARAVEL BLADE

September 11, 2017

Like our articles?

Check out our Laravel online courses! __ Facebook __ Twitter

__ Youtube

Edit with Live CSS

Save

Write CSS OR LESS and hit save. CTRL + SPACE for auto-complete.