Selecting data using JDatabase/zh-cn - Revision history

FuzzyBot: Updating to match new version of source page

2021-02-25T23:05:20Z

Updating to match new version of source page

← Older revision		Revision as of 23:05, 25 February 2021
Line 200:		Line 200:
	==查询结果 ==		==查询结果 ==
	数据库类包含许多处理查询结果集的方法。		数据库类包含许多处理查询结果集的方法。

			If there are no matches to the query, the result will be null.

	=== 单值的结果 ===		=== 单值的结果 ===

FuzzyBot: Updating to match new version of source page

2020-03-31T14:10:24Z

Updating to match new version of source page

@@ Line 167: / Line 167: @@
 </source>
 ==查询结果 ==
@@ Line 212: / Line 242: @@
 $result = $db->loadResult();
 </source>
 ===单行结果 ===

FuzzyBot: Updating to match new version of source page

2019-10-19T07:57:58Z

Updating to match new version of source page

Show changes

FuzzyBot: Updating to match new version of source page

2019-05-31T17:20:46Z

Updating to match new version of source page

Guozhanfeng: Created page with "在数据库查询中使用union方法"

2018-03-31T07:01:12Z

Created page with "在数据库查询中使用union方法"

← Older revision		Revision as of 07:01, 31 March 2018
Line 514:		Line 514:
	=== 另请参阅 ===		=== 另请参阅 ===
	*[[S:MyLanguage/Inserting, Updating and Removing data using JDatabase\|使用JDatabase插入、更新和删除数据。]]		*[[S:MyLanguage/Inserting, Updating and Removing data using JDatabase\|使用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\|在数据库查询中使用union方法]] (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]

Guozhanfeng: Created page with "使用JDatabase插入、更新和删除数据。"

2018-03-31T07:01:04Z

Created page with "使用JDatabase插入、更新和删除数据。"

← Older revision		Revision as of 07:01, 31 March 2018
Line 513:		Line 513:

	=== 另请参阅 ===		=== 另请参阅 ===
	*[[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\|使用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+)
	*[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]

Guozhanfeng: Created page with "=== 另请参阅 ==="

2018-03-31T07:01:00Z

Created page with "=== 另请参阅 ==="

← Older revision		Revision as of 07:01, 31 March 2018
Line 512:		Line 512:
	in libraries\joomla\database\database\mysql.php on line 344</pre>		in libraries\joomla\database\database\mysql.php on line 344</pre>

	=== ~~See also~~ ===		=== 另请参阅 ===
	*[[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+)

Guozhanfeng: Created page with "注意: getNumRows() 只对选择或显示返回实际结果集的语句有效 getNumRows() after loadRowList() - 或者任何其他的检索方法——您将得到一个PHP..."

2018-03-31T07:00:51Z

Created page with "注意: getNumRows() 只对选择或显示返回实际结果集的语句有效 getNumRows() after loadRowList() - 或者任何其他的检索方法——您将得到一个PHP..."

← Older revision		Revision as of 07:00, 31 March 2018
Line 508:		Line 508:

	将返回 <pre>3</pre>		将返回 <pre>3</pre>
	~~Note~~: getNumRows() ~~is only valid for statements like SELECT or SHOW that return an actual result set. If you run~~ getNumRows() after loadRowList() - ~~or any other retrieval method - you will get a PHP Warning~~:		注意: getNumRows() 只对选择或显示返回实际结果集的语句有效 getNumRows() after loadRowList() - 或者任何其他的检索方法——您将得到一个PHP警告:
	<pre>Warning: mysql_num_rows(): 80 is not a valid MySQL result resource		<pre>Warning: mysql_num_rows(): 80 is not a valid MySQL result resource
	in libraries\joomla\database\database\mysql.php on line 344</pre>		in libraries\joomla\database\database\mysql.php on line 344</pre>

Guozhanfeng: Created page with "将返回"

2018-03-31T07:00:17Z

Created page with "将返回"

← Older revision		Revision as of 07:00, 31 March 2018
Line 507:		Line 507:
	</source>		</source>

	~~will return~~ <pre>3</pre>		将返回 <pre>3</pre>
	Note: getNumRows() is only valid for statements like SELECT or SHOW that return an actual result set. If you run getNumRows() after loadRowList() - or any other retrieval method - you will get a PHP Warning:		Note: getNumRows() is only valid for statements like SELECT or SHOW that return an actual result set. If you run getNumRows() after loadRowList() - or any other retrieval method - you will get a PHP Warning:
	<pre>Warning: mysql_num_rows(): 80 is not a valid MySQL result resource		<pre>Warning: mysql_num_rows(): 80 is not a valid MySQL result resource

Guozhanfeng: Created page with "`getNumRows()` 将返回最后一个SELECT或SHOW查询所发现的结果行数，并等待读取。得到结果 getNumRows() 你必须运行 '''after''' 查询和 '''b..."

2018-03-31T07:00:06Z

Created page with "<tt>getNumRows()</tt> 将返回最后一个SELECT或SHOW查询所发现的结果行数，并等待读取。得到结果 getNumRows() 你必须运行 '''after''' 查询和 '''b..."

← Older revision		Revision as of 07:00, 31 March 2018
Line 496:		Line 496:
	=== 其他结果集方法 ===		=== 其他结果集方法 ===
	==== getNumRows() ====		==== getNumRows() ====
	<tt>getNumRows()</tt> ~~will return the number of result rows found by the last SELECT or SHOW query and waiting to be read. To get a result from~~ getNumRows() ~~you have to run it~~ '''after''' ~~the query and~~ '''before''' ~~you have retrieved any results. To retrieve the number of rows affected by a~~ INSERT, UPDATE, REPLACE or DELETE ~~query~~, ~~use getAffectedRows~~().		<tt>getNumRows()</tt> 将返回最后一个SELECT或SHOW查询所发现的结果行数，并等待读取。得到结果 getNumRows() 你必须运行 '''after''' 查询和 '''before''' 您已经检索到任何结果。检索受影响的行数 INSERT, UPDATE, REPLACE 或 DELETE 查询,使用getAffectedRows().

	<source lang='php'>		<source lang='php'>

← Older revision		Revision as of 17:20, 31 May 2019
Line 106:		Line 106:
	->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 ' . $db->quote('a%'))
	->order($db->quoteName('a.created') . ' DESC');		->order($db->quoteName('a.created') . ' DESC');

Line 131:		Line 131:
	->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 ' . $db->quote('a%'))
	->order($db->quoteName('a.created') . ' DESC');		->order($db->quoteName('a.created') . ' DESC');
	</source>		</source>
Line 146:		Line 146:
	->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 ' . $db->quote('a%'))
	->order($db->quoteName('a.created') . ' DESC');		->order($db->quoteName('a.created') . ' DESC');
	</source>		</source>
Line 158:		Line 158:
	->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 ' . $db->quote('a%'))
	->order($db->quoteName('a.created') . ' DESC');		->order($db->quoteName('a.created') . ' DESC');
	</source>		</source>

Selecting data using JDatabase/zh-cn - Revision history

FuzzyBot: Updating to match new version of source page

FuzzyBot: Updating to match new version of source page

FuzzyBot: Updating to match new version of source page

FuzzyBot: Updating to match new version of source page

Guozhanfeng: Created page with "在数据库查询中使用union方法"

Guozhanfeng: Created page with "使用JDatabase插入、更新和删除数据。"

Guozhanfeng: Created page with "=== 另请参阅 ==="

Guozhanfeng: Created page with "注意: getNumRows() 只对选择或显示返回实际结果集的语句有效 getNumRows() after loadRowList() - 或者任何其他的检索方法——您将得到一个PHP..."

Guozhanfeng: Created page with "将返回"

Guozhanfeng: Created page with "getNumRows() 将返回最后一个SELECT或SHOW查询所发现的结果行数，并等待读取。得到结果 getNumRows() 你必须运行 '''after''' 查询和 '''b..."

Guozhanfeng: Created page with "`getNumRows()` 将返回最后一个SELECT或SHOW查询所发现的结果行数，并等待读取。得到结果 getNumRows() 你必须运行 '''after''' 查询和 '''b..."