In Laravel sometimes while creating a eloquent or db builder query you wanted to apply the where on basis of some conditions and to achieve it you may use if else condition but laravel 8 itself provides solution to handle such type of situations using when method. Laravel eloquent when…
Category: Laravel
Php
How to use left join in Laravel eloquent query with example
In this article we will learn to use left join in laravel eloquent and query builder. Laravel itself provide inbuilt method to left join the table like in MySQL or SQL based database we can do join multiple tables using leftJoin function. For example if you have 10 rows and…
Php
How to compare date in where query laravel eloquent
Laravel use carbon library to format and show the date and to compare date in where query laravel or db builder it uses carbon internally so compare date in where query in laravel is almost same as executing where using other data type but if we wanted to go more…
Php
How to use limit query in Laravel eloquent query with example
Limit clause is used to restrict the number of rows return in executed query. It’s quite useful when working with large data set since querying the large data creates performance issues so to overcome with the large dataset issue we use limit clause in a query. Laravel Limit clause accepts…
Php
How to use join in Laravel eloquent query with example
In this article we will learn to use join in laravel eloquent and query builder. Laravel itself provide inbuilt method to join the table like in MySQL or SQL based database we can do join multiple tables using join function. laravel eloquent Join method by default use inner join. For…
Php
How to use avg in Laravel eloquent query with example
In this article we will learn to use aggregate function avg in laravel eloquent and query builder. Laravel itself provide inbuilt method to avg the columns like in MySQL or SQL based database we can do avg of columns using avg aggregate function. Avg method will give you the average…
Php
How to check password with hashed string in laravel 8 ?
Laravel hashed password with bcrypt algorithm is not decryptable and to match the hashed string with plain string we use Hash::check method. For hashing the password laravel use secure Bcrypt and Argon2 hashing for storing user passwords. So in this tutorial i will show you to check password with hashed…
Php
How to create hash password in laravel 8 ?
Laravel provides robust security features and one of them are hash password which is not decryptable. For hashing the password laravel use secure Bcrypt and Argon2 hashing for storing user passwords. Password encrypted with Bcrypt can not be decrypt since it uses key to generate the hashed string and irreversible…
Php
How to encrypt and decrypt string in laravel 8 ?
Laravel provides inbuilt library to encrypt and decrypt the strings. Laravel usage OpenSSL to provide AES-256 encryption which creates long encrypted string. Encryption and decryption is a technique to hide the useful some information in a form which is not readable. In this tutorial i will show you to encrypt…
Php
Laravel min in eloquent query with example
In this article we will learn to use aggregate function min in laravel eloquent and query builder. Laravel itself provide inbuilt method to min the columns like in MySQL or SQL based database we can do min of columns using min aggregate function. Min method will give you the most…