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={{...")
 
No edit summary
Line 27: Line 27:


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

Revision as of 21:53, 8 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: