what is the best mysql class?

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
cardi777
Forum Commoner
Posts: 54
Joined: Sun Mar 29, 2009 4:26 am

what is the best mysql class?

Post 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
User avatar
requinix
Spammer :|
Posts: 6617
Joined: Wed Oct 15, 2008 2:35 am
Location: WA, USA

Re: what is the best mysql class?

Post 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.
cardi777
Forum Commoner
Posts: 54
Joined: Sun Mar 29, 2009 4:26 am

Re: what is the best mysql class?

Post 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
rueben.w
Forum Newbie
Posts: 2
Joined: Thu Jul 23, 2009 4:44 am

Re: what is the best mysql class?

Post 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/
Post Reply