Before add save data

1. NAME
   
2. CITY_ID
   CITIES
   
   ----------------
   
   1.ID
   
3. NAME_CITY
   COPY_OF_PEOPLE
   
   ---------------
   
4. NAME
   
5. CITY_ID
   
6. CITY_NAME
   When I add in PEOPLE I save values in other data with
   
   $data = array();
   
   $data["name"] = $values["name"];
   
   $data["city_id"] = $values["city_id"];
   
   DB::Insert("copy_of_people", $data );
   All ok. The same code I use to send an email
   The problem is how can I save also the name of the city. And send by mail. I try:
   $data["city_name"] = $values["????"];
   In ???? I don't know how can I get and save name_city from CITIES table
   Any idea? thanks
   

I would use a quick session. Before the e-mail and DB::Insert code, use this:

Then you can use

for

, and

in the email.
At the end, just

to clear that data.

Use DBLookup function:

https://xlinesoft.com/phprunner/docs/dblookup_2.htm

Thanks. I try this code, but I get this error: Parse error: syntax error, unexpected ':' in /var/www/vhosts/.........
May be DB::DBLookup?
I have in Before Add

But then I got error:
Fatal error: Uncaught Error: Call to undefined method DB::DBLookup() in /var/www/vhosts/xxxxxxxx/xxxxxxxx/include/formulario_empresas_events.php:216 Stack trace: #0 /var/www/vhosts/xxxxxxxxx/classes/addpage.php(573): eventclass_formulario_empresas->BeforeAdd(Array, '', false, Object(AddPage)) #1 /var/www/vhosts/xxxxxxx/classes/addpage.php(394): AddPage->callBeforeAddEvent() #2 /var/www/vhosts/xxxxxxxx/classes/addpage.php(326): AddPage->processDataInput() #3 /var/www/vhosts/xxxxxxx/formulario_empresas_add.php(86): AddPage->process() #4 {main} thrown in /var/www/vhosts/xxxxxxxx/include/formulario_empresas_events.php on line 216

You can use the following:

Perfect!