Stop Using the MySQL Extension!
Results 1 to 3 of 3

Thread: Stop Using the MySQL Extension!

  1. #1
    Pedantic Curmudgeon Weedpacket's Avatar
    Join Date
    Aug 2002
    Location
    General Systems Vehicle "Thrilled To Be Here"
    Posts
    21,906

    Stop Using the MySQL Extension!

    Development of PHP's MySQL extension (which provides all the mysql_* functions) ceased several years ago, and does not take advantage of any features added to MySQL since MySQL 4.1.

    PHP's developers recommend that this extension no longer be used for new development. It is now deprecated as of PHP 5.5, and it will eventually be removed from PHP.

    This does not mean that MySQL support is being removed. That would be silly.

    Years ago, all development of PHP's MySQL interface was shifted to the MySQLi and PDO::MySQL APIs, and all new development should use one of these; existing applications using the MySQL interface should be migrated as soon as it's feasible.

    Development of the MySQL extension ended at the same time, and has since only had maintenance work done on it to keep it functioning while the rest of PHP changed around it. And this is getting really boring. PHP's developers have better things to do than keeping an outdated extension ticking over, just as Microsoft has better things to do than supply updates for Windows 95.

    All manual pages for functions in the old API (mysql_connect, mysql_query, etc.) have warnings about this, and include references to suitable replacements.

    It is recommended to use either the mysqli or PDO_MySQL extensions. It is not recommended to use the old mysql extension for new development.
    http://www.php.net/mysqlinfo.api.choosing

    This extension is not recommended for writing new code. Instead, either the mysqli or PDO_MySQL extension should be used.
    http://www.php.net/intro.mysql


    Someone at Oracle (the owners of MySQL) has written a migration note (https://wikis.oracle.com/display/mys...ting+to+MySQLi), which includes a converter intended to ease the process. (Fair warning: I personally haven't used it, so I don't know how effective it is. It was published in December 2011. While I'm on the subject of fair warnings, I should point out that I generally don't use the MySQL DBMS anyway; I'm just collecting news from other sources here.)
    Last edited by Weedpacket; 11-19-2014 at 02:01 AM.
    THERE IS AS YET INSUFFICIENT DATA FOR A MEANINGFUL ANSWER
    FAQs! FAQs! FAQs! Most forums have them!
    Search - Debugging 101 - Collected Solutions - General Guidelines - Getting help at all

  2. #2
    Junior Member
    Join Date
    Jun 2014
    Location
    Dubai, United Arab Emirates
    Posts
    3
    Mysql extension, does it also includes mysqli extension?

  3. #3
    Pedantic Curmudgeon Weedpacket's Avatar
    Join Date
    Aug 2002
    Location
    General Systems Vehicle "Thrilled To Be Here"
    Posts
    21,906
    See the above post.
    THERE IS AS YET INSUFFICIENT DATA FOR A MEANINGFUL ANSWER
    FAQs! FAQs! FAQs! Most forums have them!
    Search - Debugging 101 - Collected Solutions - General Guidelines - Getting help at all

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •