How to modify the database using Laravel

Laravel is a popular PHP framework that takes full advantage of modern PHP language features to build efficient and easy-to-maintain web applications. One of the most used functions is to interact with the database to add, delete, modify and query data. This article will introduce how to use Laravel to modify the database.

1. Configuring the database connection

Before using Laravel to operate the database, we need to configure the database connection first. Open the .env file and modify the following configuration items:

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=your_database_name
DB_USERNAME=your_database_username
DB_PASSWORD=your_database_password

Change your_database_name, your_database_username and your_database_password Enter the name, username, and password for your MySQL database.

2. Create database migration files

In Laravel, we use migration files to create and modify the database table structure. You can use the command line tool php artisan to create the migration file for the users table. Enter the following command in the terminal:

php artisan make:migration modify_users_table --table=users

This command will create a migration file in the database/migrations directory, and include the word modify_users_table in the naming rule . Now, we can edit this file to modify the database table structure.

3. Modify the database table structure

In the migration file, we can use the up method to modify the database table structure. The following is an example of modifying the users table to add a phone field:

public function up()
{
    Schema::table('users', function (Blueprint $table) {
        $table->string('phone')->after('name')->nullable();
    });
}

In this example, we add a field to the users table phone field and set it after the name field. nullable()The method indicates that the field is allowed to be empty. When adding, deleting, modifying, and checking the table content, in order to facilitate management, we can also subtract this field in the corresponding down method:

public function down()
{
    Schema::table('users', function (Blueprint $table) {
        $table->dropColumn('phone');
    });
}

4. Run database migration

After completing the above modifications, we need to apply the migration file to the database. Enter the following command in the terminal:

php artisan migrate

This command will execute the up method of all migration files that have not been applied to the database and apply them to the database. If you encounter an error when applying migration files, you can roll back the migration with the following command:

php artisan migrate:rollback

The rollback command will execute the down method of all migration files that have been applied to the database, and will It is deleted from the database.

5. Use Laravel to modify database records

After completing the above modifications, we can use Laravel's Eloquent ORM to modify database records. The following is an example of using Eloquent to modify records in the users table:

$user = User::find(1);
$user->phone = '1234567890';
$user->save();

In this example, we use the find method to find the id 1 user record, and set its phone field to 1234567890, and then use the save method to save the changes.

Summary

Laravel provides automated migration tools to synchronize database table structure and code. It should be noted that after modifying the table structure, the migration file must be run to update the database to the latest state. The migration file must also be run for the next modification. Using Eloquent ORM can easily operate the database and realize the addition, deletion, modification and query of data.

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