List of users in PHP - upgrade from Joomla 4 to 5 Topic is solved

[alanyeom]

Hi, in Joomla 4 I used the following code to generate a list of users that I then processed in a foreach() loop:

$config =& JFactory::getConfig();

$db =& JFactory::getDBO();
$query = "SELECT * FROM #__users" ;
$db->setQuery($query);
$obj = $db->loadObjectList();

foreach ($obj as $u) {

It no longer works in Joomla 5, and the Joomla manual doesn't help me with this step, only with user handling once I am inside the foreach() loop. How do I do this in Joomla 5?

[pe7er]

Welcome to Joomla forum!

If you haven't seen the new Joomla manual yet, it has a lot of info about Joomla 5 code:
https://manual.joomla.org/docs/next/

You can rewrite the code using name spacing:

Code: Select all

use Joomla\CMS\Factory;

$config = Factory::getConfig();

$db = Factory::getContainer()->get('DatabaseDriver');
$query->select('*')->from($db->quoteName('#__users'));
$db->setQuery($query);
$obj = $db->loadObjectList();

foreach ($obj as $u) {

[alanyeom]

Thanks, that worked fine after I declared the $query object. Consider the question answered!

[pe7er]

You're welcome! Great!