Interview question
What is the difference between MySQLi and PDO in PHP? PHP में MySQLi और PDO में क्या अंतर है?
Answer
Both are database extensions for connecting PHP to databases, but they differ in scope and features.
| Feature | MySQLi | PDO |
|---|---|---|
| Database support | MySQL only | 12+ databases (MySQL, PostgreSQL, SQLite, etc.) |
| API style | Procedural and OOP | OOP only |
| Prepared statements | Yes, but more verbose | Yes, cleaner named parameters |
| Named parameters | No | Yes (e.g. :name) |
PDO is generally preferred for new projects due to database portability and cleaner syntax.
दोनों PHP को database से connect करने के extensions हैं, पर scope और features में अंतर है।
| Feature | MySQLi | PDO |
|---|---|---|
| Database support | सिर्फ MySQL | 12+ databases |
| API style | Procedural और OOP | सिर्फ OOP |
| Named parameters | नहीं | हाँ (जैसे :name) |
नए projects के लिए PDO ज़्यादा पसंद किया जाता है क्योंकि यह database-portable और cleaner है।
Was this answer clear?