Accessing the database using JDatabase: Difference between revisions

From Joomla! Documentation

← Older edit
Wilsonge (talk | contribs)
Abuse Filter Admins, Bureaucrats, Joomla Leadership, Administrators
4,871 edits
Remove version 1.5 info
Jennymac (talk | contribs)
Email Confirmed, JDOC Contributors
22 edits
This document is not orpahned by is part of the developers' documentation. Not sure why it was in the orphan section.
 
(17 intermediate revisions by 7 users not shown)
Line 1: Line 1:
{{version/tutor|2.5,3.1}}
{{review|}}
==Useful information==
<noinclude><languages /></noinclude>
This tutorial is split into two independent parts:
<noinclude>{{Joomla version|version=3.x}}{{Joomla version|version=2.5|status=eos}}</noinclude>
* [[Inserting, Updating and Removing data using JDatabase|Inserting, updating and removing data from the database]]. It also touches on transactions.
<translate>
* [[Selecting data using JDatabase|Selecting data from one or more tables]] and retrieving it in a variety of different forms
==Useful information== <!--T:1-->
</translate>
<translate><!--T:2-->
Being able to use JDatabase is vital when you start developing for Joomla. The tutorial is split into two independent parts:</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.</translate>


==Supported Storage Connectors==
<translate>
==Advanced information== <!--T:5-->
</translate>
<translate><!--T:6-->
This tutorial looks at how to use transactions with JDatabase (available since {{JVer|3.x}} only):</translate>
<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>


The table below outlines the database and storage connectors available for Joomla! as well as which version of Joomla they became available in.
<translate>
==Supported Storage Connectors== <!--T:9-->
</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>


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><!--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" | Database  
! scope="col" | <translate><!--T:12-->
! scope="col" | Joomla Versions
Database</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}}
| MySQL || {{JVer|1.5}}{{JVer|2.5}}{{JVer|3.0}}{{JVer|4.0}} || <translate><!--T:15-->
Yes</translate>
|-
|-
| Microsoft SQL Server || {{JVer|2.5}}{{JVer|3.0}}
| Microsoft SQL Server || {{JVer|2.5}}{{JVer|3.0}} || <translate><!--T:16-->
Yes</translate>
|-
|-
| Microsoft SQL Azure || {{JVer|2.5}}{{JVer|3.0}}
| Microsoft SQL Azure || {{JVer|2.5}}{{JVer|3.0}} || <translate><!--T:17-->
Yes</translate>
|-
|-
| Postgresql || {{JVer|3.0}}
| Postgresql || {{JVer|3.0}}{{JVer|4.0}} || <translate><!--T:18-->
Yes (In {{JVer|4.0}} and higher only via the PDO library for postgres)</translate>
|-
|-
| Oracle DB || {{JVer|3.0}}
| Oracle DB || {{JVer|3.0}} || <translate><!--T:19-->
No</translate>
|-
|-
| SQL Lite || {{JVer|3.0}}
| SQL Lite || {{JVer|3.0}}{{JVer|4.0}} || <translate><!--T:20-->
No</translate>
|-
|-
| PHP Data Objects (PDO)* || {{JVer|3.0}}
| PHP Data Objects (PDO)* || {{JVer|3.0}}{{JVer|4.0}} || <translate><!--T:21-->
No</translate>
|}
|}


* PHP Data Objects is a database abstraction layer and is shipped with PHP 5.1+.
<translate><!--T:22-->
* PHP Data Objects is a database abstraction layer and is shipped with PHP 5.1+.</translate>
 
<noinclude>
[[Category:Database{{#translation:}}]]
</noinclude>

Latest revision as of 08:17, 17 October 2020

This Article Needs Your Help

This article is tagged because it NEEDS REVIEW. You can help the Joomla! Documentation Wiki by contributing to it.
More pages that need help similar to this one are here. NOTE-If you feel the need is satistified, please remove this notice.


Other languages:
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:

Advanced information

This tutorial looks at how to use transactions with JDatabase (available since Joomla 3.x only):

This tutorial looks at how to use the union methods in JDatabaseQuery (available in working form since Joomla 3.3 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 Joomla 1.5Joomla 2.5Joomla 3.0Joomla 4.0 Yes
Microsoft SQL Server Joomla 2.5Joomla 3.0 Yes
Microsoft SQL Azure Joomla 2.5Joomla 3.0 Yes
Postgresql Joomla 3.0Joomla 4.0 Yes (In Joomla 4.0 and higher only via the PDO library for postgres)
Oracle DB Joomla 3.0 No
SQL Lite Joomla 3.0Joomla 4.0 No
PHP Data Objects (PDO)* Joomla 3.0Joomla 4.0 No
  • 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=756896"