What is difference between mysqli and pdo?



What is difference between mysqli and pdo?..

Answer / Prem Shankar Yadav

mysqli (MySQL Improved Extensions) is a native PHP extension for connecting to MySQL databases, while PDO (PHP Data Objects) provides a database abstraction layer in PHP. The main difference lies in PDO's ability to support multiple databases using one consistent API.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

What is the difference between mysql_connect and mysqli_connect?

1 Answers  


How to create table with same structure of student table in mysql?

1 Answers  


What is the use of mysql workbench?

1 Answers  


How do I insert an image into mysql workbench?

1 Answers  


How do I remove a user from mysql?

1 Answers  


how you will Create a database on the mysql server with unix shell.

1 Answers  


What is key in mysql?

1 Answers  


How do I check mysql version?

1 Answers  


How can you export the table as an xml file in mysql?

1 Answers  


How we can see all indexes defined for a table in mysql?

1 Answers  


What is the use of procedure in mysql?

1 Answers  


How to use mysqldump to create a copy of the database?

1 Answers  


Categories