Relate WP user to existing DB user

  • szerendipal

    (@szerendipal)


    4 years, 1 month ago

    I have WordPress and its tables installed and I also have another database where 1 table contains users with user IDs. I want to let my website visitors to register on my site and after that, browse the list of users from that other DB table, and “claim” one profile. In other words, create a relationship between their WP ID and on of the existing user IDs they select. Is there a plugin or best solution for this scenario?

    • This topic was modified 4 years, 1 month ago by Jan Dembowski. Reason: Moved to Fixing WordPress, this is not an Everything else WordPress topic
Viewing 1 replies (of 1 total)
  • Moderator bcworkz

    (@bcworkz)

    4 years, 1 month ago

    You only need to store the user ID in the other DB as meta data for the WP user. There are a number of custom field plugins that would let you add a field to the user profile for the purpose. However, querying the other DB for a user by the stored ID or to get a list of yet unassigned users probably requires some custom coding.

    If you can manage that coding, you can likely manage the custom profile field without using another plugin, though by adding custom code you would likely be creating your own plugin for the purpose.

Viewing 1 replies (of 1 total)
  • The topic ‘Relate WP user to existing DB user’ is closed to new replies.