Difference between revisions of "Accessing the database using JDatabase"
From Joomla! Documentation
(Update table as now namespaced. Also added link manually to 2.5 page) |
(→Useful information: Corrected punctuation and added missing space.) |
||
| (10 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | {{version/tutor| | + | {{version/tutor|2.5,3.1}} |
==Useful information== | ==Useful information== | ||
| − | If you are looking for practical information about accessing the database | + | Being able to use JDatabase is vital when you start developing for Joomla. The tutorial is split into two independent parts: |
| + | * [[Inserting, Updating and Removing data using JDatabase|Inserting, updating and removing data from the database]]. | ||
| + | * [[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 in the old 1.5 document, you need to look at this part of the tutorial. | ||
| − | {{ | + | ==Advanced information== |
| + | This tutorial looks at how to use transactions with JDatabase (available since {{JVer|3.x}} only): | ||
| + | * [[Using transactions in Joomla]] | ||
==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 14: | 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}} || Yes |
|- | |- | ||
| − | | Microsoft SQL | + | | Microsoft SQL Azure || {{JVer|2.5}}{{JVer|3.0}} || Yes |
|- | |- | ||
| − | | | + | | 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 18:06, 30 October 2013
This tutorial is for Joomla! CMS Version(s) 
Useful information[edit]
Being able to use JDatabase is vital when you start developing for Joomla. The tutorial is split into two independent parts:
- Inserting, updating and removing data from the database.
- 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 in the old 1.5 document, you need to look at this part of the tutorial.
Advanced information[edit]
This tutorial looks at how to use transactions with JDatabase (available since 
only):
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 | Joomla DB |
|---|---|---|
| MySQL |   |
Yes |
| Microsoft SQL Server | |
Yes |
| Microsoft SQL Azure | |
Yes |
| Postgresql | |
Yes |
| Oracle DB | |
No |
| SQL Lite | |
No |
| PHP Data Objects (PDO)* | |
No |
- PHP Data Objects is a database abstraction layer and is shipped with PHP 5.1+.