Page 1 of 1
what is the best mysql class?
Posted: Wed Jul 22, 2009 1:20 am
by cardi777
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
Re: what is the best mysql class?
Posted: Wed Jul 22, 2009 3:19 am
by requinix
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.
Re: what is the best mysql class?
Posted: Wed Jul 22, 2009 7:12 pm
by cardi777
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
Re: what is the best mysql class?
Posted: Thu Jul 23, 2009 5:07 am
by rueben.w
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/