How to use AR to operate database in ThinkPHP6

ThinkPHP is a popular PHP development framework that provides rich database operation functions. The most commonly used one is Active Record mode (hereinafter referred to as AR). AR mode is an object-oriented database operation mode, which maps database tables to objects, allowing us to operate the database more conveniently and quickly. This article will introduce how to use AR to operate the database in ThinkPHP6.

1. Configure database connection

Before using AR, we need to configure the database connection information first. In the database.php file in the config directory, fill in the corresponding database information as follows:

return [
    // 数据库类型
    'type'            => 'mysql',
    // 服务器地址
    'hostname'        => 'localhost',
    // 数据库名
    'database'        => 'test',
    // 用户名
    'username'        => 'root',
    // 密码
    'password'        => '',
    // 端口
    'hostport'        => '',
    // 数据库连接参数
    'params'          => [],
    // 数据库编码默认采用utf8
    'charset'         => 'utf8',
    // 数据库表前缀
    'prefix'          => '',
    // 数据库调试模式
    'debug'           => true,
];

2. Create model class

In ThinkPHP’s AR, each Each table corresponds to a model class. We need to create a model class and inherit the thinkModel class. Taking the "users" table as an example, create a Users model class:

namespace appmodel;

use thinkModel;

class Users extends Model
{
    // 定义用户表名
    protected $table = 'users';
}

In the model class, we can define some database-related information, including table name, primary key, field information, etc. Doing so makes operation more convenient.

3. Querying data

In ThinkPHP’s AR, querying data is very convenient. We only need to call the corresponding method in the model class. For example, if we want to query all user data (equivalent to SELECT * FROM users), we can use the following method:

$users = Users::select();

Use the select method to query all data. The default is to query the data of the entire table. In addition, you can also use the where method to specify query conditions, the orderBy method to specify sorting conditions, and so on.

4. New data

It is equally convenient to add new data. We just need to create an instance in the model class, set the property value and call the save method. For example, if we want to add a new piece of user data, we can use the following method:

$user = new Users;
$user->username = 'tom';
$user->email = 'tom@example.com';
$user->save();

In the above code, we first create a Users instance, then set the username and email attribute values, and finally call the save method to The data is saved to the database.

5. Update data

Updating data is also very simple. We only need to first query the data to be updated, then set its attribute value and call the save method. For example, if we want to modify the username of the user with id 1, we can use the following method:

$user = Users::get(1);
$user->username = 'jerry';
$user->save();

In the above code, we first query the user data with id 1 through the get method, and then modify its username attribute value, and finally the save method is called to update the data to the database.

6. Delete data

Deleting data is also very simple. We only need to call the corresponding method in the model class. For example, if we want to delete the user data with id 1, we can use the following method:

$user = Users::get(1);
$user->delete();

In the above code, we first query the user data with id 1 through the get method, and then call the delete method to delete the data Delete from database.

To sum up, AR mode is a very convenient way to operate the database. It maps database tables to objects, allowing us to operate the database more conveniently and quickly. In ThinkPHP6, the use of AR is also very simple. We only need to inherit the hinkModel class, and then use the corresponding methods to perform operations such as additions, deletions, modifications, and searches.

The above is the detailed content of How to use AR to operate database in ThinkPHP6. For more information, please follow other related articles on the PHP Chinese website!