$wpdb->update question

• 

  pmolubricantscom · Member · Nov 12, 2021 at 7:29 am

  • Copy link
  • Add topic to favorites

  Hello,

  can this be simplified into one query using $wpdb->update?

  //Update user login
  global $wpdb;
  $wpdb->update(
      $wpdb->users,
      array('user_login' => $new_user_email),
      array('ID' => $user_id)
  );
  
  //Update user nicename
  $wpdb->update(
      $wpdb->users,
      array('user_nicename' => $new_user_email),
      array('ID' => $user_id)
  );
  
  //Update user display_name
  $wpdb->update(
      $wpdb->users,
      array('display_name' => $new_user_email),
      array('ID' => $user_id)
  );

• 

  kokkieh · Staff · Nov 12, 2021 at 7:48 am

  • Copy link

  Hi there,

  I think this is a better question for the WordPress.org community who make the open source WordPress software. The forum you’re posting in now provides support for owners of free sites hosted on WordPress.com, and we’re not able to help with development-related questions here.

  You can find the advanced support forums on WordPress.org here:

  https://wordpress.org/support/forums/advanced-wp/

  You can also try asking in the WordPress stackexchange forum, here:

  https://wordpress.stackexchange.com/

• 

  pmolubricantscom · Member · Nov 12, 2021 at 8:04 am

  • Copy link

  Thank you @kokkieh.

  Have a great day!