I have only just discovered some pretty neat mysql classes for php. But what does everyone use? Which one is the best?
I have also noticed various php mailing systems besides phpmailer. Is phpmailer the best?
i am intermediately skilled at php and mysql at best
Cheers,
Doug
what is the best mysql class?
Moderator: General Moderators
Re: what is the best mysql class?
Spoiler: "best" is a matter of opinion.
I haven't found any class that's perfect for databases. It's a hard thing to implement in a simple but powerful way; SQL is, after all, a language, so the perfect class would have to be like a language all by itself.
PDO and MySQLi are pretty good, but I just end up writing my own wrapper class or function every time. One example of why I do: the mysqli classes are nice but they're a little weird handling prepared queries versus plain queries - so I write a generic mysqli_execute_query wrapper function.
Zend_Mail (part of the Zend Framework) seems really nice so far, but you need a fair chunk of the Framework to be able to use it. I haven't used PHPMailer or that other one much so I can't really give a good comparison for those.
I haven't found any class that's perfect for databases. It's a hard thing to implement in a simple but powerful way; SQL is, after all, a language, so the perfect class would have to be like a language all by itself.
PDO and MySQLi are pretty good, but I just end up writing my own wrapper class or function every time. One example of why I do: the mysqli classes are nice but they're a little weird handling prepared queries versus plain queries - so I write a generic mysqli_execute_query wrapper function.
Zend_Mail (part of the Zend Framework) seems really nice so far, but you need a fair chunk of the Framework to be able to use it. I haven't used PHPMailer or that other one much so I can't really give a good comparison for those.
Re: what is the best mysql class?
I had a look at MySQLi. Looks good! Nice and simple by the looks of it.
PDO looks a litte too advanced for my liking.
Another one I found is Ultimate MySQL found here: http://www.phpclasses.org/browse/package/3698.html
Has anyone got experience using this? It looks rather good.
Cheers,
Doug
PDO looks a litte too advanced for my liking.
Another one I found is Ultimate MySQL found here: http://www.phpclasses.org/browse/package/3698.html
Has anyone got experience using this? It looks rather good.
Cheers,
Doug
Re: what is the best mysql class?
A good mysql class, the use of very simple
this is a class that makes it ridiculously easy to use mySQL, Oracle8, SQLite (PHP), within your PHP
http://www.cpworld2000.com/development/ ... ase-class/
this is a class that makes it ridiculously easy to use mySQL, Oracle8, SQLite (PHP), within your PHP
http://www.cpworld2000.com/development/ ... ase-class/