mysqli
 

Looking through a lot of the code posted here I noticed most of you use the mysql functions instead of mysqli. Is there a reason for this? Seems like you guys would want to use mysqli because it can be OOP.

I use it because of my familiarity with the mysql functions, I *should* port over to mysqli because of speed or atleast write an add on to my db wrapper but I haven't learned how to use the mysqli extension as of yet and don't really have the time to do so.

I actually just learned about them after picking up Larry Ullman's PHP and MySQL book. Personally I'm not using them yet because, as is probably apparent, I'm new to all of this in general, and they're also not loaded in on my test machine (lazyness is not an acceptable excuse I know, but when you're learning... ).

Trying to load them in right now on my windows system, added the php_mysqli.dll, added libMySQL.dll to the path, and changed all my functions in a class to test it, restarted everything... and... not working. Page tries to load forever, so it's trying to do something because it won't die with an error. Hmmm... oh there it just loaded. Blank. Well then.
-m

Apparently it doesn't matter if I get it running on my local box, my host doesn't have it running either. Those bastards.
-m

Hi
Could you suggest any paper to read about it?
I just heard about it, but never learn mysqli :-/

When I'm making PHP Applications, I usually associate PHP Version, so if it's php 4, then we do the standard MySQL, if it's PHP5, then we do mysqli. I love mysqli cause you can connect everything into one class, and use it as an object:
$sql->query();

The 'i' stands for improved. It's pretty much the same thing as the mysql functions but suppose to be better. I'm not exactly sure what has been improved.

Best place to go for documentation on mysqli is php.net.

If you're running PHP 5, then you'd better see PDO. Or, use an open-source ORM, like Zend_Db or Doctrine, for example.