Accessing the database using JDatabase: Difference between revisions
From Joomla! Documentation
Add notes on J4 support |
This document is not orpahned by is part of the developers' documentation. Not sure why it was in the orphan section. |
||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
{{review|}} | |||
<noinclude><languages /></noinclude> | <noinclude><languages /></noinclude> | ||
<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> | ||
| Line 64: | Line 65: | ||
* PHP Data Objects is a database abstraction layer and is shipped with PHP 5.1+.</translate> | * PHP Data Objects is a database abstraction layer and is shipped with PHP 5.1+.</translate> | ||
<noinclude | <noinclude> | ||
[[Category:Database]] | [[Category:Database{{#translation:}}]] | ||
</noinclude> | |||
Latest revision as of 08:17, 17 October 2020
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.
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.
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 (In and higher only via the PDO library for postgres)
|
| 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+.