Actions

Difference between revisions of "Accessing the database using JDatabase"

From Joomla! Documentation

(Multiple versions of this tutorial are now available.)
m (Supported Storage Connectors)
(One intermediate revision by the same user not shown)
Line 2: Line 2:
  
 
{{version/tutor|1.5,2.5,3.0}}{{multiversion|The '''{{PAGENAME}}''' Tutorial is available in these versions:-|version|pages=no}}
 
{{version/tutor|1.5,2.5,3.0}}{{multiversion|The '''{{PAGENAME}}''' Tutorial is available in these versions:-|version|pages=no}}
 +
 +
==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).
 +
 +
{| class="wikitable"
 +
! scope="col" | Database
 +
! scope="col" | Joomla Versions
 +
|-
 +
| MySQL || {{JVer|1.5}}{{JVer|2.5}}{{JVer|3.0}}
 +
|-
 +
| Postgresql || {{JVer|3.0}}
 +
|-
 +
| Microsoft SQL Server || {{JVer|2.5}}{{JVer|3.0}}
 +
|-
 +
| Microsoft SQL Azure || {{JVer|2.5}}{{JVer|3.0}}
 +
|-
 +
| Oracle DB || {{JVer|3.0}}
 +
|-
 +
| SQL Lite || {{JVer|3.0}}
 +
|-
 +
| PHP Data Objects (PDO)* || {{JVer|3.0}}
 +
|}
 +
 +
* PHP Data Objects is a database abstraction layer and is shipped with PHP 5.1+.

Revision as of 22:51, 27 October 2012

Quill icon.png
Page Actively Being Edited!

This article is actively undergoing a major edit for a short while.
As a courtesy, please do not edit this page while this message is displayed. The user who added this notice will be listed in the page history. This message is intended to help reduce edit conflicts; please remove it between editing sessions to allow others to edit the page. If this page has not been edited for several hours, please remove this template, or replace it with {{underconstruction}} or {{incomplete}}.

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
MySQL Joomla 1.5Joomla 2.5Joomla 3.0
Postgresql Joomla 3.0
Microsoft SQL Server Joomla 2.5Joomla 3.0
Microsoft SQL Azure Joomla 2.5Joomla 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+.