Accessing the database using JDatabase - Revision history

Jennymac: This document is not orpahned by is part of the developers' documentation. Not sure why it was in the orphan section.

2020-10-17T08:17:35Z

This document is not orpahned by is part of the developers' documentation. Not sure why it was in the orphan section.

← Older revision		Revision as of 08:17, 17 October 2020
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>

M-b-o at 18:55, 5 April 2020

2020-04-05T18:55:47Z

← Older revision		Revision as of 18:55, 5 April 2020
Line 64:		Line 64:
	* 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~~><translate><!--T:23--~~>		<noinclude>
	[[Category:Database]]~~</translate>~~</noinclude>		[[Category:Database{{#translation:}}]]
			</noinclude>

Wilsonge: Add notes on J4 support

2020-04-05T00:32:25Z

Add notes on J4 support

← Older revision		Revision as of 00:32, 5 April 2020
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>
	\|}		\|}

MATsxm at 13:33, 16 September 2015

2015-09-16T13:33:57Z

← Older revision		Revision as of 13:33, 16 September 2015
Line 9:		Line 9:
	* [[S:MyLanguage/Inserting, Updating and Removing data using JDatabase\|Inserting, updating and removing data from the database]].</translate>		* [[S:MyLanguage/Inserting, Updating and Removing data using JDatabase\|Inserting, updating and removing data from the database]].</translate>
	<translate><!--T:4-->		<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~~. 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~~.</translate>		* [[S:MyLanguage/Selecting data using JDatabase\|Selecting data from one or more tables]] and retrieving it in a variety of different forms.</translate>

	<translate>		<translate>

MATsxm: Marked this version for translation

2015-09-08T19:34:06Z

Marked this version for translation

← Older revision		Revision as of 19:34, 8 September 2015
Line 2:		Line 2:
	<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>
	<translate>		<translate>
	==Useful information==		==Useful information== <!--T:1-->
	</translate>		</translate>
	<translate>Being able to use JDatabase is vital when you start developing for Joomla. The tutorial is split into two independent parts:</translate>		<translate><!--T:2-->
	<translate>* [[S:MyLanguage/Inserting, Updating and Removing data using JDatabase\|Inserting, updating and removing data from the database]].</translate>		Being able to use JDatabase is vital when you start developing for Joomla. The tutorial is split into two independent parts:</translate>
	<translate>* [[S:MyLanguage/Selecting data using JDatabase\|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.</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. 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.</translate>

	<translate>		<translate>
	==Advanced information==		==Advanced information== <!--T:5-->
	</translate>		</translate>
	<translate>This tutorial looks at how to use transactions with JDatabase (available since {{JVer\|3.x}} only):</translate>		<translate><!--T:6-->
	<translate>* [[S:MyLanguage/Using transactions in Joomla\|Using transactions in Joomla]]</translate>		This tutorial looks at how to use transactions with JDatabase (available since {{JVer\|3.x}} only):</translate>
	<translate>This tutorial looks at how to use the union methods in JDatabaseQuery (available in working form since {{JVer\|3.3}} only):		<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>		* [[S:MyLanguage/Using the union methods in database queries\|Using the union methods in database queries]]</translate>

	<translate>		<translate>
	==Supported Storage Connectors==		==Supported Storage Connectors== <!--T:9-->
	</translate>		</translate>
	<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>		<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>

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

	<translate>* PHP Data Objects is a database abstraction layer and is shipped with PHP 5.1+.</translate>		<translate><!--T:22-->
			* PHP Data Objects is a database abstraction layer and is shipped with PHP 5.1+.</translate>

	<noinclude><translate>[[Category:Database]]</translate></noinclude>		<noinclude><translate><!--T:23-->
			[[Category:Database]]</translate></noinclude>

MATsxm: Marked for translation

2015-09-08T19:33:57Z

Marked for translation

← Older revision		Revision as of 19:33, 8 September 2015
Line 1:		Line 1:
	{{version~~/tutor~~\|2.5~~,3.x~~}}		<noinclude><languages /></noinclude>
			<noinclude>{{Joomla version\|version=3.x}}{{Joomla version\|version=2.5\|status=eos}}</noinclude>
			<translate>
	==Useful information==		==Useful information==
	Being able to use JDatabase is vital when you start developing for Joomla. The tutorial is split into two independent parts:		</translate>
	* [[Inserting, Updating and Removing data using JDatabase\|Inserting, updating and removing data from the database]].		<translate>Being able to use JDatabase is vital when you start developing for Joomla. The tutorial is split into two independent parts:</translate>
	* [[Selecting data using JDatabase\|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.		<translate>* [[S:MyLanguage/Inserting, Updating and Removing data using JDatabase\|Inserting, updating and removing data from the database]].</translate>
			<translate>* [[S:MyLanguage/Selecting data using JDatabase\|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.</translate>

			<translate>
	==Advanced information==		==Advanced information==
	This tutorial looks at how to use transactions with JDatabase (available since {{JVer\|3.x}} only):		</translate>
	* [[Using transactions in Joomla]]		<translate>This tutorial looks at how to use transactions with JDatabase (available since {{JVer\|3.x}} only):</translate>
			<translate>* [[S:MyLanguage/Using transactions in Joomla\|Using transactions in Joomla]]</translate>
	This tutorial looks at how to use the union methods in JDatabaseQuery (available in working form since {{JVer\|3.3}} only):		<translate>This tutorial looks at how to use the union methods in JDatabaseQuery (available in working form since {{JVer\|3.3}} only):
	* [[Using the union methods in database queries]]		* [[S:MyLanguage/Using the union methods in database queries\|Using the union methods in database queries]]</translate>

			<translate>
	==Supported Storage Connectors==		==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.		</translate>
			<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>

	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>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>Database</translate>
	! scope="col" \| Joomla Versions		! scope="col" \| <translate>Joomla! Versions</translate>
	! scope="col" \| Joomla DB		! scope="col" \| <translate>Joomla DB</translate>
	\|-		\|-
	\| MySQL \|\| {{JVer\|1.5}}{{JVer\|2.5}}{{JVer\|3.0}} \|\| Yes		\| MySQL \|\| {{JVer\|1.5}}{{JVer\|2.5}}{{JVer\|3.0}} \|\| <translate>Yes</translate>
	\|-		\|-
	\| Microsoft SQL Server \|\| {{JVer\|2.5}}{{JVer\|3.0}} \|\| Yes		\| Microsoft SQL Server \|\| {{JVer\|2.5}}{{JVer\|3.0}} \|\| <translate>Yes</translate>
	\|-		\|-
	\| Microsoft SQL Azure \|\| {{JVer\|2.5}}{{JVer\|3.0}} \|\| Yes		\| Microsoft SQL Azure \|\| {{JVer\|2.5}}{{JVer\|3.0}} \|\| <translate>Yes</translate>
	\|-		\|-
	\| Postgresql \|\| {{JVer\|3.0}} \|\| Yes		\| Postgresql \|\| {{JVer\|3.0}} \|\| <translate>Yes</translate>
	\|-		\|-
	\| Oracle DB \|\| {{JVer\|3.0}} \|\| No		\| Oracle DB \|\| {{JVer\|3.0}} \|\| <translate>No</translate>
	\|-		\|-
	\| SQL Lite \|\| {{JVer\|3.0}} \|\| No		\| SQL Lite \|\| {{JVer\|3.0}} \|\| <translate>No</translate>
	\|-		\|-
	\| PHP Data Objects (PDO)* \|\| {{JVer\|3.0}} \|\| No		\| PHP Data Objects (PDO)* \|\| {{JVer\|3.0}} \|\| <translate>No</translate>
	\|}		\|}

	* 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>

	[[Category:Database]]		<noinclude><translate>[[Category:Database]]</translate></noinclude>

Wilsonge: Change version to 3.x for page

2014-09-05T12:26:22Z

Change version to 3.x for page

← Older revision		Revision as of 12:26, 5 September 2014
Line 1:		Line 1:
	{{version/tutor\|2.5,3.1}}		{{version/tutor\|2.5,3.x}}
	==Useful information==		==Useful information==
	Being able to use JDatabase is vital when you start developing for Joomla. The tutorial is split into two independent parts:		Being able to use JDatabase is vital when you start developing for Joomla. The tutorial is split into two independent parts:

Chris Davenport: added Category:Database using HotCat

2014-05-11T08:13:17Z

added Category:Database using HotCat

← Older revision		Revision as of 08:13, 11 May 2014
Line 38:		Line 38:

	* 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+.

			[[Category:Database]]

Chris Davenport: Fixed version 3.3 icon

2014-05-11T08:06:24Z

Fixed version 3.3 icon

← Older revision		Revision as of 08:06, 11 May 2014
Line 9:		Line 9:
	* [[Using transactions in Joomla]]		* [[Using transactions in Joomla]]

	This tutorial looks at how to use the union methods in JDatabaseQuery (available in working form since ((JVer\|3.3}} only):		This tutorial looks at how to use the union methods in JDatabaseQuery (available in working form since {{JVer\|3.3}} only):
	* [[Using the union methods in database queries]]		* [[Using the union methods in database queries]]

Chris Davenport: Added link to new page about the union methods

2014-03-29T12:18:04Z

Added link to new page about the union methods

← Older revision		Revision as of 12:18, 29 March 2014
Line 8:		Line 8:
	This tutorial looks at how to use transactions with JDatabase (available since {{JVer\|3.x}} only):		This tutorial looks at how to use transactions with JDatabase (available since {{JVer\|3.x}} only):
	* [[Using transactions in Joomla]]		* [[Using transactions in Joomla]]

			This tutorial looks at how to use the union methods in JDatabaseQuery (available in working form since ((JVer\|3.3}} only):
			* [[Using the union methods in database queries]]

	==Supported Storage Connectors==		==Supported Storage Connectors==