How to implement addition, deletion, modification and check operation log recording in ThinkPHP5.1

1. Introduction to the logging function of ThinkPHP 5.1

In ThinkPHP 5.1, the logging function has been built-in. We can use it in our applications to record different types of events, such as error messages, debugging information, and user actions. Four levels of logging are provided by the framework: DEBUG, INFO, NOTICE and ERROR.

In addition to the built-in log levels, we can also define our own log levels. We can give an example by creating a log level named "CRUD" to record addition, deletion, modification and query operations.

By default, logs will be recorded to the log directory under the application root directory. If you need to change the log storage location, you can do so by modifying the configuration file. Configuration files are generally located in the application's config directory.

2. Implementation of log recording of add, delete, modify and check operations

Let’s take a look at how to implement log recording of add, delete, modify and check operations in ThinkPHP 5.1. We will follow the following steps to achieve it:

1. Create a custom configuration file in the config directory

2. Add log fields to the data table

3. Rewrite the addition, deletion and modification methods in the Model

4. Record logs

5. Create a custom configuration in the config directory File

We need to create a custom configuration file first and place it in the config directory of the application. We name this file common_extra.php.

$config = [

'crud_log' => true, // 记录增删改查日志
'crud_ignore_fields' => ['create_time', 'update_time'] // 忽略日志记录的字段

];

In the configuration, we set two options. The first is crud_log, which is used to turn logging on or off. The second is crud_ignore_fields, which is used to specify fields that are not logged.

2. Add log fields to the data table

Next, we need to add some fields to the data table to record addition, deletion, modification and query operations. We can add the following fields to each data table:

1. id (auto-increment primary key)

2. user_id (operation user id, can be empty )

3. action (operation type, such as add, delete, modify)

4. table_name (data table name of the operation)

5. data (operated data)

6. created_at (operation time)

7. Rewrite the addition, deletion and modification methods in the Model

Now we need to rewrite the addition, deletion and modification methods in the Model to implement logging. We will use global query scope to achieve this. We will override the create, update and delete methods.

In each method, we will record the corresponding operation type and data. We will then write the logs to the log file by using the log class.

Here are some sample codes:

namespace app\common\model;

use think\Model;

class User extends Model
{

protected $table = 'users';

// 添加全局查询范围
protected static function init()
{
    // 添加操作记录
    static::beforeInsert(function ($item) {
        if (config('common_extra.crud_log')) {
            $item->user_id = session('user_id');
            $item->action = 'add';
            $item->table_name = $this->table;
            $item->data = json_encode($item->toArray(), JSON_UNESCAPED_UNICODE);
            $item->created_at = date('Y-m-d H:i:s', time());
            Db::table('log')->insert($item->toArray());
        }
    });

    // 修改操作记录
    static::beforeUpdate(function ($item) {
        if (config('common_extra.crud_log')) {
            $item->user_id = session('user_id');
            $item->action = 'update';
            $item->table_name = $this->table;
            $item->data = json_encode($item->toArray(), JSON_UNESCAPED_UNICODE);
            $item->created_at = date('Y-m-d H:i:s', time());
            Db::table('log')->insert($item->toArray());
        }
    });

    // 删除操作记录
    static::beforeDelete(function ($item) {
        if (config('common_extra.crud_log')) {
            $item->user_id = session('user_id');
            $item->action = 'delete';
            $item->table_name = $this->table;
            $item->data = json_encode($item->toArray(), JSON_UNESCAPED_UNICODE);
            $item->created_at = date('Y-m-d H:i:s', time());
            Db::table('log')->insert($item->toArray());
        }
    });
}

}

4. Logging

Finally, we will log. In the previous example, we wrote the log to a data table named "log". However, you can write the logs to a file, send them to a log server, or send them elsewhere if desired.

Through the above steps, we successfully implemented the function of logging addition, deletion, modification and query operations in ThinkPHP 5.1.

The above is the detailed content of How to implement addition, deletion, modification and check operation log recording in ThinkPHP5.1. For more information, please follow other related articles on the PHP Chinese website!