Difference between revisions of "Accessing the database using JDatabase"
From Joomla! Documentation
(added joomla db) |
m (added Category:Database using HotCat) |
||
(4 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
{{version/tutor|2.5,3.1}} | {{version/tutor|2.5,3.1}} | ||
==Useful information== | ==Useful information== | ||
− | Being able to use JDatabase is vital when you start developing for Joomla | + | 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]]. | * [[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. | + | * [[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== | ==Advanced information== | ||
− | This tutorial looks at how to transactions with JDatabase (available since {{JVer|3.x}} only): | + | This tutorial looks at how to use transactions with JDatabase (available since {{JVer|3.x}} only): |
* [[Using transactions in Joomla]] | * [[Using transactions in Joomla]] | ||
+ | |||
+ | This tutorial looks at how to use the union methods in JDatabaseQuery (available in working form since {{JVer|3.3}} only): | ||
+ | * [[Using the union methods in database queries]] | ||
==Supported Storage Connectors== | ==Supported Storage Connectors== | ||
Line 35: | Line 38: | ||
* 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+. | ||
+ | |||
+ | [[Category:Database]] |
Revision as of 03:13, 11 May 2014
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):
This tutorial looks at how to use the union methods in JDatabaseQuery (available in working form 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+.