User:Emanuele/smctemplate test: Difference between revisions From Online Manual

Jump to: navigation, search
(Created page with "{{:User:Emanuele/smctemplate |usage=$smcFunc['db_query'] (identifier, query, values, connection) |description=Works Similar to how db_query worked in 1.x versions |parameters= *'...")
 
No edit summary
Line 1: Line 1:
{{:User:Emanuele/smctemplate
{{:User:Emanuele/smctemplate
|function=db_query
|usage=$smcFunc['db_query'] (identifier, query, values, connection)
|usage=$smcFunc['db_query'] (identifier, query, values, connection)
|description=Works Similar to how db_query worked in 1.x versions
|description=Works Similar to how db_query worked in 1.x versions

Revision as of 20:35, 12 April 2011

db_query

Usage:

$smcFunc['db_query'] (identifier, query, values, connection)

Description: Works Similar to how db_query worked in 1.x versions

Parameters:

  • identifier - is used for identifying specific queries that will be handled specially.
  • query - is the actual query
  • values - array of values...etc. (optional if no values used in the query)
  • connection - database connection (optional)

Return: a query resource or false on error.

Example:

$result = $smcFunc['db_query'](, '
                SELECT poster_time
                FROM {db_prefix}messages
                WHERE id_msg = {int:id_msg}
                LIMIT 1',
                array(
                    'id_msg' => $user_settings['id_msg_last_visit'],
                )
            );



Advertisement: