Php – Should I keep using the normal thesql_query or switch to PDO interface in php

PHP

I'm building a big website, and using the normal old mysql_query method for transactions and communications with the database, and everything i going fine, including security. I'm a little bit confused, should I switch to the new PDO interface? cause I learnt that's safer, or keep using the old mysql_query() and mysql_fetch_assoc() methods?

I'm very close to completing the website, and to switch to the PDO interface will cost me time, to start updating my codes.

I'm a little confused, which should I use and what are the pros and cons?

Best Answer

I'm a little confused, which should i use

No doubt if you just go through this link you will see a notice. So you should get switched to PDO or MySQLi.

Cons and Pros :

There are many posts available on stackoverflow on this subject. They all talk about PDO and why use it.

And many more here. Finally I would recommend you to switch to PDO or mysqli as mysql will be removed as per the link. Even if you have considered the security issues and secured you app, whats the use when it is completely lost? You need to do it later time somehow, So do it now itself. Hope this helps.

Related Topic