Diff Between mysql & mysqli

by 10 replies
12
Hi Friends

Please anyone tell me what is the difference between mysql & mysqli?

Thanks & Regards
Katypeterson
#programming #diff #mysql #mysqli
  • Mysqli is newer, improved version of mysql, and it has support for prepared statements. Here's everything you should know: PHP: Mysqli - Manual.
  • Plus mysql_ will be deprecated in newer versions of PHP. You better update your codes to mysqli_ or PDO functions.
  • 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.
    • [1] reply
  • 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
  • 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
  • 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/



    "MySQLwhat Oracle would do with MySQL licensing"


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

    April 1st 2013,

    "

    "
    • [1] reply
    • "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.
  • 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..
  • full form of mysqli is mysql improved.it is new version of mysql and mysqli is also safer than mysql.
Join the discussion

Next Topics on Trending Feed