Database configuration in Laravel - Mini Project: Build & Apply

Database configuration

📖 Scenario: You are building a Laravel web application that needs to connect to a MySQL database to store user data.

🎯 Goal: Set up the database connection configuration in Laravel so the application can communicate with the MySQL database.

📋 What You'll Learn

Create the database configuration array with exact keys and values

Add a variable for the default database connection name

Use the configuration array to set up the MySQL connection details

Complete the configuration by returning the full database config array

💡 Why This Matters

🌍 Real World

Laravel applications need a database configuration file to connect to databases like MySQL. This setup is essential for storing and retrieving application data.

💼 Career

Understanding how to configure databases in Laravel is a key skill for backend developers working with PHP frameworks.

1

Create the initial database configuration array

Create a PHP array called $databaseConfig with these exact keys and values: 'default' => 'mysql', 'connections' => [].

Laravel

$databaseConfig = [
    // Your code here
];

Need a hint?

Use square brackets to create the array and include the keys 'default' and 'connections' exactly as shown.

2

Add the MySQL connection configuration

Add a key 'mysql' inside the 'connections' array of $databaseConfig. Set its value to an array with these exact keys and values: 'driver' => 'mysql', 'host' => '127.0.0.1', 'port' => '3306', 'database' => 'laravel_db', 'username' => 'root', 'password' => ''.

Laravel

$databaseConfig = [
    'default' => 'mysql',
    'connections' => [
        // Your code here
    ]
];

Need a hint?

Remember to nest the MySQL connection array inside the 'connections' array with the key 'mysql'.

3

Set the default connection variable

Create a variable called $defaultConnection and set it to the value of the 'default' key from the $databaseConfig array.

Laravel

$databaseConfig = [
    'default' => 'mysql',
    'connections' => [
        'mysql' => [
            'driver' => 'mysql',
            'host' => '127.0.0.1',
            'port' => '3306',
            'database' => 'laravel_db',
            'username' => 'root',
            'password' => ''
        ]
    ]
];

// Your code here

Need a hint?

Use the array key 'default' to get the default connection name from $databaseConfig.

4

Return the complete database configuration

Add a return statement that returns the $databaseConfig array at the end of the PHP file.

Laravel

$databaseConfig = [
    'default' => 'mysql',
    'connections' => [
        'mysql' => [
            'driver' => 'mysql',
            'host' => '127.0.0.1',
            'port' => '3306',
            'database' => 'laravel_db',
            'username' => 'root',
            'password' => ''
        ]
    ]
];

$defaultConnection = $databaseConfig['default'];

// Your code here

Need a hint?

Use return $databaseConfig; to finish the configuration file.