Accessing the database using JDatabase

Useful information

Being able to use JDatabase is vital when you start developing for Joomla. The tutorial is split into two independent parts:

• Inserting, updating and removing data from the database.
• Selecting data from one or more tables and retrieving it in a variety of different forms. Note: If you are looking for practical information about accessing the database in the old 1.5 document, you need to look at this part of the tutorial.

Advanced information

This tutorial looks at how to use transactions with JDatabase (available since only):

• Using transactions in Joomla

This tutorial looks at how to use the union methods in JDatabaseQuery (available in working form since ((JVer|3.3}} only):

• Using the union methods in database queries

Supported Storage Connectors

The table below outlines the database and storage connectors available for Joomla! as well as which version of Joomla they became available in.

To make a connector available in Joomla's installer or global configuration manager, you will need to ensure the PHP library is installed (E.g. for PHP5 and MySQL the php5-mysql library would need to be installed).

Database	Joomla Versions	Joomla DB
MySQL		Yes
Microsoft SQL Server		Yes
Microsoft SQL Azure		Yes
Postgresql		Yes
Oracle DB		No
SQL Lite		No
PHP Data Objects (PDO)*		No

• PHP Data Objects is a database abstraction layer and is shipped with PHP 5.1+.