Hello,
I am ditching my own DB abstraction class in favour of MDB2.
When I need to do a sinlge INSERT, should I use MDB2_Driver_Common->prepare
like this..
$prep = $this->mdb2->prepare('INSERT INTO test (test_id, name) values
(?,?)', $types);
$result = $this->mdb2->executeParams($prep, $types, $data);
OR should I simply use MDB2_Driver_Common->query($sql)..
$res = $this->mdb2->query($sql);
where the $sql contains the pre-formatted INSERT statement? What I really
want to know is - does the prepare method offer any compatibility advantage
(escaping depending on types?),
or is it just for speeding up multiple inserts i.e. prepare once, execute
many. The docs explain how, but not always why. Inserts don't happen very
often in my apps so compatibility accross multiple dbs is more important to
me than speed. Finally, is this the right place to ask questions about MDB2,
or is there a more specific group for discussing Pear projects?
Thanks a lot.
Michael.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
