Question: why pdo is better than mysqli?
Answer: The core advantage of PDO over MySQLi is in its database driver support. At the time of this writing, PDO supports 12 different drivers, opposed to MySQLi, which supports MySQL only. ... Well, in situations when you have to switch your project to use another database, PDO makes the process transparent.