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: Update links and remove 1.5 link)
Line 1: Line 1:
 
{{version/tutor|1.5,2.5,3.1}}
 
{{version/tutor|1.5,2.5,3.1}}
 
==Useful information==
 
==Useful information==
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]]
+
This tutorial is split into two independent parts:
 
+
* [[Inserting, Updating and Removing data using JDatabase|Inserting, updating and removing data from the database]]. It also touches on transactions.
{{other versions/navbox|The '''{{PAGENAME}}''' Tutorial is available in these versions:-|version}}
+
* [[Selecting data using JDatabase|Selecting data from one or more tables]] and retrieving it in a variety of different forms
  
 
==Supported Storage Connectors==
 
==Supported Storage Connectors==

Revision as of 16:51, 1 September 2013

Useful information[edit]

This tutorial is split into two independent parts:

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 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+.