Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the Life of Mysql...? Will Mysqli replace Mysql...?

Is there any chance to replace MySql with MySqli.... ? Then how it wil affect the softwares running with mysql backend.

user-image
Question added by Jemsheer Ahmed Pilaparambil , System Analyst , MEA Engineering College
Date Posted: 2013/06/03
Gailad Chesa
by Gailad Chesa , Software Delivery Lead , BET Software

As PHP evolves from one version to the other, there are some extensions or functions that get phased out or deprecated as well. For an example, in PHP 5 users had the option to choose between 3 extensions, namely mysql, mysqli or pdo. As PHP 7 comes into being, they removed the mysql extension leaving mysqli and pdo.

Is there any chance to replace mysql with mysqli? Yes, you can definitely replace all your old mysql connections and queries with the new mysqli connections and queries.

 

Then how it will affect the software’s running with mysql back end?  Once you convert all your queries from mysql to mysqli everything else should continue running the same. However if you do not change to mysqli and your server PHP version is upgraded to PHP7 where the mysql extension is deprecated, then your application will not run. 

Atif Majid
by Atif Majid , Senior PHP Programer/Team Lead , RedApple Apartments AB

MySQL extension is deprecated from PHP5.5.0. So, its best to either develop using MySQLi or use PDI_MySQL

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.