Joomla and MySQL

Question

Is there specific documentation available on Joomla regarding making database queries via MySQL in PHP?

What I'm really looking for:

• Whether or not Joomla has it's own database wrapper implemented, and if not, is it recommended to create one using the specified config parameters.
• Whether or not Joomla has the capability to parameterize their queries to prevent SQL injection.

Answer 1

Yes, Joomla has it's own OOP defined to deal with databases.

Usually, you will deal with code like this:

$db =& JFactory::getDBO();

$query = "SELECT * FROM #__example_table WHERE id = 999999;";
$db->setQuery($query);

Can read more here: How to use the database classes in your script