How to connect to database using Laravel

Laravel is a popular PHP framework used to develop many full-featured web applications. This framework is based on the MVC (Model-View-Controller) architecture. It has a very powerful database access layer that can easily connect to various databases. In this article, we will discuss how to connect to a database using Laravel.

Laravel provides a very convenient way to handle database operations. Before connecting to the database, you need to configure the database connection information. Open the .env file in the project and set the following information:

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=database_name
DB_USERNAME=database_username
DB_PASSWORD=database_password

Here, we set the database type, host name, port number, database name, username and password. If you are using a different database, you can simply change these settings to suit your environment.

Next, connecting to the database in Laravel is very simple. Just open the config/database.php file and look for the following code:

'connections' => [

    'mysql' => [
        'driver' => 'mysql',
        'url' => env('DATABASE_URL'),
        'host' => env('DB_HOST', '127.0.0.1'),
        'port' => env('DB_PORT', '3306'),
        'database' => env('DB_DATABASE', 'forge'),
        'username' => env('DB_USERNAME', 'forge'),
        'password' => env('DB_PASSWORD', ''),
        'unix_socket' => env('DB_SOCKET', ''),
        'charset' => 'utf8mb4',
        'collation' => 'utf8mb4_unicode_ci',
        'prefix' => '',
        'prefix_indexes' => true,
        'strict' => true,
        'engine' => null,
        'options' => extension_loaded('pdo_mysql') ? array_filter([
            PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
        ]) : [],
    ],

],

Here, we can see that the connection information is the same as what was previously set in the .env file. So we don't need to set this information again. In addition, we can also set some other options, such as character set, table prefix, etc.

Now, we have successfully connected to the database and are ready to start using it. In Laravel, we can use Eloquent for querying. Eloquent is a lightweight ORM (Object Relational Mapping) library that can easily map tables in a database to PHP objects.

Here is a sample code that demonstrates how to create a user record:

$user = new User;
$user->name = 'John Doe';
$user->email = 'john@example.com';
$user->save();

Here we create a user named "John Doe" and set his email to " john@example.com". Then, we call the "save" method to save this record.

We can also use the queryer to query database records. Here is a sample code that demonstrates how to use a queryer to find a user named "John Doe":

$users = DB::table('users')
            ->where('name', 'John Doe')
            ->get();

Here, we have used the DB Facade to gain access to the "users" table. Use the "where" method to specify the records we want to find, and then use the "get" method to obtain the result set.

To summarize, connecting to a database using Laravel is very simple. Just set up the database connection information and use Laravel's built-in ORM or queryer to operate. If you are a web developer, using Laravel to handle database operations is a very convenient and efficient thing.

The above is the detailed content of How to connect to database using Laravel. For more information, please follow other related articles on the PHP Chinese website!