Accessing the database using JDatabase
From Joomla! Documentation
(Redirected from J2.5:Accessing the database using JDatabase)
The "J2.5" namespace is a namespace scheduled to be archived. This page contains information for a Joomla! version which is no longer supported. It exists only as a historical reference, it will not be improved and its content may be incomplete and/or contain broken links.
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.
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|
|Microsoft SQL Server||Yes|
|Microsoft SQL Azure||Yes|
|PHP Data Objects (PDO)*||No|
- PHP Data Objects is a database abstraction layer and is shipped with PHP 5.1+.