Diff Between mysql & mysqli

12 years ago

Mysqli is newer, improved version of mysql, and it has support for prepared statements. Here's everything you should know: PHP: Mysqli - Manual.

Thanks

{{ DiscussionBoard.errors[8945662].message }}

kidino

12 years ago

Plus mysql_ will be deprecated in newer versions of PHP. You better update your codes to mysqli_ or PDO functions.

Thanks

Signature

DIPPEC - PHP Script for Selling Digital Products with Paypal. No more monthly SaaS fees. No more commission fees. Keep it all for yourself (except for Paypal fees).

Free Pricing Table Builder

{{ DiscussionBoard.errors[8959037].message }}

PrinceYababa

12 years ago

MySQL is a database query software that uses the language SQL. MySQLi is also known as a MySQL injection. With software now can be used to hack into a website and take all the credit card information of the paid members.

Thanks
1 reply

Signature

Official Website -
http://www.yababaworld.com
The Yababa Showâ„¢ -
http://www.youtube.com/user/yababavideo
Network Security|Software Development |WebDev

{{ DiscussionBoard.errors[8967597].message }}

multiplecloud

12 years ago

Originally Posted by PrinceYababa

MySQL is a database query software that uses the language SQL. MySQLi is also known as a MySQL injection. With software now can be used to hack into a website and take all the credit card information of the paid members.

Very mislead information. Please correct it.

Thanks

Signature

█ SafePBN - PBN on different shared hosting company
█ 100% no bad neighborhood | host pbn at safest
█ MultipleCloud - Multiple location hosting provider
█ 200+ worldwide location | different server | different ip owner | best for pbn

{{ DiscussionBoard.errors[8972633].message }}

kidino

12 years ago

MySQLi IS NOT MySQL INJECTION!

It's MySQL Improved. A better library in PHP (mysqli_*) to communicate with MySQL database as oppose the legacy mysql_* type functions.

PHP: Mysqli - Manual

Thanks

Signature

DIPPEC - PHP Script for Selling Digital Products with Paypal. No more monthly SaaS fees. No more commission fees. Keep it all for yourself (except for Paypal fees).

Free Pricing Table Builder

{{ DiscussionBoard.errors[8972458].message }}

TangoDuck

12 years ago

It should also be noted that the traditional mysql is deprecated in PHP 5.5 and up, so you should start getting used to MySQLi

Thanks

{{ DiscussionBoard.errors[8973803].message }}

MonopolyOnline

12 years ago

You may also want to consider switching from MySQL to MariaDB for your PHP apps.

Here's why:

SlashDot.org/topic/bi/mariadb-vs-mysql-a-comparison/

May 22, 2013

"MariaDB is a fork of the MySQL source code, split off in the wake of concerns over what Oracle would do with MySQL licensing. (MySQL was purchased by Sun, which was subsequently snatched up by Oracle.) These are valid concerns, which I get to later in this article. In addition to its role as a "drop-in replacement" for MySQL, MariaDB also includes some new features that (some claim) make it better than MySQL."

Pontikis.net/blog/is-it-time-to-remove-mysql-in-favor-of-mariadb-in-production-servers

April 1st 2013,

"MariaDB is a fork of MySQL, which is community maintained under the GPL v2 license. All code in MariaDB is open source. MariaDB is a binary drop in replacement for MySQL. It includes the XtraDB storage engine as a replacement for InnoDB. Its lead developer is Michael Widenius (also known as "Monty"), the founder of MySQL.

Recently, many popular Linux distributions have moved from MySQL to MariaDB as default database server. Fedora since version 19, Archlinux since March 2013 and OpenSuse.

Moreover, Wikipedia is moving to MariaDB and Mozilla is also now using MariaDB.
"

Thanks
1 reply

{{ DiscussionBoard.errors[8986262].message }}

wilsonmarcial 12 years ago
"mysqli" extension is an improvement over the old "mysql" extension
mysqli was developed to take advantage of the new features available in MySQL since version 4.1.3. Also, you can use it since PHP 5. So, if you code with PHP5 with a newer version of MySQL, it's strongly recommended for you to use the extension "mysqli" over "mysql"

Key benefits of mysqli over mysql extension
- Object-oriented interface
- Prepared Statements
- Multiple Statements
- Support for Transactions
- Enhanced debugging capabilities.
- Embedded server support.
- Thanks
{{ DiscussionBoard.errors[9457011].message }}

Member8200

12 years ago

The "i" stands for "improved". mysqli is the improved version of the old mysql, although still a lot of programmers(web or desktop) still uses mysql. Mysqli requires PHP 5.0.7+ and MySQL 4.1.13+.

Some features of mysqli:
Embedded server support, Support for ability to use transactions, Support for prepared statements, Object-oriented interface etc..