What is PDO and the reasons to prefer it over MySQLi

1.	What is PDO and the reasons to prefer it over MySQLi
Answer» PDO is PHP Data Objects. PDO will WORK on 12 different database SYSTEMS, whereas MySQLi will only work with MySQL databases. So, if you have to switch your project to use another database, PDO MAKES the process easy. You only have to change the CONNECTION string and a few queries. With MySQLi, you will need to rewrite the entire code - queries included.

Answer»

PDO is PHP Data Objects.

PDO will WORK on 12 different database SYSTEMS, whereas MySQLi will only work with MySQL databases.

So, if you have to switch your project to use another database, PDO MAKES the process easy. You only have to change the CONNECTION string and a few queries. With MySQLi, you will need to rewrite the entire code - queries included.

Discussion

No Comment Found

Related InterviewSolutions

What are Roles in MySQL and briefly explain any three
What's the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN?
What are MySQL aliases
Creating a table with query
How to change the data type of requireDate field in query
What is a routine and how is it created
What is datatype set
What is character set in MySQL. What is the default character set in MySQL
What is a storage engine.How to prevent the use of a particular storage engine?
What is PDO and the reasons to prefer it over MySQLi

What is PDO and the reasons to prefer it over MySQLi

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment