Accessing the database using JDatabase: Difference between revisions
From Joomla! Documentation
Marked for translation |
Marked this version for translation |
||
| Line 2: | Line 2: | ||
<noinclude>{{Joomla version|version=3.x}}{{Joomla version|version=2.5|status=eos}}</noinclude> | <noinclude>{{Joomla version|version=3.x}}{{Joomla version|version=2.5|status=eos}}</noinclude> | ||
<translate> | <translate> | ||
==Useful information== | ==Useful information== <!--T:1--> | ||
</translate> | </translate> | ||
<translate>Being able to use JDatabase is vital when you start developing for Joomla. The tutorial is split into two independent parts:</translate> | <translate><!--T:2--> | ||
<translate>* [[S:MyLanguage/Inserting, Updating and Removing data using JDatabase|Inserting, updating and removing data from the database]].</translate> | Being able to use JDatabase is vital when you start developing for Joomla. The tutorial is split into two independent parts:</translate> | ||
<translate>* [[S:MyLanguage/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.</translate> | <translate><!--T:3--> | ||
* [[S:MyLanguage/Inserting, Updating and Removing data using JDatabase|Inserting, updating and removing data from the database]].</translate> | |||
<translate><!--T:4--> | |||
* [[S:MyLanguage/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.</translate> | |||
<translate> | <translate> | ||
==Advanced information== | ==Advanced information== <!--T:5--> | ||
</translate> | </translate> | ||
<translate>This tutorial looks at how to use transactions with JDatabase (available since {{JVer|3.x}} only):</translate> | <translate><!--T:6--> | ||
<translate>* [[S:MyLanguage/Using transactions in Joomla|Using transactions in Joomla]]</translate> | This tutorial looks at how to use transactions with JDatabase (available since {{JVer|3.x}} only):</translate> | ||
<translate>This tutorial looks at how to use the union methods in JDatabaseQuery (available in working form since {{JVer|3.3}} only): | <translate><!--T:7--> | ||
* [[S:MyLanguage/Using transactions in Joomla|Using transactions in Joomla]]</translate> | |||
<translate><!--T:8--> | |||
This tutorial looks at how to use the union methods in JDatabaseQuery (available in working form since {{JVer|3.3}} only): | |||
* [[S:MyLanguage/Using the union methods in database queries|Using the union methods in database queries]]</translate> | * [[S:MyLanguage/Using the union methods in database queries|Using the union methods in database queries]]</translate> | ||
<translate> | <translate> | ||
==Supported Storage Connectors== | ==Supported Storage Connectors== <!--T:9--> | ||
</translate> | </translate> | ||
<translate>The table below outlines the database and storage connectors available for Joomla! as well as which version of Joomla they became available in.</translate> | <translate><!--T:10--> | ||
The table below outlines the database and storage connectors available for Joomla! as well as which version of Joomla they became available in.</translate> | |||
<translate>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).</translate> | <translate><!--T:11--> | ||
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).</translate> | |||
{| class="wikitable" | {| class="wikitable" | ||
! scope="col" | <translate>Database</translate> | ! scope="col" | <translate><!--T:12--> | ||
! scope="col" | <translate>Joomla! Versions</translate> | Database</translate> | ||
! scope="col" | <translate>Joomla DB</translate> | ! scope="col" | <translate><!--T:13--> | ||
Joomla! Versions</translate> | |||
! scope="col" | <translate><!--T:14--> | |||
Joomla DB</translate> | |||
|- | |- | ||
| MySQL || {{JVer|1.5}}{{JVer|2.5}}{{JVer|3.0}} || <translate>Yes</translate> | | MySQL || {{JVer|1.5}}{{JVer|2.5}}{{JVer|3.0}} || <translate><!--T:15--> | ||
Yes</translate> | |||
|- | |- | ||
| Microsoft SQL Server || {{JVer|2.5}}{{JVer|3.0}} || <translate>Yes</translate> | | Microsoft SQL Server || {{JVer|2.5}}{{JVer|3.0}} || <translate><!--T:16--> | ||
Yes</translate> | |||
|- | |- | ||
| Microsoft SQL Azure || {{JVer|2.5}}{{JVer|3.0}} || <translate>Yes</translate> | | Microsoft SQL Azure || {{JVer|2.5}}{{JVer|3.0}} || <translate><!--T:17--> | ||
Yes</translate> | |||
|- | |- | ||
| Postgresql || {{JVer|3.0}} || <translate>Yes</translate> | | Postgresql || {{JVer|3.0}} || <translate><!--T:18--> | ||
Yes</translate> | |||
|- | |- | ||
| Oracle DB || {{JVer|3.0}} || <translate>No</translate> | | Oracle DB || {{JVer|3.0}} || <translate><!--T:19--> | ||
No</translate> | |||
|- | |- | ||
| SQL Lite || {{JVer|3.0}} || <translate>No</translate> | | SQL Lite || {{JVer|3.0}} || <translate><!--T:20--> | ||
No</translate> | |||
|- | |- | ||
| PHP Data Objects (PDO)* || {{JVer|3.0}} || <translate>No</translate> | | PHP Data Objects (PDO)* || {{JVer|3.0}} || <translate><!--T:21--> | ||
No</translate> | |||
|} | |} | ||
<translate>* PHP Data Objects is a database abstraction layer and is shipped with PHP 5.1+.</translate> | <translate><!--T:22--> | ||
* PHP Data Objects is a database abstraction layer and is shipped with PHP 5.1+.</translate> | |||
<noinclude><translate>[[Category:Database]]</translate></noinclude> | <noinclude><translate><!--T:23--> | ||
[[Category:Database]]</translate></noinclude> | |||
Revision as of 19:34, 8 September 2015
Joomla!
3.x
Joomla!
2.5
Useful information
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
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
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+.