Db transaction: Difference between revisions From Online Manual

Jump to: navigation, search
(Created page with "{{smcfunc |function=db_transaction |usage=$smcFunc['db_transaction'] (type, connection) |description=Same as calling queries for "BEGIN", "ROLLBACK", and "COMMIT". |parameters={{...")
 
m (refresh SMW properties)
 
(2 intermediate revisions by one other user not shown)
Line 1: Line 1:
{{smcfunc
{{smcfunc
|function=db_transaction
|function=db_transaction
|internal=true
|usage=$smcFunc['db_transaction'] (type, connection)
|usage=$smcFunc['db_transaction'] (type, connection)
|description=Same as calling queries for "BEGIN", "ROLLBACK", and "COMMIT".
|description=Same as calling queries for "BEGIN", "ROLLBACK", and "COMMIT".
Line 25: Line 26:
$smcFunc['db_transaction']('commit');</nowiki>
$smcFunc['db_transaction']('commit');</nowiki>
}}
}}
<noinclude>
<noinclude>
[[Category:Database Functions]]
[[Category:Database Functions]]</noinclude>
[[Category:2.0]]
[[Category:Customizing SMF]]
[[Category:Developing SMF]]</noinclude>

Latest revision as of 16:43, 11 October 2012

Usage:

$smcFunc['db_transaction'] (type, connection)


Description: Same as calling queries for "BEGIN", "ROLLBACK", and "COMMIT".

Parameters:

  • type A string defining the type of transaction. It can be one of the following: begin, rollback or commit. Default is commit.
  • connection the database connection.

Return: true on success, false on error.

Example:

$smcFunc['db_transaction']('begin');

// Do the table and indexes...
$smcFunc['db_query']('', $table_query,
	array(
		'security_override' => true,
	)
);
foreach ($index_queries as $query)
	$smcFunc['db_query']('', $query,
	array(
		'security_override' => true,
	)
);

$smcFunc['db_transaction']('commit');



Advertisement: