Buy Now
Sign in

Register ID in another database table

rafaelscouto , March 05 at 18:07
R
rafaelscouto
Good afternoon, I need to solve a problem, my form creates registrations and links them to the login system of joomla, in case I have the tables USERS joomla core and PEOPLE, that I created through the form.​
​​
​What I need? Whenever I create a new user, take the ID registered in the USERS table, ID column and make an update to the PEOPLE table ID_USERS field, so I can control by ID the display of some features at the moment the user logs in.
R
rafaelscouto
Good morning
Follows de debug data:
[joomla_user3] => Array
(
[_success] => User saved successfully under id 603
[var] => Array
(
[name] => Teste01
[username] => Teste01@email.com
[email] => Teste01@email.com
[password] => Teste01
[block] => 0
[activation] => b98440e8-ce6f-4bfd-9420-3fe1b53ddfa7
[registerDate] => 2018-03-06 12:37:08
[id] => 603
)

)

[save_data4] => Array
(
[data] => Array
(
[created] => 2018-03-06 12:37:08
[block] => 0
[nome_completo] => Teste01
[cpf] => Teste01
[email] => Teste01@email.com
[telefone] => Teste01
)

[_success] => Data saved successfully
[log] => Array
(
[0] => INSERT INTO `vsg5v_z_cad-adm` (`created`, `block`, `nome_completo`, `cpf`, `email`, `telefone`) values ('2018-03-06 12:37:08', '0', 'Teste01', 'Teste01', 'Teste01@email.com', 'Teste01');
)

[var] => Array
(
[created] => 2018-03-06 12:37:08
[block] => 0
[nome_completo] => Teste01
[cpf] => Teste01
[email] => Teste01@email.com
[telefone] => Teste01
[aid] => 206
)

)
What I need?​
​​
​Get the value of the ID saved in the USERS table and add it (update) to the field ID_USER in the table "z_cad-adm".
[save_data4]