Shilpa Kalangutkar has Published 53 Articles

How to select count with Laravel's fluent query builder?

Shilpa Kalangutkar

Shilpa Kalangutkar

Updated on 30-Aug-2022 08:18:19

16K+ Views

The fluent query builder in Laravel is an interface that takes care of creating and running the database queries. The query builder works fine with all databases supported in laravel and can be used to perform almost all database operations on it. The advantage of using a fluent query builder ... Read More

What is Fillable Attribute in a Laravel model?

Shilpa Kalangutkar

Shilpa Kalangutkar

Updated on 29-Aug-2022 13:04:41

21K+ Views

The fillable property is used inside the model. It takes care of defining which fields are to be considered when the user will insert or update data. Only the fields marked as fillable are used in the mass assignment. This is done to avoid mass assignment data attacks when the ... Read More

How to get distinct values for non-key column fields in Laravel?

Shilpa Kalangutkar

Shilpa Kalangutkar

Updated on 29-Aug-2022 12:52:36

7K+ Views

Here are different ways that can give you distinct values for non-key column fields in Laravel. Assume we have created a table named students with the following query CREATE TABLE students( id INTEGER ... Read More

How to select all the column names from a table in Laravel?

Shilpa Kalangutkar

Shilpa Kalangutkar

Updated on 29-Aug-2022 12:23:13

3K+ Views

Here are different ways to get the column names from a table in Laravel. Assume we have created a table named Students in MySQL database using the following query − CREATE TABLE students( id INTEGER ... Read More

How to find a user in Laravel by Username?

Shilpa Kalangutkar

Shilpa Kalangutkar

Updated on 29-Aug-2022 12:15:48

2K+ Views

There are various ways to find a Username in Laravel Using the first() method ExampleThe first() method returns the record found for the search value. It returns null if there are no matching records. To this method You can make use of the method first() to find the user by ... Read More

How to alias a table in Laravel Eloquent queries using Query Builder?

Shilpa Kalangutkar

Shilpa Kalangutkar

Updated on 29-Aug-2022 12:13:01

7K+ Views

Eloquent is a new object-relational mapper (ORM) that helps to interact with the database. With Eloquent each table has a mapping Model that takes care of all the operations on that table. Assume we have already created a table with the name student with the following contents − +----+---------------+------------------+-----------------------------+-----------------------------+---------+------+ | ... Read More

How to Use OrderBy for Multiple Columns in Laravel?

Shilpa Kalangutkar

Shilpa Kalangutkar

Updated on 29-Aug-2022 12:08:07

5K+ Views

The ORDERBY clause is used to arrange the columns in a table in ascending or descending order. By default it sorts the columns in ascending order, if you need to sort in descending order you should use DSC along with the clause. Syntax Following is the syntax of this statement ... Read More

How to access the public directory in Laravel?

Shilpa Kalangutkar

Shilpa Kalangutkar

Updated on 29-Aug-2022 11:59:49

5K+ Views

To get the file list from a public directory you can make use of the File facade class. To work with it you need to include the File class using the following statement – use Illuminate\Support\Facades\File; Assume we have the following files in the public folder − ... Read More

How to validate an array in Laravel?

Shilpa Kalangutkar

Shilpa Kalangutkar

Updated on 29-Aug-2022 11:43:24

6K+ Views

There are various ways to validate the input data in Laravel. One of those is the Validator class. The first step is that you need to include this class as shown below − use Illuminate\Support\Facades\Validator; When you work with an array you need to mention the keys and the ... Read More

How to add a new column to an existing table of Laravel in a migration?

Shilpa Kalangutkar

Shilpa Kalangutkar

Updated on 29-Aug-2022 11:37:31

11K+ Views

The make:migration Artisan in Laravel (9) enables you to generate a database migration. You can find the resultant migration files are the database/migrations directory. Using this command, we can add a new column to a table (in addition to other operations). Syntax First of all let us first create a ... Read More

Advertisements