Forums

Register ID in another database table

rafaelscouto 05 Mar, 2018
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.
rafaelscouto 06 Mar, 2018
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]
This topic is locked and no more replies can be posted.