Which is the best function to exchange data with mysql?

Until now I used mysql_ functions but recenlty heard something about mysqli_ functions which is supposed to be an improved versions of the previous and also saw an object oriented approached introduced in PHP 5, what's the best? Even if the object oriented approach is too complicated is it worth it to go at least to mysqli?

re: Which is the best function to exchange data with mysql?

OOP is another issue (search for OOP on bytes in the last few days, you'll get to know all about it, don't want to start another thread on OOP).

Yes mysqli or PDO functions are better than the normal mysql function.

You won't notice a difference if it's a small app. We like PDO because of it's fetchAll() function that mysql_*() do not have.

Good luck,



Dan

re: Which is the best function to exchange data with mysql?

@OP: Note PDO is a library (also OO) - not native functions like mysqli_* and mysql_*.

re: Which is the best function to exchange data with mysql?

another note: MySQLi can be used as functions (like mysql_*) or as classes (like PDO)