Actions

Difference between revisions of "Accessing the database using JDatabase"

From Joomla! Documentation

(Advanced information: Close bracket)
(added joomla db)
Line 17: Line 17:
 
! scope="col" | Database  
 
! scope="col" | Database  
 
! scope="col" | Joomla Versions
 
! scope="col" | Joomla Versions
 +
! scope="col" | Joomla DB
 
|-
 
|-
| MySQL || {{JVer|1.5}}{{JVer|2.5}}{{JVer|3.0}}
+
| MySQL || {{JVer|1.5}}{{JVer|2.5}}{{JVer|3.0}} || Yes
 
|-
 
|-
| Microsoft SQL Server || {{JVer|2.5}}{{JVer|3.0}}
+
| Microsoft SQL Server || {{JVer|2.5}}{{JVer|3.0}} || Yes
 
|-
 
|-
| Microsoft SQL Azure || {{JVer|2.5}}{{JVer|3.0}}
+
| Microsoft SQL Azure || {{JVer|2.5}}{{JVer|3.0}} || Yes
 
|-
 
|-
| Postgresql || {{JVer|3.0}}
+
| Postgresql || {{JVer|3.0}} || Yes
 
|-
 
|-
| Oracle DB || {{JVer|3.0}}
+
| Oracle DB || {{JVer|3.0}} || No
 
|-
 
|-
| SQL Lite || {{JVer|3.0}}
+
| SQL Lite || {{JVer|3.0}} || No
 
|-
 
|-
| PHP Data Objects (PDO)* || {{JVer|3.0}}
+
| PHP Data Objects (PDO)* || {{JVer|3.0}} || No
 
|}
 
|}
  
 
* PHP Data Objects is a database abstraction layer and is shipped with PHP 5.1+.
 
* PHP Data Objects is a database abstraction layer and is shipped with PHP 5.1+.

Revision as of 03:42, 28 October 2013

Useful information

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

Advanced information

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

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