Home > PHP Framework > Laravel > body text

How to implement add, delete, modify and check functions in Laravel

PHPz
Release: 2023-04-12 09:37:45
Original
1357 people have browsed it

Laravel is a web application development framework based on PHP. Its powerful and flexible features are increasingly sought after by developers. When using Laravel to develop projects, it is a very common requirement to perform CRUD operations on the database. This article will introduce how to use Laravel to add, delete, modify and query database tables.

1. Connect to the database

In Laravel, connecting to the database requires modifying the .env file. In this file, we can define the database connection method, user name, password, database name and other information. The following is an example of a .env file:

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=laravel
DB_USERNAME=root
DB_PASSWORD=
Copy after login

Among them, DB_CONNECTION represents the database type used, which can be mysql, sqlite, pgsql, etc. DB_HOST represents the host address of the database, DB_PORT represents the port number of the database, DB_DATABASE represents the name of the database, DB_USERNAME represents the user who connects to the database Name, DB_PASSWORD represents the password to connect to the database.

2. Create a data table

In Laravel, you can use the artisan make:model command to create a model corresponding to the database table. Before generating the model file, we need to define the structure of the database table. In Laravel, you can use migration files to define the database table structure.

In the root directory of the Laravel project, use the following command to create a migration file named create_users_table:

php artisan make:migration create_users_table --create=users
Copy after login

where create_users_table is the migration file The name, --create=users means that we want to create a data table named users.

Modify the generated migration file and define the database table structure in the up method. For example, if we want to create a table named users, containing three fields: name, email and password, then we can do it as follows Define in the following way:

public function up()
{
    Schema::create('users', function (Blueprint $table) {
        $table->id();
        $table->string('name');
        $table->string('email')->unique();
        $table->string('password');
        $table->timestamps();
    });
}
Copy after login

After defining the migration file, execute the following command to apply the migration file to the database:

php artisan migrate
Copy after login

After successful execution, you can see the newly created Data sheet.

3. Add data

In Laravel, you can add, delete, modify and query database tables through the Eloquent model. In the previous step, we have created the User model. You can create a new user in the following way:

$user = new User;
$user->name = 'john';
$user->email = 'john@example.com';
$user->password = Hash::make('password');
$user->save();
Copy after login

First create a new User model object , then set the attributes of the model (that is, the fields of the data table), and finally call the save method to save the data to the database.

In addition, you can also use the create method to create and save model instances at one time:

$user = User::create([
    'name' => 'jane',
    'email' => 'jane@example.com',
    'password' => Hash::make('password')
]);
Copy after login

4. Query data

In Laravel, you can Use the Eloquent model to perform query operations on database tables. The following are some common query methods:

  1. Get all model instances (that is, all records in the data table):
$users = User::all();
Copy after login
  1. Get model instances based on the primary key:
$user = User::find(1);
Copy after login
  1. Query model instances based on specified conditions:
$users = User::where('name', 'john')->get();
Copy after login
  1. Use advanced query methods:
$users = User::where('name', 'like', 'j%')
             ->orderBy('name', 'desc')
             ->take(10)
             ->get();
Copy after login

In use When using advanced query methods, multiple query conditions can be chained to filter out model instances that meet the requirements.

5. Modify data

In Laravel, you can update the data in the database table by modifying the attributes of the model instance. For example, to change the email address of the user record name to john to john@example.org, you can proceed as follows:

$user = User::where('name', 'john')->first();
$user->email = 'john@example.org';
$user->save();
Copy after login

Or use the update method to perform batch update operations:

User::where('name', 'john')->update(['email' => 'john@example.org']);
Copy after login

6. Delete data

In Laravel, you can use the Eloquent model to do it Database table deletion operation. To delete a specified model instance, you can use the following method:

$user = User::find(1);
$user->delete();
Copy after login

or use the destroy method to delete multiple model instances in batches:

User::where('name', 'john')->delete();
Copy after login

The above is using Laravel for database Basic knowledge of table addition, deletion, modification and query operations. Laravel has powerful ORM functions that can help developers perform database operations more efficiently.

The above is the detailed content of How to implement add, delete, modify and check functions in Laravel. For more information, please follow other related articles on the PHP Chinese website!

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!