MySQL or MySQLi

Mihai B. · Mar 24, 2017

In my config file of my website cms, it decaled this variable

Code:

$config['Database']['dbtype'] = 'mysqli';

and on old version

Code:

$config['Database']['dbtype'] = 'mysql';

Which should I use? why?

Can you tell me what is the difference between mysqli and mysql? which one is right for you?

thanks
Mihai

HostBastic · Mar 24, 2017

MySQLi or MySQL Improved and somtimes refered as MySQL improved extension is a relational database driver that is used with PHP. MySQLi is a replacement for the mysql functions, with object-oriented and procedural versions, it supports prepared statements.
Which one is right for you, that depends on what you are trying to achive, however both will be able to use MySQL from PHP.

JohnnyK · Mar 24, 2017

MySQL is the old database and Improved driver. MySQLi takes advantage of the newer features of MySQL 5.
MySQLi is the OOP version of MySQL extension. In the end, MySQLi and MySQL accomplish the same thing: they are extensions for interacting with MySQL from PHP.

iserveradmin11 · Mar 25, 2017

Hello,
As far I know MySQLi Extension (or simply known as MySQL Improved or MySQLi) is a relational database driver that is used mainly in the PHP programming language. It provides an interface to the already founded MySQL databases. It is quite literally an improved version of its predecessor, MySQL, which was simply a means to manage databases over servers.

overcast · Jul 22, 2017

You should migrate to Mysqli as soon as possible. If you choose to use old verison then in future you may have to update code for the php 7. In php 7 onwards you don't have much backward compatibility support. So use MySQLi and PDO.

24x7serverman · Jul 25, 2017

MySQLi is improved version of MySQL. It offers more security and supports various features like prepared statement, both procedural and object-oriented interface. It has debugging feature too. Extension directories for MSQL is /etc/mysql and for MySQLi is /etc/mysqli.

MySQL or MySQLi

Mihai B.

Well-known member

HostBastic

Well-known member

JohnnyK

Member

iserveradmin11

Member

overcast

Well-known member

24x7serverman

Well-known member

Latest posts New threads

Latest posts

New threads

Latest Hosting Offers New Reviews

Latest hosting offers

Popular Contributors - Past 30 Days

Sponsors

Tag Cloud