Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    Regular Coder
    Join Date
    Oct 2009
    Posts
    432
    Thanks
    6
    Thanked 3 Times in 3 Posts

    is MySQL also being deprecated or just the MySQL Library ?

    I see in the footnote of a reply I had about MySQL Library being deprecated.

    As of PHP 5.5, the MySQL library has been officially deprecated. It is recommended to move to either MySQLi or PDO libraries for your mysql connectivity. See here for help choosing which interface you prefer: http://php.net/manual/en/mysqlinfo.api.choosing.php

    Before I make a start, I wanted to ensure I understand that it is just the PHP used to connect to MySQL that is changing and not that MySQL is also being deprecated.

  • #2
    Master Coder felgall's Avatar
    Join Date
    Sep 2005
    Location
    Sydney, Australia
    Posts
    6,603
    Thanks
    0
    Thanked 645 Times in 635 Posts
    MYSQLI_ can only access mySQL databases,

    PDO can access mySQL databases as well as other databases (but because it supports multiple databases it is slightly slower).

    Both support PREPARE and BIND commands which allow you to keep your SQL and data completely separate and so remove all possibility of injection.

    MYSQL_ is being removed because it doesn't support all the modern functionality that mySQL databases support such as PREPARE and BIND.

    It is just the MYSQL_ interface that is being deleted. The other two ways to access mySQL databases still exist and both have been recommended as replacements for MYSQL_ since PHP 5 was first released.
    Stephen
    Learn Modern JavaScript - http://javascriptexample.net/
    Helping others to solve their computer problem at http://www.felgall.com/

    Don't forget to start your JavaScript code with "use strict"; which makes it easier to find errors in your code.

  • Users who have thanked felgall for this post:

    needsomehelp (01-31-2013)

  • #3
    Regular Coder
    Join Date
    Oct 2009
    Posts
    432
    Thanks
    6
    Thanked 3 Times in 3 Posts
    I see, thank you.

  • #4
    Supreme Master coder! abduraooft's Avatar
    Join Date
    Mar 2007
    Location
    N/A
    Posts
    14,851
    Thanks
    160
    Thanked 2,223 Times in 2,210 Posts
    Blog Entries
    1
    Have a look at the article Fedora Looks To Replace MySQL With MariaDB too.

    The original company behind MySQL, MySQL AB, were bought out by Sun which was then bought by Oracle. Recent changes made by Oracle indicate they are moving the MySQL project to be more closed. They are no longer publishing any useful information about security issues (CVEs), and they are not providing complete regression tests any more, and a very large fraction of the mysql bug database is now not public.
    The Dream is not what you see in sleep; Dream is the thing which doesn't let you sleep. --(Dr. APJ. Abdul Kalam)


  •  

    Posting Permissions

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