Db quote: Difference between revisions From Online Manual

Jump to: navigation, search
(Created page with "{{smcfunc |function=db_quote |usage=$smcFunc['db_quote'] (query, values, connection) |description=Works similar to how db_query works, but it does not execute the query. Form...")
 
No edit summary
Line 18: Line 18:


<noinclude>
<noinclude>
[[Category:Database Functions]]
[[Category:Database Functions]]</noinclude>
[[Category:2.0]]
[[Category:Customizing SMF]]
[[Category:Developing SMF]]</noinclude>

Revision as of 21:51, 8 October 2012

Usage:

$smcFunc['db_quote'] (query, values, connection)


Description: Works similar to how db_query works, but it does not execute the query. Formats as if it where going to be and returns the string. It can be used to prepare parts of query to be used later on.

Parameters:

  • query the query (or part of it) to be formatted
  • values is an array of values you are intending to use in the query.
  • connection the database connection to be used.

Return: a string representing the formatted query.

Example:

$realNameMatches[] = $smcFunc['db_quote'](
	'{string:possible_user}',
	array(
		'possible_user' => $possible_user
	)
);



Advertisement: