MySQL, Mysqli, PDO in a nutshell

MySQL, Mysqli, PDO in a nutshell comparison

1	MySQL extension	(Note: original, poor)
2	MYSQLI extensions (process-oriented)	(Note: More features than above)
3	Mysqli extension (object-oriented)	(Note: More in line with object-oriented thinking than above)
4	Mysqli extension (Object-oriented) (Prepare statement)	(Note: More performance and safety than above)
5	Pdo	(Note: More cross-database portability than above)

It is recommended to use the top priority.

MySQL, Mysqli, PDO in a nutshell