Difference between revisions of "Accessing the database using JDatabase"
From Joomla! Documentation
(→Useful information: Update links and remove 1.5 link) |
(→Supported Storage Connectors: Rearrange order) |
||
Line 16: | Line 16: | ||
|- | |- | ||
| MySQL || {{JVer|1.5}}{{JVer|2.5}}{{JVer|3.0}} | | MySQL || {{JVer|1.5}}{{JVer|2.5}}{{JVer|3.0}} | ||
− | |||
− | |||
|- | |- | ||
| Microsoft SQL Server || {{JVer|2.5}}{{JVer|3.0}} | | Microsoft SQL Server || {{JVer|2.5}}{{JVer|3.0}} | ||
|- | |- | ||
| Microsoft SQL Azure || {{JVer|2.5}}{{JVer|3.0}} | | Microsoft SQL Azure || {{JVer|2.5}}{{JVer|3.0}} | ||
+ | |- | ||
+ | | Postgresql || {{JVer|3.0}} | ||
|- | |- | ||
| Oracle DB || {{JVer|3.0}} | | Oracle DB || {{JVer|3.0}} |
Revision as of 16:52, 1 September 2013
Useful information[edit]
This tutorial is split into two independent parts:
- Inserting, updating and removing data from the database. It also touches on transactions.
- Selecting data from one or more tables and retrieving it in a variety of different forms
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 | |
Microsoft SQL Server | |
Microsoft SQL Azure | |
Postgresql | |
Oracle DB | |
SQL Lite | |
PHP Data Objects (PDO)* |
- PHP Data Objects is a database abstraction layer and is shipped with PHP 5.1+.