mysql, mysqli, or mysqlpdo connection?
Posted: Thu Jul 17, 2008 1:18 pm
I'm working my way through PHP Solutions by David Powers and we are now beginning the database section. There are three ways to connect, using the mysql, mysql improved, or mysql pdo connection. I know it will depend on your host. I'm with Hostgator so anything I build for myself or my clients will be using a current PHP version, 5.025 as of now I believe. My work's host is all the way back to 4.3. So, my only option with them is mysql (or does the improved version cover 4.3 as well?). No problem. I don't plan on doing a whole lotta developing for them. But, for me, which do I go with?
The book's author says that the push is for PDO. If what he says is true and everyone will eventually be using PDO then I should be studying the PDO tutorials and not worrying about the mysql/i tutorials. But, I don't know if everyone is really pushing towards PDO? Since the two connection types seem to be drastically different I don't wanna waste my time learning something that isn't what everyone else is doing.
Any insight?
The book's author says that the push is for PDO. If what he says is true and everyone will eventually be using PDO then I should be studying the PDO tutorials and not worrying about the mysql/i tutorials. But, I don't know if everyone is really pushing towards PDO? Since the two connection types seem to be drastically different I don't wanna waste my time learning something that isn't what everyone else is doing.
Any insight?