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

pdo-versus-mysql




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

mysql-functions-deprecated




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