MySQL Tutorials

Difference between MySQL and MySQLi

difference between MySQL and MySQLi

As we know the mysql_* functions are deprecated in PHP 5.5. So you should not use mysql_* functions in your application. We have better alternative of MySql is MySQL Improved that is MySQLi. In this article I am listing the difference between MySql and MySqli. MySQLi: – The i stands for Improved. The MySQLi extension is designed to work with MySQL version 4.1.13 or newer. MySQLi introduced with PHP 5.0 …

Continue reading

Difference between mysql and pdo


In this post I am discussing the difference between mysql and pdo with example and explanation. So let’s have a look on this. What is PDO? PDO – PHP Data Objects – is a database access layer providing a uniform method of access to multiple databases. PHP PDO => Database Driver => DATABASE Connection to MySQL database: In mysql function we can connect to the database by following code: In …

Continue reading

Mysql functions deprecated in PHP 5.5


As mysql functions are deprecated from PHP 5.5 and above. PHP offers three different APIs to connect to MySQL. These APIs are mysql, mysqli and PDO extensions. The mysql_* functions are very popular, but their use is not encouraged anymore now. PHP developer team is discussed about the database security and has taken the decision to generate E_DEPRECATED errors when users connect to MySQL, whether through mysql_connect(), mysql_pconnect(). When you …

Continue reading