wp insert new users code example

Example 1: add user mysql wordpress

INSERT INTO `databasename`.`wp_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES ('4', 'demo', MD5('demo'), 'Your Name', '[email protected]', 'http://www.test.com/', '2011-06-07 00:00:00', '', '0', 'Your Name');
 
 
INSERT INTO `databasename`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '4', 'wp_capabilities', 'a:1:{s:13:"administrator";s:1:"1";}');
 
 
INSERT INTO `databasename`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '4', 'wp_user_level', '10');

Example 2: wp_insert_user

$website = "http://example.com";
$userdata = array(
    'user_login' =>  'login_name',
    'user_url'   =>  $website,
    'user_pass'  =>  'plain_password' // When creating an user, `user_pass` is expected.
);
 
$user_id = wp_insert_user( $userdata ) ;
 
// On success.
if ( ! is_wp_error( $user_id ) ) {
    echo "User created : ". $user_id;
}

Tags:

Sql Example