Top Laravel Interview Questions and Answers

Blog::where(['id' => 5])->orWhere([‘username’ => ‘[email protected]’])->update([
    'title' => ‘Best Interview Questions’,
]);

Laravel provides various methods that we can use in queries to get records with our conditions.

These methods are given below

• where()
• orWhere()
• whereBetween()
• orWhereBetween()
• whereNotBetween()
• orWhereNotBetween()
• wherein()
• whereNotIn()
• orWhereIn()
• orWhereNotIn()
• whereNull()
• whereNotNull()
• orWhereNull()
• orWhereNotNull()
• whereDate()
• whereMonth()
• whereDay()
• whereYear()
• whereTime()
• whereColumn()
• orWhereColumn()
• whereExists()

updateOrInsert() method is used to update an existing record in the database if matching the condition or create if no matching record exists.

Its return type is Boolean.

Syntax

DB::table(‘blogs’)->updateOrInsert([Conditions],[fields with value]);

We can use hasTable() to check table exists in our database or not.

Syntax

Schema::hasTable('users'); // here users are the table name.

if(Schema::hasTable('users')) {
   // table is exists
} else {
   // table is not exist
}

if(Schema::hasColumn('admin', 'username')) ; //check whether admin table has username column
{
   // write your logic here
}

Inserts(): This method is used for insert records into the database table. No need the “id” should be autoincremented or not in the table.

Example

DB::table('bestinterviewquestion_users')->insert(
    ['title' => 'Best Interview Questions', 'email' => ‘[email protected]’]
);

It will return true or false.

insertGetId(): This method is also used for insert records into the database table. This method is used in the case when an id field of the table is auto incrementing.

It returns the id of current inserted records.

Example

$id = DB::table('bestinterviewquestion_users')->insert(
    ['title' => 'Best Interview Questions', 'email' => ‘[email protected]’]
);

Laravel accessors and mutators are customs, user-defined methods that allow you to format Eloquent attributes. Accessors are used to format attributes when you retrieve them from the database.

1. Defining an accessor

The syntax of an accessor is where getNameAttribute() Name is capitalized attribute you want to access.

public function getNameAttribute($value)
{
    return ucfirst($value);
}

2. Defining a mutator

Mutators format the attributes before saving them to the database.

The syntax of a mutator function is where setNameAttribute() Name is a camel-cased column you want to access. So, once again, let’s use our Name column, but this time we want to make a change before saving it to the database:

public function setNameAttribute($value)
{
    $this->attributes['name'] = ucfirst($value);
}

Please update 'default' => env('DB_CONNECTION', 'mysql'), in config/database.php. Update MySQL as a database whatever you want.

Lumen is a newly introduced micro PHP framework which is a faster, smaller and leaner version of a full web application framework. It is introduced by Taylor Otwell, the creator of Laravel. It uses the same components as Laravel, but especially for microservices.

It has a simple installer like Laravel. You have to use this command to install lumen.
composer global require "laravel/lumen-installer=~1.0"

You can use an artisan command php artisan --version to know the laravel version.