[Resolved] Run Custom SQL Code After Creation of New User

[Author]

Posts

[aaronM-9]

Can you tell me if a CRED Hook is the best way to run custom SQL code immediately following the creation of a new user account (presumably after submitting a user registration form)? If so, do you use the cred_save_data hook? If this is the case, is the post ID argument used for the user ID and how do you specify the user ID if you do not know what it is until the user account has been generated? If you can't use this hook on user accounts (i.e. it can only be used for posts), how do I accomplish what I want to do?

Basically, I would like my website to prep some data whenever a new user signs up, so I'd like to run an INSERT query whenever a new user signs up.

Thanks for any help, and I apologize if somehow I missed this while reading through your Hooks documentation.

- Aaron

[aaronM-9]

PS - The title of that post should have read "Custom SQL Code" not customer! Sorry for the typo.

[Nigel Supporter Languages: English (English ) Spanish (Español ) Timezone: Europe/London (GMT+01:00)]

Hi Aaron

Yes, the documentation is not too helpful here, as the cred_save_data hook, or the cred_submit_complete hook which you could also use, are the same for both post and user forms, and the post_id argument would be just that, the post id of the newly created post, for post forms, or the user id of the newly created user for user forms.

Note that you are not providing the user id (via post_id), the hook makes that available to you.

To see what you are dealing with, I would print the arguments to your debug log so that you can inspect them, e.g.

add_action( 'cred_save_data', 'tssupp_test_hook', 10, 2 );
function tssupp_test_hook( $post_id, $form_data ){

	error_log( "id is: " . $post_id );
	error_log(print_r($form_data, true));
}

If you haven't already, turn on the debug log by editing your wp-config.php file and change the line with WP_DEBUG like so:

define('WP_DEBUG', true);
define('WP_DEBUG_LOG', true);
define('WP_DEBUG_DISPLAY', false);

That will create a debug log called debug.log in your wp-content directory which you can examine in any text editor.

[aaronM-9]

Thanks for the help. It may take me a little bit longer to iron out the details, but I think this tells me what I need to know.