Accessing the database using JDatabase/en: Difference between revisions
From Joomla! Documentation
Importing a new version from external source |
Updating to match new version of source page |
||
| Line 22: | Line 22: | ||
! scope="col" | Joomla DB | ! scope="col" | Joomla DB | ||
|- | |- | ||
| MySQL || {{JVer|1.5}}{{JVer|2.5}}{{JVer|3.0}} || Yes | | MySQL || {{JVer|1.5}}{{JVer|2.5}}{{JVer|3.0}}{{JVer|4.0}} || Yes | ||
|- | |- | ||
| Microsoft SQL Server || {{JVer|2.5}}{{JVer|3.0}} || Yes | | Microsoft SQL Server || {{JVer|2.5}}{{JVer|3.0}} || Yes | ||
| Line 28: | Line 28: | ||
| Microsoft SQL Azure || {{JVer|2.5}}{{JVer|3.0}} || Yes | | Microsoft SQL Azure || {{JVer|2.5}}{{JVer|3.0}} || Yes | ||
|- | |- | ||
| Postgresql || {{JVer|3.0}} || Yes | | Postgresql || {{JVer|3.0}}{{JVer|4.0}} || Yes (In {{JVer|4.0}} and higher only via the PDO library for postgres) | ||
|- | |- | ||
| Oracle DB || {{JVer|3.0}} || No | | Oracle DB || {{JVer|3.0}} || No | ||
|- | |- | ||
| SQL Lite || {{JVer|3.0}} || No | | SQL Lite || {{JVer|3.0}}{{JVer|4.0}} || No | ||
|- | |- | ||
| PHP Data Objects (PDO)* || {{JVer|3.0}} || No | | PHP Data Objects (PDO)* || {{JVer|3.0}}{{JVer|4.0}} || No | ||
|} | |} | ||
* 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+. | ||
<noinclude>[[Category:Database]]</noinclude> | <noinclude> | ||
[[Category:Database{{#translation:}}]] | |||
</noinclude> | |||
Revision as of 18:56, 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+.