Accessing the database using JDatabase: Difference between revisions

From Joomla! Documentation

← Older editNewer edit →
GreyHead (talk | contribs)
78 edits
Re-added link to the really useful information
Wilsonge (talk | contribs)
Abuse Filter Admins, Bureaucrats, Joomla Leadership, Administrators
4,871 edits
m Reverted edits by GreyHead (talk) to last revision by Wilsonge
Line 1: Line 1:
{{version/tutor|1.5,2.5,3.1}}
{{version/tutor|2.5,3.1}}
==Useful information==
==Useful information==
This tutorial is split into two independent parts:
Being able to use JDatabase is vital when you start developing for Joomla and the 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.
* [[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
* [[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]]
==Advanced information==
This tutorial looks at how to 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 18: Line 19:
|-
|-
| 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}}
|-
| Postgresql || {{JVer|3.0}}
|-
|-
| Oracle DB || {{JVer|3.0}}
| Oracle DB || {{JVer|3.0}}

Revision as of 17:36, 9 September 2013

This tutorial is for Joomla! CMS Version(s) Joomla 2.5 Joomla 3.1

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
MySQL Joomla 1.5Joomla 2.5Joomla 3.0
Microsoft SQL Server Joomla 2.5Joomla 3.0
Microsoft SQL Azure Joomla 2.5Joomla 3.0
Postgresql Joomla 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+.
Retrieved from "https://docs.sandbox.joomla.org/index.php?title=Accessing_the_database_using_JDatabase&oldid=103393"