(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> | ||
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');