Difference between revisions of "Accessing the database using JDatabase"
From Joomla! Documentation
(Re-added link to the really useful information) |
|||
| Line 1: | Line 1: | ||
| − | {{version/tutor|2.5,3.1}} | + | {{version/tutor|1.5,2.5,3.1}} |
==Useful information== | ==Useful information== | ||
| − | + | This tutorial is split into two independent parts: | |
| − | * [[Inserting, Updating and Removing data using JDatabase|Inserting, updating and removing data from the database]]. | + | * [[Inserting, Updating and Removing data using JDatabase|Inserting, updating and removing data from the database]]. It also touches on transactions. |
* [[Selecting data using JDatabase|Selecting data from one or more tables]] and retrieving it in a variety of different forms | * [[Selecting data using JDatabase|Selecting data from one or more tables]] and retrieving it in a variety of different forms | ||
| − | + | Note: If you are looking for practical information about accessing the database it has been moved to the [[J1.5:Accessing_the_database_using_JDatabase|Joomla! 1.5 page here]] | |
| − | |||
| − | |||
==Supported Storage Connectors== | ==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. | The table below outlines the database and storage connectors available for Joomla! as well as which version of Joomla they became available in. | ||
| Line 19: | Line 18: | ||
|- | |- | ||
| MySQL || {{JVer|1.5}}{{JVer|2.5}}{{JVer|3.0}} | | 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 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}} | ||
| − | |||
| − | |||
|- | |- | ||
| Oracle DB || {{JVer|3.0}} | | Oracle DB || {{JVer|3.0}} | ||
Revision as of 10:04, 9 September 2013
This tutorial is for Joomla! CMS Version(s) 
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
Note: If you are looking for practical information about accessing the database it has been moved to the Joomla! 1.5 page here
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 | 
|
| Postgresql |
|
| Microsoft SQL Server |
|
| Microsoft SQL Azure |
|
| Oracle DB |
|
| SQL Lite |
|
| PHP Data Objects (PDO)* |
|
- PHP Data Objects is a database abstraction layer and is shipped with PHP 5.1+.