I am really new to using database commands under joomla structure so I hope I am not annoying anyone.
I need to get the user id of 4 members to use later in the script.
Here is what I have tried. It works ok, but seems alot of code to get the job done. Is there a better way to access this information?
Code: Select all
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select($db->quoteName(array('id', 'username')));
$query->from($db->quoteName('#__users'));
$query->where($db->quoteName('username') . ' LIKE '. $db->quote($row['r_1']));
$db->setQuery($query);
$results1 = $db->loadObjectList();
foreach ($results1 AS $result1) {
echo $result1->id." email ".$result1->username;
}
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select($db->quoteName(array('id', 'username')));
$query->from($db->quoteName('#__users'));
$query->where($db->quoteName('username') . ' LIKE '. $db->quote($row['r_2']));
$db->setQuery($query);
$results2 = $db->loadObjectList();
foreach ($results2 AS $result2) {
echo "<br>".$result2->id." email ".$result2->username;
}
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select($db->quoteName(array('id', 'username')));
$query->from($db->quoteName('#__users'));
$query->where($db->quoteName('username') . ' LIKE '. $db->quote($row['r_3']));
$db->setQuery($query);
$results3 = $db->loadObjectList();
foreach ($results3 AS $result3) {
echo "<br>".$result3->id." email ".$result3->username;
}
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select($db->quoteName(array('id', 'username')));
$query->from($db->quoteName('#__users'));
$query->where($db->quoteName('username') . ' LIKE '. $db->quote($row['r_4']));
$db->setQuery($query);
$results4 = $db->loadObjectList();
foreach ($results4 AS $result4) {
echo "<br>".$result4->id." email ".$result4->username;
}
exit;