Delete user programmatically in wordpress

Question

In Wordpress, How can I delete a user pro grammatically if I have a user ID?

I am using below code.

$user_id = 4;
$roles = array();
$user = get_userdata($user_id);
$capabilities = $user->{$wpdb->prefix . 'capabilities'};

if (!isset($wp_roles))
    $wp_roles = new WP_Roles();

foreach ($wp_roles->role_names as $role => $name) :

    if (array_key_exists($role, $capabilities))
        $roles[] = $role;

endforeach;

if (!in_array("administrator", $roles)) {
    if (wp_delete_user($user_id)) {
        echo 'User deleted' . $user_id;
        echo '<br>';
    }
}

It is not working for me. Please help me where am I wrong?

Are you trying to delete a user, if he is not admin??

hemnath mouli
– hemnath mouli

2016-07-17 10:09:10 +00:00
Commented Jul 17, 2016 at 10:09 — hemnath mouli
– hemnath mouli, Commented Jul 17, 2016 at 10:09
Yes. I am trying to delete a user, if he is not admin.

Aftab H.
– Aftab H.

2016-07-17 10:15:45 +00:00
Commented Jul 17, 2016 at 10:15 — Aftab H.
– Aftab H., Commented Jul 17, 2016 at 10:15

Akhtarujjaman Shuvo · Accepted Answer · 2022-04-26 21:22:41Z

3

This is what I use to delete user along with the metadata.

global $wpdb;
$user_id = "123"; // User id is 123

// Delete User metadata
$wpdb->delete($wpdb->usermeta, ['user_id' => $user_id], ['%d']);

// Delete User
$wpdb->delete($wpdb->users, ['ID' => $user_id], ['%d']);

answered Apr 26, 2022 at 21:22

Akhtarujjaman Shuvo

6909 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

hemnath mouli · Accepted Answer · 2016-07-17 12:00:44Z

2

Try this

$user_id                =   1;
$user_info              =   get_userdata( $user_id );
$this_user_roles        =   $user_info->roles;

//For wp_delete_user() function
require_once(ABSPATH.'wp-admin/includes/user.php' );

if( in_array( "administrator", $this_user_roles) ) {
    echo "This user is admin, cannot be deleted";
} else {
    if( wp_delete_user( $user_id ) ){
        echo "Success user deleted :)";
    } else {
        echo "There is a problem while deleting the user.";
    }
}

edited Jul 17, 2016 at 12:00

answered Jul 17, 2016 at 10:22

hemnath mouli

2,7652 gold badges21 silver badges37 bronze badges

Comments

Aftab H. · Accepted Answer · 2016-07-17 10:43:06Z

0

I have found the solution to resolve my issue.I have just added a line in code. Now updated code as given below.

require_once(ABSPATH.'wp-admin/includes/user.php' );
$user_id = 4;
$roles = array();
$user = get_userdata($user_id);
$capabilities = $user->{$wpdb->prefix . 'capabilities'};
if (!isset($wp_roles))
    $wp_roles = new WP_Roles();
foreach ($wp_roles->role_names as $role => $name) :
    if (array_key_exists($role, $capabilities))
        $roles[] = $role;
endforeach;
if (!in_array("administrator", $roles)) {
    if (wp_delete_user($user_id)) {
        echo 'User deleted' . $user_id;
        echo '<br>';
    }
}

It is now working for me.

answered Jul 17, 2016 at 10:43

Aftab H.

1,5476 gold badges13 silver badges25 bronze badges

Comments

Igor Yavych · Accepted Answer · 2016-07-17 12:46:32Z

0

You could try the following

global $wpdb;
$ids = $wpdb->get_col('SELECT `user_id` FROM `' . $wpdb->prefix . 'usermeta` WHERE `meta_key` = \'wp_user_level\' AND `meta_value` < 8;');
if (count($ids) > 0)
{
    foreach ($ids as $id)
    {
        if (wp_delete_user($id))
        {
            echo 'User deleted' . $id;
            echo '<br>';
        }
    }
}

Use this table as reference for user levels

answered Jul 17, 2016 at 12:46

Igor Yavych

4,2543 gold badges24 silver badges43 bronze badges

Comments

Bret Weinraub · Accepted Answer · 2017-09-15 09:02:56Z

0

For WordPress multisite, you can remove a user quite simply from the SQL command line.

In the example below, the user_id is 838 and the site # is 20:

delete from wp_usermeta where user_id = 838 and meta_key in ('wp_20_capabilities', 'wp_20_user_level');

That's it!

answered Sep 15, 2017 at 9:02

Bret Weinraub

2,39321 silver badges24 bronze badges

Comments

Redsymbol Manage · Accepted Answer · 2024-12-02 10:42:11Z

0

You can use the following code:

function my_delete_user( $user_id ) {
    global $wpdb;
    $user_obj = get_userdata( $user_id );

    $id_user = $user_obj->ID;
    $idsss = $user_obj->user_id;


    /*Delete Data from friend table*/  
    $query_friend= $wpdb->query("DELETE FROM `wp_user_friends` where `friend_id` = ".$user_obj->ID."");

    /*delete data from group*/
    $delete_group_table =$wpdb->query("DELETE FROM `wp_group` where `user_id` = ".$user_obj->ID."");


}
add_action( 'delete_user', 'my_delete_user' );

answered Dec 2, 2024 at 10:42

Redsymbol Manage

71 bronze badge

Collectives™ on Stack Overflow

Delete user programmatically in wordpress

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related