Selecting data using JDatabase - Revision history

Robbiej: Added deprecation notice and link to Joomla Manual

2024-11-27T10:37:15Z

Added deprecation notice and link to Joomla Manual

← Older revision		Revision as of 10:37, 27 November 2024
Line 1:		Line 1:
			{{Warning\|This page has been superseded and is no longer maintained. Please go to [https://manual.joomla.org/docs/general-concepts/database/ Joomla Manual ] instead}}

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

Cmb: Corrected some URLs. Other formatting changes.

2022-09-23T21:35:56Z

Corrected some URLs. Other formatting changes.

Show changes

M-b-o: Marked this version for translation

2021-02-25T23:03:15Z

Marked this version for translation

← Older revision		Revision as of 23:03, 25 February 2021
Line 243:		Line 243:
	The database class contains many methods for working with a query's result set.		The database class contains many methods for working with a query's result set.

			<!--T:145-->
	If there are no matches to the query, the result will be null.		If there are no matches to the query, the result will be null.
	</translate>		</translate>

AndyGaskell: typo

2021-02-25T11:29:57Z

typo

← Older revision		Revision as of 11:29, 25 February 2021
Line 243:		Line 243:
	The database class contains many methods for working with a query's result set.		The database class contains many methods for working with a query's result set.

	If there are no matches to the ~~quesry~~, the result will be null.		If there are no matches to the query, the result will be null.
	</translate>		</translate>

AndyGaskell: note on empty results being null

2021-02-25T11:29:26Z

note on empty results being null

← Older revision		Revision as of 11:29, 25 February 2021
Line 241:		Line 241:
	</translate>		</translate>
	<translate><!--T:31-->		<translate><!--T:31-->
	The database class contains many methods for working with a query's result set.</translate>		The database class contains many methods for working with a query's result set.

			If there are no matches to the quesry, the result will be null.
			</translate>

	<translate>		<translate>

MartijnM: Marked this version for translation

2020-03-31T14:10:03Z

Marked this version for translation

← Older revision		Revision as of 14:10, 31 March 2020
Line 199:		Line 199:

	<translate>		<translate>
	==Using OR in queries== </translate>		==Using OR in queries== <!--T:140--> </translate>
	<translate>		<translate>
			<!--T:141-->
	When using multiple WHERE clauses in your query, they will be treated as an AND.		When using multiple WHERE clauses in your query, they will be treated as an AND.

			<!--T:142-->
	So, for example, the query below will return results where the 'name' field AND the 'state' field match.</translate>		So, for example, the query below will return results where the 'name' field AND the 'state' field match.</translate>
	<source lang="php">		<source lang="php">
Line 213:		Line 215:
	</source>		</source>
	<translate>		<translate>
			<!--T:143-->
	To use a WHERE clause as an OR, the query can be written like this</translate>		To use a WHERE clause as an OR, the query can be written like this</translate>
	<source lang="php">		<source lang="php">
Line 223:		Line 226:
	</source>		</source>
	<translate>		<translate>
			<!--T:144-->
	it can also be written like this</translate>		it can also be written like this</translate>
	<source lang="php">		<source lang="php">

MartijnM at 14:09, 31 March 2020

2020-03-31T14:09:05Z

← Older revision		Revision as of 14:09, 31 March 2020
Line 199:		Line 199:

	<translate>		<translate>
			==Using OR in queries== </translate>
			<translate>
	==Using OR in queries== <~~!--T:24--~~>
	When using multiple WHERE clauses in your query, they will be treated as an AND.		When using multiple WHERE clauses in your query, they will be treated as an AND.

	So, for example, the query below will return results where the 'name' field AND the 'state' field match.		So, for example, the query below will return results where the 'name' field AND the 'state' field match.</translate>
	<source lang="php">		<source lang="php">
	$query = $db		$query = $db
Line 213:		Line 212:
	->where($db->quoteName('state') . " = " . $db->quote($state));		->where($db->quoteName('state') . " = " . $db->quote($state));
	</source>		</source>
			<translate>
	To use a WHERE clause as an OR, the query can be written like this		To use a WHERE clause as an OR, the query can be written like this</translate>
	<source lang="php">		<source lang="php">
	$query = $db		$query = $db
Line 223:		Line 222:
	->where($db->quoteName('name') . " = " . $db->quote($name_two));		->where($db->quoteName('name') . " = " . $db->quote($name_two));
	</source>		</source>
	it can also be written like this		<translate>
			it can also be written like this</translate>
	<source lang="php">		<source lang="php">
	$query = $db		$query = $db
Line 233:		Line 233:
	</source>		</source>

			<translate>
	==Query Results == <!--T:30-->		==Query Results == <!--T:30-->
	</translate>		</translate>
Line 296:		Line 296:

	<translate>		<translate>

	===Single Row Results === <!--T:43-->		===Single Row Results === <!--T:43-->
	</translate>		</translate>

AndyGaskell: typo in example

2020-02-27T12:20:22Z

typo in example

← Older revision		Revision as of 12:20, 27 February 2020
Line 220:		Line 220:
	->select('COUNT(*)')		->select('COUNT(*)')
	->from($db->quoteName('#__my_table'))		->from($db->quoteName('#__my_table'))
	->where($db->quoteName('name') . " = " . $db->quote($name_one)', 'OR')		->where($db->quoteName('name') . " = " . $db->quote($name_one), 'OR')
	->where($db->quoteName('name') . " = " . $db->quote($name_two));		->where($db->quoteName('name') . " = " . $db->quote($name_two));
	</source>		</source>

AndyGaskell: adding OR clause info

2020-02-27T12:18:38Z

adding OR clause info

← Older revision		Revision as of 12:18, 27 February 2020
Line 199:		Line 199:

	<translate>		<translate>


			==Using OR in queries== <!--T:24-->
			When using multiple WHERE clauses in your query, they will be treated as an AND.

			So, for example, the query below will return results where the 'name' field AND the 'state' field match.
			<source lang="php">
			$query = $db
			->getQuery(true)
			->select('COUNT(*)')
			->from($db->quoteName('#__my_table'))
			->where($db->quoteName('name') . " = " . $db->quote($value)
			->where($db->quoteName('state') . " = " . $db->quote($state));
			</source>

			To use a WHERE clause as an OR, the query can be written like this
			<source lang="php">
			$query = $db
			->getQuery(true)
			->select('COUNT(*)')
			->from($db->quoteName('#__my_table'))
			->where($db->quoteName('name') . " = " . $db->quote($name_one)', 'OR')
			->where($db->quoteName('name') . " = " . $db->quote($name_two));
			</source>
			it can also be written like this
			<source lang="php">
			$query = $db
			->getQuery(true)
			->select('COUNT(*)')
			->from($db->quoteName('#__my_table'))
			->where($db->quoteName('name') . " = " . $db->quote($name_one)
			->orWhere($db->quoteName('name') . " = " . $db->quote($name_two));
			</source>


	==Query Results == <!--T:30-->		==Query Results == <!--T:30-->

Mickmackusa: implemented the chained syntax recommended earlier on the same page, added spaces around concatenating dots

2019-10-19T06:30:29Z

implemented the chained syntax recommended earlier on the same page, added spaces around concatenating dots

← Older revision		Revision as of 06:30, 19 October 2019
Line 237:		Line 237:
	<source lang="php">		<source lang="php">
	$db = JFactory::getDbo();		$db = JFactory::getDbo();
	$query = $db->getQuery(true);		$query = $db
	~~$query~~->select('COUNT(*)');		->getQuery(true)
	~~$query~~->from($db->quoteName('#__my_table'));		->select('COUNT(*)')
	~~$query~~->where($db->quoteName('name')." = ".$db->quote($value));		->from($db->quoteName('#__my_table'))
			->where($db->quoteName('name') . " = " . $db->quote($value));

	// Reset the query using our newly populated query object.		// Reset the query using our newly populated query object.
Line 250:		Line 251:
	<source lang='php'>		<source lang='php'>
	$db = JFactory::getDbo();		$db = JFactory::getDbo();
	$query = $db->getQuery(true);		$query = $db
	~~$query~~->select('field_name');		->getQuery(true)
	~~$query~~->from($db->quoteName('#__my_table'));		->select('field_name')
	~~$query~~->where($db->quoteName('some_name')." = ".$db->quote($some_value));		->from($db->quoteName('#__my_table'))
			->where($db->quoteName('some_name') . " = " . $db->quote($some_value));

	$db->setQuery($query);		$db->setQuery($query);