Register now or log in to join your professional community.
Is there any chance to replace MySql with MySqli.... ? Then how it wil affect the softwares running with mysql backend.
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.
MySQL extension is deprecated from PHP5.5.0. So, its best to either develop using MySQLi or use PDI_MySQL
