Accessing the database using JDatabase
From Joomla! Documentation
Revision as of 12:37, 9 September 2013 by Wilsonge (talk | contribs) (→Advanced information: Close bracket)
Revision as of 12:37, 9 September 2013 by Wilsonge (talk | contribs) (→Advanced information: Close bracket)
Useful information[edit]
Being able to use JDatabase is vital when you start developing for Joomla and 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[edit]
This tutorial looks at how to transactions with JDatabase (available since only):
Supported Storage Connectors[edit]
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 |
---|---|
MySQL | |
Microsoft SQL Server | |
Microsoft SQL Azure | |
Postgresql | |
Oracle DB | |
SQL Lite | |
PHP Data Objects (PDO)* |
- PHP Data Objects is a database abstraction layer and is shipped with PHP 5.1+.