Top Laravel Interview Questions and Answers

with() function is used to eager load in Laravel. Unless of using 2 or more separate queries to fetch data from the database, we can use it with() method after the first command. It provides a better user experience as we do not have to wait for a longer period of time in fetching data from the database.

You can do this in various ways. Steps are given below:-

• Copy .htaccess file from public folder and now paste it into your root.
• Now rename server.php file/page to index.php on your root folder.
• Now you can remove /public word from URL and refresh the page. Now it will work.

Laravel supports various joins that's are given below:-

• Inner Join

  DB::table('admin') ->join('contacts', 'admin.id', '=', 'contacts.user_id') ->join('orders', 'admin.id', '=', 'orders.user_id') ->select('users.id', 'contacts.phone', 'orders.price') ->get();

• Left Join / Right Join

  $users = DB::table('admin') ->leftJoin('posts', 'admin.id', '=', 'posts.admin_id') ->get();
$users = DB::table('admin') ->rightJoin('posts', 'admin.id', '=', 'posts.admin_id') ->get();

• Cross Join

  $user = DB::table('sizes') ->crossJoin('colours') ->get();

• Advanced Join

  DB::table('admin') ->join('contacts', function ($join) { $join->on('admin.id', '=', 'contacts.admin_id')->orOn(...); }) ->get();

• Sub-Query Joins

  $admin = DB::table('admin') ->joinSub($latestPosts, 'latest_posts', function ($join) { $join->on('admin.id', '=', 'latest_posts.admin_id'); })->get();

request()->route()->getActionMethod()

You can use request()->ip();

You can also use : Request::ip() but in this case, we have to call namespace like this: Use Illuminate\Http\Request;

We have to call Facades in our controller file with this :
use Illuminate\Support\Facades\Storage;

Soft delete is a laravel feature that helps When models are soft deleted, they are not actually removed from our database. Instead, a deleted_at timestamp is set on the record. To enable soft deletes for a model, we have to specify the soft delete property on the model like this.

In model we have to use namespace use Illuminate\Database\Eloquent\SoftDeletes;

and we can use this
use SoftDeletes; in our model property.

After that when we will use delete() query then records will not remove from our database. then a deleted_at timestamp is set on the record.

In Laravel, Facades are used to provide a static interface to classes available inside the application's service container.

Now, unlike conventional static method calls, facades can be mocked in Laravel. It can be done using the shouldRecieve method, which shall return an instance of a facade mock.

To use multiple databases in Laravel, follow these steps carefully.

• Ensure these settings in the .env file
• Add these following lines of code in the config/database.php file to clearly define the relationship between the two databases
• Execute the query with particular database.

1. Ensure these settings in the .env file

DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3306
DB_DATABASE=your_db_name
DB_USERNAME=bestinterviewquestion
DB_PASSWORD=admin@123

DB_CONNECTION_SECOND=mysql
DB_HOST_SECOND=localhost
DB_PORT_SECOND=3306
DB_DATABASE_SECOND=your_db_name2
DB_USERNAME_SECOND=bestinterviewquestion
DB_PASSWORD_SECOND=admin@12345

2. Add these following lines of code in the config/database.php file to clearly define the relationship between the two databases

'mysql' => [
    'driver'    => env('DB_CONNECTION'),
    'host'      => env('DB_HOST'),
    'port'      => env('DB_PORT'),
    'database'  => env('DB_DATABASE'),
    'username'  => env('DB_USERNAME'),
    'password'  => env('DB_PASSWORD'),
],

'mysql2' => [
    'driver'    => env('DB_CONNECTION_SECOND'),
    'host'      => env('DB_HOST_SECOND'),
    'port'      => env('DB_PORT_SECOND'),
    'database'  => env('DB_DATABASE_SECOND'),
    'username'  => env('DB_USERNAME_SECOND'),
    'password'  => env('DB_PASSWORD_SECOND'),
],

3. Execute Query

$users = DB::connection('your_db_name2')->select();

Laravel involves Eloquent ORM (Object Relational Mapper), which makes it fun to interact with the database. While using Eloquent, every database table contains their corresponding “Model” that is being used for interaction with that table. The eloquent model also allows the people to insert, update, and delete the records from the table. We can create Eloquent models using the make:model command.

It has many types of relationships.

• One To One relationships
• One To Many relationships
• Many To Many relationships
• Has Many Through relationships
• Polymorphic relationships
• Many To Many Polymorphic relationships