>Correct me if I'm wrong, but doesn't "doing it the right way" involve changing >all your PHP "mysql*" library calls to "mysqli*"? > You know, that's an interesting topic for conversation.
I'm totally sold on PEAR DB, and haven't made a call to a native PHP database function in the last few applications I've built. By using PEAR DB, switching from the mysql to mysqli library is a one-character change in my application's config file. I saw some stuff in the PHP manual user-comments about compatibility in PHP5 between mysql and mysqli (mainly that it's a pain to get both going simultaneously), and although I didn't think about it at the time, I'm spared a huge migration headache should I decide to port this stuff down the road -- that's a huge bonus. We run Postgres at my current day gig, and our DBA is *not* going to consider switching. I'm still maintaining a lot of MySQL stuff that I've built over the years as a consultant, and PEAR DB saves me from having to keep the two database libraries (in addition to the SQL syntax variances) straight in my head. The thing I really love about Pear DB -- and it's pretty trivial -- is that I can do: $arrResult = $objDB->getAll($sql); I get an array containing all of the result rows, in whatever format I specify. (Ordered/Associative Array,Object,etc) It only saves me a couple lines of code, but they're lines of code that I probably typed 1000 times, and never have to type again. That being said, the mysqli libraries definitely offer a more robust administrative featureset -- ping, kill, info, sqlstate, etc. If I was working on PHPMyAdmin, I'd definitely be using mysqli. If I was working on yet another CMS system, I'd probably lean towards the convenience of PEAR DB. PEAR DB does support the transactional features, and the other functionality like triggers and stored procedures don't change anything for the client. I really never get feedback when I comment on PEAR DB -- I'm really curious to know what other people think about it, or if anyone's using it. I know a lot of you guys use the native calls, and I have to get them memorized again for the Zend Certification Exam, and I'm wondering if there are advantages I'm overlooking. -Jeromie ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/CefplB/TM --------------------------------------------------------------------~-> The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
