J4.x:Selecting data using JDatabase/fr - Revision history

FuzzyBot: Updating to match new version of source page

2022-08-19T18:38:42Z

Updating to match new version of source page

← Older revision		Revision as of 18:38, 19 August 2022
Line 446:		Line 446:
	Array ( [0] => johnsmith@domain.example, [1] => magda_h@domain.example, [2] => ydg@domain.example ),		Array ( [0] => johnsmith@domain.example, [1] => magda_h@domain.example, [2] => ydg@domain.example ),
	Array ( [0] => johnsmith, [1] => magdah, [2] => ydegaulle )</pre>		Array ( [0] => johnsmith, [1] => magdah, [2] => ydegaulle )</pre>
	~~</pre>~~

	Notes:		Notes:

Lorangerart at 12:56, 25 February 2022

2022-02-25T12:56:44Z

← Older revision		Revision as of 12:56, 25 February 2022
Line 20:		Line 20:
	Le chaînage de requêtes fait référence à une méthode permettant la connexion à un certain nombre de méthodes, les unes après les autres où chaque méthode retournant un objet peut prendre en charge la nouvelle méthode, améliorant ainsi la lisibilité et la simplification du code.		Le chaînage de requêtes fait référence à une méthode permettant la connexion à un certain nombre de méthodes, les unes après les autres où chaque méthode retournant un objet peut prendre en charge la nouvelle méthode, améliorant ainsi la lisibilité et la simplification du code.

	Pour obtenir une nouvelle instance de la classe \DatabaseQuery, nous utilisons la méthode \Joomla\Database\DatabaseDriver getQuery :		Pour obtenir une nouvelle instance de la classe \Joomla\Database\DatabaseQuery, nous utilisons la méthode \Joomla\Database\DatabaseDriver getQuery :

	<source lang="php">		<source lang="php">

Lorangerart at 12:56, 25 February 2022

2022-02-25T12:56:22Z

← Older revision		Revision as of 12:56, 25 February 2022
Line 20:		Line 20:
	Le chaînage de requêtes fait référence à une méthode permettant la connexion à un certain nombre de méthodes, les unes après les autres où chaque méthode retournant un objet peut prendre en charge la nouvelle méthode, améliorant ainsi la lisibilité et la simplification du code.		Le chaînage de requêtes fait référence à une méthode permettant la connexion à un certain nombre de méthodes, les unes après les autres où chaque méthode retournant un objet peut prendre en charge la nouvelle méthode, améliorant ainsi la lisibilité et la simplification du code.

	~~<div class="mw-translate-fuzzy">~~		Pour obtenir une nouvelle instance de la classe \DatabaseQuery, nous utilisons la méthode \Joomla\Database\DatabaseDriver getQuery :
	Pour obtenir une nouvelle instance de la classe ~~<tt>JDatabaseQuery</tt>~~, nous utilisons la méthode ~~<tt>JDatabaseDriver~~ getQuery~~</tt>~~ :
	~~</div>~~

	<source lang="php">		<source lang="php">

FuzzyBot: Updating to match new version of source page

2021-01-27T11:15:24Z

Updating to match new version of source page

← Older revision		Revision as of 11:15, 27 January 2021
Line 620:		Line 620:
	===Voir également===		===Voir également===
	*[[S:MyLanguage/J4.x:Inserting, Updating and Removing data using JDatabase\|Insertion, mise à Jour et suppression de données à l'aide de JDatabase]]		*[[S:MyLanguage/J4.x:Inserting, Updating and Removing data using JDatabase\|Insertion, mise à Jour et suppression de données à l'aide de JDatabase]]
			*[[S:MyLanguage/J4.x:Moving_Joomla_To_Prepared_Statements\|Moving Joomla To Prepared Statements]]
	*[[S:MyLanguage/Using the union methods in database queries\|Utiliser les méthodes UNION dans les requêtes de base de données]] (Joomla! 3.3+)		*[[S:MyLanguage/Using the union methods in database queries\|Utiliser les méthodes UNION dans les requêtes de base de données]] (Joomla! 3.3+)
			*[https://php.net/manual/en/pdo.prepared-statements.php The PHP Manual on Prepared statements]
	*[https://api.joomla.org/framework-1/classes/Joomla.Database.DatabaseQuery.html <span class="mw-translate-fuzzy">Joomla CMS 3.8 API</span>]		*[https://api.joomla.org/framework-1/classes/Joomla.Database.DatabaseQuery.html <span class="mw-translate-fuzzy">Joomla CMS 3.8 API</span>]

FuzzyBot: Updating to match new version of source page

2020-04-05T18:59:05Z

Updating to match new version of source page

Show changes

FuzzyBot: Updating to match new version of source page

2020-04-01T15:16:28Z

Updating to match new version of source page

@@ Line 93: / Line 93: @@
      ->setLimit('10');
 </source>
 ==Sélectionner des enregistrements dans plusieurs tables==
@@ Line 172: / Line 171: @@
 </source>
 ==Résultats de la requête==
@@ Line 217: / Line 296: @@
 $result = $db->loadResult();
 </source>
 ===Single Row Results ===

FuzzyBot: Updating to match new version of source page

2019-05-31T12:03:56Z

Updating to match new version of source page

← Older revision		Revision as of 12:03, 31 May 2019
Line 48:		Line 48:
	// Select all records from the user profile table where key begins with "custom.".		// Select all records from the user profile table where key begins with "custom.".
	// Order it by the ordering field.		// Order it by the ordering field.
	$query->select($db->quoteName(~~array(~~'user_id', 'profile_key', 'profile_value', 'ordering')));		$query->select($db->quoteName(['user_id', 'profile_key', 'profile_value', 'ordering']));
	$query->from($db->quoteName('#__user_profiles'));		$query->from($db->quoteName('#__user_profiles'));
	$query->where($db->quoteName('profile_key') . ' LIKE :profile_key');		$query->where($db->quoteName('profile_key') . ' LIKE :profile_key');
	$query->order('ordering ASC');		$query->order($db->quoteName('ordering') . ' ASC');

	// bind value for prepared statements		// bind value for prepared statements
	$query->bind('profile_key', 'custom.%');		$query->bind(':profile_key', 'custom.%');

	// Reset the query using our newly populated query object.		// Reset the query using our newly populated query object.
Line 67:		Line 67:
	<source lang="php">		<source lang="php">
	$query		$query
	->select($db->quoteName(~~array(~~'user_id', 'profile_key', 'profile_value', 'ordering')))		->select($db->quoteName(['user_id', 'profile_key', 'profile_value', 'ordering']))
	->from($db->quoteName('#__user_profiles'))		->from($db->quoteName('#__user_profiles'))
	->where($db->quoteName('profile_key') . ' LIKE :profile_key')		->where($db->quoteName('profile_key') . ' LIKE :profile_key')
	->order('ordering ASC');		->order($db->quoteName('ordering') . ' ASC')
			->bind(':profile_key', 'custom.%');
	~~// bind value~~
	~~$query~~->bind('profile_key', 'custom.%');
	</source>		</source>

Line 82:		Line 80:
	<source lang="php">		<source lang="php">
	$query		$query
	->select( ~~array(~~'catid', 'COUNT(*)') )		->select( ['catid', 'COUNT(*)'] )
	->from($db->quoteName('#__content'))		->from($db->quoteName('#__content'))
	->group($db->quoteName('catid'));		->group($db->quoteName('catid'));
Line 91:		Line 89:
	<source lang="php">		<source lang="php">
	$query		$query
	->select($db->quoteName(~~array(~~'user_id', 'profile_key', 'profile_value', 'ordering')))		->select($db->quoteName(['user_id', 'profile_key', 'profile_value', 'ordering']))
	->from($db->quoteName('#__user_profiles'))		->from($db->quoteName('#__user_profiles'))
	->setLimit('10');		->setLimit('10');
	</source>		</source>


	==Sélectionner des enregistrements dans plusieurs tables==		==Sélectionner des enregistrements dans plusieurs tables==
Line 110:		Line 109:
	// Note by putting 'a' as a second parameter will generate `#__content` AS `a`		// Note by putting 'a' as a second parameter will generate `#__content` AS `a`
	$query		$query
	->select(~~array(~~'a.*', 'b.username', 'b.name'))		->select(['a.*', 'b.username', 'b.name'])
	->from($db->quoteName('#__content', 'a'))		->from($db->quoteName('#__content', 'a'))
	->join('INNER', $db->quoteName('#__users', 'b') . ' ON (' . $db->quoteName('a.created_by') . ' = ' . $db->quoteName('b.id') . ')')		->join('INNER', $db->quoteName('#__users', 'b') . ' ON (' . $db->quoteName('a.created_by') . ' = ' . $db->quoteName('b.id') . ')')
	->where($db->quoteName('b.username') . ' LIKE ~~\'a%\'~~')		->where($db->quoteName('b.username') . ' LIKE :username')
	->order($db->quoteName('a.created') . ' DESC');		->order($db->quoteName('a.created') . ' DESC')
			->bind(':username', 'a%');

	// Reset the query using our newly populated query object.		// Reset the query using our newly populated query object.
Line 138:		Line 138:
	->join('LEFT', $db->quoteName('#__user_profiles', 'c') . ' ON (' . $db->quoteName('b.id') . ' = ' . $db->quoteName('c.user_id') . ')')		->join('LEFT', $db->quoteName('#__user_profiles', 'c') . ' ON (' . $db->quoteName('b.id') . ' = ' . $db->quoteName('c.user_id') . ')')
	->join('RIGHT', $db->quoteName('#__categories', 'd') . ' ON (' . $db->quoteName('a.catid') . ' = ' . $db->quoteName('d.id') . ')')		->join('RIGHT', $db->quoteName('#__categories', 'd') . ' ON (' . $db->quoteName('a.catid') . ' = ' . $db->quoteName('d.id') . ')')
	->where($db->quoteName('b.username') . ' LIKE ~~\'a%\'~~')		->where($db->quoteName('b.username') . ' LIKE :username')
	->order($db->quoteName('a.created') . ' DESC');		->order($db->quoteName('a.created') . ' DESC')
			->bind(':username', 'a%');
	</source>		</source>

Line 153:		Line 154:
	->from($db->quoteName('#__content', 'a'))		->from($db->quoteName('#__content', 'a'))
	->join('INNER', $db->quoteName('#__users', 'b') . ' ON (' . $db->quoteName('a.created_by') . ' = ' . $db->quoteName('b.id') . ')')		->join('INNER', $db->quoteName('#__users', 'b') . ' ON (' . $db->quoteName('a.created_by') . ' = ' . $db->quoteName('b.id') . ')')
	->where($db->quoteName('b.username') . ' LIKE ~~\'a%\'~~')		->where($db->quoteName('b.username') . ' LIKE :username')
	->order($db->quoteName('a.created') . ' DESC');		->order($db->quoteName('a.created') . ' DESC')
			->bind(':username', 'a%');
	</source>		</source>

Line 161:		Line 163:
	<source lang="php">		<source lang="php">
	$query		$query
	->select(~~array(~~'a.*'))		->select(['a.*'])
	->select($db->quoteName(array('b.username', 'b.name'), ~~array(~~'username', 'name')))		->select($db->quoteName(array('b.username', 'b.name'), ['username', 'name']))
	->from($db->quoteName('#__content', 'a'))		->from($db->quoteName('#__content', 'a'))
	->join('INNER', $db->quoteName('#__users', 'b') . ' ON (' . $db->quoteName('a.created_by') . ' = ' . $db->quoteName('b.id') . ')')		->join('INNER', $db->quoteName('#__users', 'b') . ' ON (' . $db->quoteName('a.created_by') . ' = ' . $db->quoteName('b.id') . ')')
	->where($db->quoteName('b.username') . ' LIKE ~~\'a%\'~~')		->where($db->quoteName('b.username') . ' LIKE :username')
	->order($db->quoteName('a.created') . ' DESC');		->order($db->quoteName('a.created') . ' DESC')
			->bind(':username', 'a%');
	</source>		</source>

Line 209:		Line 212:
	$query->from($db->quoteName('#__my_table'));		$query->from($db->quoteName('#__my_table'));
	$query->where($db->quoteName('some_name')." = :value");		$query->where($db->quoteName('some_name')." = :value");
	$query->bind('value', $some_value);		$query->bind(':value', $some_value);

	$db->setQuery($query);		$db->setQuery($query);
Line 342:		Line 345:
	$db->setQuery($query);		$db->setQuery($query);
	for ( $i = 0; $i <= 2; $i++ ) {		for ( $i = 0; $i <= 2; $i++ ) {
	$column= $db->loadColumn($i);		$column = $db->loadColumn($i);
	print_r($column);		print_r($column);
	}		}

Sandra97: Created page with "Utiliser les méthodes UNION dans les requêtes de base de données"

2018-08-12T15:38:41Z

Created page with "Utiliser les méthodes UNION dans les requêtes de base de données"

← Older revision		Revision as of 15:38, 12 August 2018
Line 522:		Line 522:

	===Voir également===		===Voir également===
	*[[S:MyLanguage/Inserting, Updating and Removing data using JDatabase\|~~Inserting~~, ~~Updating and Removing data using~~ JDatabase]]		*[[S:MyLanguage/Inserting, Updating and Removing data using JDatabase\|Insertion, mise à Jour et suppression de données à l'aide de JDatabase]]
	*[[S:MyLanguage/Using the union methods in database queries\|~~Using the union methods in database queries~~]] (Joomla! 3.3+)		*[[S:MyLanguage/Using the union methods in database queries\|Utiliser les méthodes UNION dans les requêtes de base de données]] (Joomla! 3.3+)
	*[https://api.joomla.org/cms-3/classes/JDatabaseQuery.html Joomla CMS 3.8 API]		*[https://api.joomla.org/cms-3/classes/JDatabaseQuery.html Joomla CMS 3.8 API]

Sandra97: Created page with "===Voir également==="

2018-08-12T15:38:32Z

Created page with "===Voir également==="

← Older revision		Revision as of 15:38, 12 August 2018
Line 521:		Line 521:
	in libraries\joomla\database\database\mysql.php on line 344</pre>		in libraries\joomla\database\database\mysql.php on line 344</pre>

	=== ~~See also~~ ===		===Voir également===
	*[[S:MyLanguage/Inserting, Updating and Removing data using JDatabase\|Inserting, Updating and Removing data using JDatabase]]		*[[S:MyLanguage/Inserting, Updating and Removing data using JDatabase\|Inserting, Updating and Removing data using JDatabase]]
	*[[S:MyLanguage/Using the union methods in database queries\|Using the union methods in database queries]] (Joomla! 3.3+)		*[[S:MyLanguage/Using the union methods in database queries\|Using the union methods in database queries]] (Joomla! 3.3+)

Sandra97: Created page with "=== Valeur unique de résultat ==="

2018-08-12T15:23:31Z

Created page with "=== Valeur unique de résultat ==="

← Older revision		Revision as of 15:23, 12 August 2018
Line 171:		Line 171:

	==Résultats de la requête==		==Résultats de la requête==
	~~The~~ database ~~class contains many methods for working with a query~~'~~s result set~~.		La classe <tt>database</tt> proposent différentes méthodes pour pouvoir travailler avec un ensemble de résultats d'une requête.

	=== ~~Single Value Result~~ ===		=== Valeur unique de résultat ===
	==== loadResult() ====		==== loadResult() ====
	Use '''loadResult()''' when you expect just a single value back from your database query.		Use '''loadResult()''' when you expect just a single value back from your database query.