MDB2: Anything else I should do with my connection?

[Jesdisciple]

Currently I have this sequence working; should I add/change any thing? (I'm picking up bits and pieces of the Getting Started guide that no one has compiled yet.)

[mark]

The disconnect() call is optional, as PHP will close the connection to the database anyway. But could consider it more clean to close the connection yourself.

Depending on what you're really doing in the query() call, you might want to consider using the prepare/execute feature, as explained here:
http://pear.php.net/manual/en/package.database.mdb2.intro-execute.php
http://pear.php.net/manual/en/package.database.mdb2.intro-auto.php

[Jesdisciple]

For the full source and API of that file, see http://code.google.com/p/error-logger/source/browse/trunk/error-logger.xml, http://code.google.com/p/error-logger/source/browse/trunk/xml.php, and http://code.google.com/p/error-logger/source/browse/trunk/prune.php.

Would there be any advantage to using prepare in this case (probably by changing my %-enclosed placeholders to ?s)?

[mark]

Sorry, I'm too lazy tonight to have a deeper look into your code. prepare() and execute() are interesting if you're using queries multiple times (i.e. same query but different values).

This feature might look a little bit weird at first, but once you've understood the concept, it's really nice and handy (of course, only if the usage makes sense; see above).

[Jesdisciple]

Woops, I thought you were suggesting that I should present the full source.

I was uncertain whether I should alter my code because I had a similar system established, except I used named placeholders exclusively and I prepared my statements once per query. (The purpose of the system was primarily to store my queries in XML, so I hadn't considered a prepare-execute setup.)

But I'm trying it; if I run into too much trouble I'll just go back in SVN.

Thanks!