How to Auto Login After Registration in WordPress with core php

Question

I've been trying for days now to take users who have just registered to my WordPress site and automatically log them in and then redirect them to a URL of my choice.

By default, WordPress sends you a username and a password, then you must log in manually. This is a total pain. How can i overcome this.

I have my own registration page(core php page) which successfully adds users into DB. But the point is, i should avoid users to login again.

Once registration is done, it should automatically redirects to home page or profile page.

I am a newbie to wordpress functionalities. It would be grateful if someone(who have knowledge on core functionality of wordpress) at least suggests a way/solution.

Looking forward.
Thanks

Answer 1

Thanks for your support guys..i did on my own with the following code..thanks for your time and support :)

<i>$getdetails= mysql_fetch_array(mysql_query("SELECT * FROM `wp_users` WHERE `ID`='$user_id'"));
$username=$getdetails['user_login'];


$creds = array();
$creds['user_login'] = $username;
$creds['user_password'] = $password;
$creds['remember'] = true;

    $user = wp_signon( $creds, false );
    if ( is_wp_error($user) ){
        echo $user->get_error_message();
    }else{
        wp_redirect( home_url() );
    }