RE: [PEAR] Problem using PEAR::DB

On 26 Sep 2003 at 16:56, patrick.allaert@belgacom.be wrote: > >-----Original Message----- > >From: Lukas Smith [mailto:smith@backendmedia.com] > >Sent: 26 September 2003 16:46 > >To: 'Dennis Sterzenbach'; 'ML PEAR General PHP.Net' > >Subject: RE: [PEAR] Problem using PEAR::DB > > > > > >> From: Dennis Sterzenbach [mailto:dennis@darknoise.homeip.net] > >> Sent: Friday, September 26, 2003 4:42 PM > > > >> I've got a problem using PEAR::DB. > >> I'm already used to the PEAR database abstraction layer, > >> but never before I stepped that much into detail of > >> MySQL and PEAR. > >> > >> For me there's obviously no problem putting three queries > >> in one SQL string using phpMyAdmin, neither executing it > >> on shell. > >> But if I try to execute a 'simpleQuery($sql)' with an SQL > >> as follows: > >> $sql = "DELETE FROM logins WHERE uid=8; > >> DELETE FROM users_lists WHERE uid=8; > >> DELETE FROM users WHERE uid=8;" > > > >this is called "batch querying" and it is not supported my mysql > >(frontbase and mssql support it though). > > > >Regards, > >Lukas > > Hi, > > It should be nice having a support for "batch querying" in PEAR::DB... > The DB_common should implement a function splitting the queries... and > the specific DB_* (mysql, oci8, sybase,..) should call this splitting > functions if unable to deal with "batch queries". > > What do you think about this suggestion ? Yes, I think it's a nice idea. And if you e.g. have a look at phpMyAdmin that's what the guys over there already did / solved in their PHP sources. So it should be possible to use their experience and port that part of source - and not make the same splitting-errors they maybe had in the past again. Such a generic splitting function (maybe returning an array of queries) would be a nice solution. Stefan