How to add fields after 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. We need to use the foreach statement to loop through the two-dimensional array $list, which needs to be noted.

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();

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!