Accessing the database using JDatabase: Difference between revisions
From Joomla! Documentation
No edit summary |
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 15:04, 9 September 2013
This tutorial is for Joomla! CMS Version(s) 
Useful information
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
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+.