Let Joomla and MySQL interact!

I often need a quick and easy few lines to retrieve some data from MySQL using Joomla without all the MVC nonsense that usually goes about this topic. So here is how I do it! [code lang=”php”] $dbSEL = JFactory::getDbo(); $dbSEL->setQuery(“SELECT MAX(`start_price`) FROM #__some_table”); $dbSEL->query(); echo $dbSEL->fetchRow(); [/code] As you Read more…

By Andrew Odendaal, ago

Perform a Mysql Query using Joomla!

This is really actually meant for future reference for myself as lately I’ve been doing quite a lot of Joomla! mysql coding and have used the following code just short of 3million times. $db = JFactory::getDbo(); $querySelectId = "SELECT `id` FROM #__some_table WHERE `user_id`='$user_id'"; $db->setQuery($querySelectId); $db->query(); $data = $db->loadAssoc(); What Read more…

By Andrew Odendaal, ago

Refresh User Data in Joomla

I was busy with a custom component in Joomla, and it stored it’s own user_details based off of the main users table, but if the details were changed then I needed the system to update the session to reflect the changes. This is what I did: $user = JFactory::getUser(); $session Read more…

By Andrew Odendaal, ago