How to append data in Cakephp 3 returned resultset

Need Help
1

hi, i am trying to append data into cakephp resultset.
I am fetching data as $profile = $this->Profiles->find()->where(['user_id' => $id])->hydrate(false)->first()
query returning
[id] => 233
[name] => amit
[email] => 1041391266@gmail.com
[profile_image] =>
[bg_color] => #31665c
[status] => 1

Now i want to append a column in this data as
[id] => 233
[name] => amit
[email] => 1041391266@gmail.com
[profile_image] =>
[bg_color] => #31665c
[status] => 1
[‘internal’] => 1

But i dont know how to execute that.

2

There are sevaral ways to do it based on where the new property internal is coming from.
For example you can add it in the entity as a virtual filed, or add to to the resultset by calling the collection class map() method.

3

As you don’t hydrate your query, you can simply use php func:

array_push($profile["internal"], $newdata);

But as say @rrd, there is many way to do it :wink:

4

$profile->internal =1;
done that for me thanks everyone for replying;