- Posts: 25
- Thank you received: 0
Recover Id Joomla user in EB
- ROSSINELLI
- Topic Author
- Offline
- Junior Member
-
Less
More
11 years 4 months ago #53000
by ROSSINELLI
Recover Id Joomla user in EB was created by ROSSINELLI
How to recover in a field EB ID or username of a joomla user ?
thank you
thank you
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
-
11 years 4 months ago #53009
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Recover Id Joomla user in EB
Hi
In EB, the ID of Joomla user is stored in user_id column of #__eb_registrants table. So you will need to write a SQL join query to get ID of the registrant. Below is sample code :
Hope this helps
Tuan
In EB, the ID of Joomla user is stored in user_id column of #__eb_registrants table. So you will need to write a SQL join query to get ID of the registrant. Below is sample code :
Code:
$registrantId = 10;
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('a.username')
->from('#__users AS a')
->innerJoin('#__eb_registrants AS b ON a.id = b.user_id')
->where('b.id = '. $registrantId);
$db->setQuery($query);
$username = $db->loadResult();
Hope this helps
Tuan
Please Log in or Create an account to join the conversation.
Moderators: Tuan Pham Ngoc
Support
Documentation
Information
Copyright © 2026 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.