How to add fields after data query in ThinkPHP

In the development process using ThinkPHP, we often need to perform further operations based on the queried data, one of which is to add fields. This article will introduce how to add fields after performing data query in ThinkPHP.

1. Query data

Let’s first review how to query data in ThinkPHP. In the controller, we can query data through the following code:

$User = M('User');
$list = $User->where('status=1')->select();
$this->assign('list',$list);
$this->display();

The above code implements querying the data with status equal to 1 in the data table named User, and assigns the query result to list variables are displayed.

2. Add a field

If we need to add a field to the queried data for marking or other operations, how do we need to do it?

In ThinkPHP, we can add fields to the queried data through the following methods:

$User = M('User');
$list = $User->where('status=1')->select();
foreach ($list as $key=>$val){
    $list[$key]['new_field'] = 'new_value';
}
$this->assign('list',$list);
$this->display();

In the above code, when we loop through the query results, we add a new_field field, and Assign its value to new_value. It should be noted that since $list is a two-dimensional array, we need to use the foreach statement to loop through it.

3. Complete code

The final code is as follows:

$User = M('User');
$list = $User->where('status=1')->select();
foreach ($list as $key=>$val){
    $list[$key]['new_field'] = 'new_value';
}
$this->assign('list',$list);
$this->display();

4. Summary

The method of adding fields after data query is implemented through the above code, you can Let us operate and display data more conveniently. At the same time, when adding data, you need to pay attention to the key-value relationship and data type issues of the array to ensure the correctness and efficiency of the code.

The above is the detailed content of How to add fields after data query in ThinkPHP. For more information, please follow other related articles on the PHP Chinese website!