Accessing the database using JDatabase: Difference between revisions
From Joomla! Documentation
No edit summary |
Add notes on J4 support |
||
| Line 39: | Line 39: | ||
Joomla DB</translate> | Joomla DB</translate> | ||
|- | |- | ||
| MySQL || {{JVer|1.5}}{{JVer|2.5}}{{JVer|3.0}} || <translate><!--T:15--> | | MySQL || {{JVer|1.5}}{{JVer|2.5}}{{JVer|3.0}}{{JVer|4.0}} || <translate><!--T:15--> | ||
Yes</translate> | Yes</translate> | ||
|- | |- | ||
| Line 48: | Line 48: | ||
Yes</translate> | Yes</translate> | ||
|- | |- | ||
| Postgresql || {{JVer|3.0}} || <translate><!--T:18--> | | Postgresql || {{JVer|3.0}}{{JVer|4.0}} || <translate><!--T:18--> | ||
Yes</translate> | Yes (In {{JVer|4.0}} and higher only via the PDO library for postgres)</translate> | ||
|- | |- | ||
| Oracle DB || {{JVer|3.0}} || <translate><!--T:19--> | | Oracle DB || {{JVer|3.0}} || <translate><!--T:19--> | ||
No</translate> | No</translate> | ||
|- | |- | ||
| SQL Lite || {{JVer|3.0}} || <translate><!--T:20--> | | SQL Lite || {{JVer|3.0}}{{JVer|4.0}} || <translate><!--T:20--> | ||
No</translate> | No</translate> | ||
|- | |- | ||
| PHP Data Objects (PDO)* || {{JVer|3.0}} || <translate><!--T:21--> | | PHP Data Objects (PDO)* || {{JVer|3.0}}{{JVer|4.0}} || <translate><!--T:21--> | ||
No</translate> | No</translate> | ||
|} | |} | ||
Revision as of 00:32, 5 April 2020
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.
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+.