http://www.codeassembly.com/feed/comments/11 CodeAssembly - Simplicity is prerequisite for reliability - Comments en-us contact@codeassembly.com contact@codeassembly.com RSS Feed Generator Hi, I didn't manage to test it fully, but what happens with the extra fields in your $_POST array when you try to pass it to the insert method? Let's say some assoc keys are not presented in your database table: what happens then? Does it cleaverly skip the extra fileds or it throws an exception? For example your $_POST array contains: Array ( [stat_type_id] => Array ( [0] => 4 [1] => 6 ) [date_from] => 1/2001 [date_to] => 6/2010 [agoto] => statistical_graphics [country_code] => RU [sequence_mode] => m [submit] => (Re) Generate ) But your database record needs only these: [date_from] => 1/2001 [date_to] => 6/2010 [country_code] => RU [sequence_mode] => m Should the DAL skip the other elements from the array? Or we have to take care not to pass them in the $_POST array? http://codeassembly.com/ADODB,-best-php-database-abstraction-class/#347 2010-09-27 16:29:11 http://codeassembly.com/ADODB,-best-php-database-abstraction-class/#347 Why are there selects in the update and insert methods? http://codeassembly.com/ADODB,-best-php-database-abstraction-class/#320 2009-10-07 02:27:54 http://codeassembly.com/ADODB,-best-php-database-abstraction-class/#320 Works perfectly! I was about to write a class to do something like this myself but I thought i'd browse the web first...no sense re-inventing the wheel. Thanks a million. http://codeassembly.com/ADODB,-best-php-database-abstraction-class/#202 2009-02-12 08:43:15 http://codeassembly.com/ADODB,-best-php-database-abstraction-class/#202 How do security sql injection? http://codeassembly.com/ADODB,-best-php-database-abstraction-class/#154 2008-08-21 22:31:57 http://codeassembly.com/ADODB,-best-php-database-abstraction-class/#154 Discovered a possible error: I think that before setting $ADODB_FETCH_MODE in the constructor, you should import the global variable, i.e.: global $ADODB_FETCH_MODE; $ADODB_FETCH_MODE = ADODB_FETCH_ASSOC; Otherwise, it doesn't seem to be truly using ADODB_FETCH_ASSOC, but rather ADODB_FETCH_BOTH. Thanks again for the class. http://codeassembly.com/ADODB,-best-php-database-abstraction-class/#136 2008-06-26 10:37:58 http://codeassembly.com/ADODB,-best-php-database-abstraction-class/#136 Thank you SO much! I have been looking for a way to do this forever. It's even better to have a whole class written already. http://codeassembly.com/ADODB,-best-php-database-abstraction-class/#109 2008-05-03 16:58:49 http://codeassembly.com/ADODB,-best-php-database-abstraction-class/#109 I get an error (cannot access object of type ADODB_mysql as array) on this line: self :: $adodb[$property] = $value; Changed to self :: $adodb->$property = $value; and it works. http://codeassembly.com/ADODB,-best-php-database-abstraction-class/#64 2008-01-08 10:49:33 http://codeassembly.com/ADODB,-best-php-database-abstraction-class/#64