database transactions and prepared statements

[Ransy72560]

I apologize in advance if there is documentation on this - I can't find it. If it is available and someone has a link handy, I'd appreciate it.

I have some php code that was originally written to communicate with the database through the PEAR MDB2 module, and I'm porting it into a vBulletin product. I have run into a couple of questions/issues with the way vBulletin interacts with the db:

1) My code currently makes use of database transactions (I need to rollback if any part of the transaction fails). Does vBulletin provide support for this? If not, is there some recommended way I can hack it? For instance, manually initiate a transaction with $db->query("START TRANSACTION;"); ? I'm not sure I like that idea because it seems db-specific, but may be the only option I suppose.

2) My code also makes use of prepared statements because a single transaction has the potential to make a substantial number of inserts into the database. For performance reasons I would like to continue using them. Does vBulletin provide support for this functionality?

Thank you in advance!

[Dismounted]

vBulletin (in its current form) only uses the MySQL/MySQLi functions, and not PDO. Mainly because the current architecture was coded ages ago. My guess is that vBulletin 4 will most likely use PDO.

[Marco van Herwaarden]

The default engine vBulletin uses is MyIsam. MyIsam does not support transactions.

If you are adding your own tables, then you can use 1 of the other database engines supported by MySQL that do support transactions.

[Ransy72560]

Sorry, I should have specified that I am creating InnoDB tables, so that's not a problem.

I guess I will try to execute commands directly against MySQL. I was hoping there was a more generic system in place though. Thanks for the replies.

[Carnage]

If i'm correct, you can use $db->query() to do any valid mysql query. I've always assumed as much anyway...

[Dismounted]

Originally Posted by Carnage-

If i'm correct, you can use $db->query() to do any valid mysql query. I've always assumed as much anyway...

Yes, that is true, but also note that $db->query() is deprecated and has been replaced by $db->mysql_read() and $db->mysql_write().

[MoT3rror]

Originally Posted by Dismounted

Yes, that is true, but also note that $db->query() is deprecated and has been replaced by $db->mysql_read() and $db->mysql_write().

I think you mean $db->query_read and $db->query_first for read queries.
$db->query_write is used for write queries.

[Dismounted]

Originally Posted by MoT3rror

I think you mean $db->query_read and $db->query_first

Yep, my bad.