Accessing the database using JDatabase

From Joomla! Documentation

Revision as of 12:36, 9 September 2013 by Wilsonge (talk | contribs) (Reverted edits by GreyHead (talk) to last revision by Wilsonge)
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Useful information[edit]

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

Advanced information[edit]

This tutorial looks at how to transactions with JDatabase (available since Joomla 3.x only:

Supported Storage Connectors[edit]

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
MySQL Joomla 1.5Joomla 2.5Joomla 3.0
Microsoft SQL Server Joomla 2.5Joomla 3.0
Microsoft SQL Azure Joomla 2.5Joomla 3.0
Postgresql Joomla 3.0
Oracle DB Joomla 3.0
SQL Lite Joomla 3.0
PHP Data Objects (PDO)* Joomla 3.0
  • PHP Data Objects is a database abstraction layer and is shipped with PHP 5.1+.