JDatabase: using the Joomla database with exampleshttps://joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

27 January 2013 admittedly is cleaner and more organized. Here is a query which shows the building methods: // Get a db connection. $db = JFactory::getDbo(); // Create a new query object. $query = $db->getQuery(true); // build the SQL query...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Joomla Component: Set default params on installationhttps://joellipman.com/articles/cms/joomla/joomla-component-set-default-params-on-installation.html

24 October 2013 { function postflight($type, $parent) { // $type (install, update or discover_install) if ($type == 'install') { $db = JFactory::getDBO(); $query = $db->getQuery(true); $query->update($db->quoteName('#__extensions')); $defaults =...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

UTF8 Unicode PHP MySQL for International Charactershttps://joellipman.com/articles/web-development/php/utf8-unicode-php-mysql-for-international-characters.html

22 October 2010 the mysql Joomla! classes, here's how I've used in this script pulling IDs and titles from the a sample table: $db =& JFactory::getDBO(); $sql_utf8 = "set names 'utf8'"; $db->setQuery( $sql_utf8 ); $temp_result = $db->query(); $sql = 'SELECT...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB