Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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 ajoutée par Jemsheer Ahmed Pilaparambil , System Analyst , MEA Engineering College
Date de publication: 2013/06/03
Gailad Chesa
par 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
par 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