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 3 of 3
  1. #1
    Master Coder mlseim's Avatar
    Join Date
    Jun 2003
    Location
    Cottage Grove, Minnesota
    Posts
    9,386
    Thanks
    8
    Thanked 1,077 Times in 1,068 Posts

    mysqli question primarily for Fou-Lu

    Fou-Lu,

    I'm curious about the change to "mysqli".

    Let's say I've been in charge of several WordPress websites hosted on different shared webhosts. Eventually there will be the change to mysqli. What do I have to do on my end? Do I have to go to every website and redo my scripting from mysql to mysqli, or is the change seamless?

    And that goes for websites where I've done custom "PHP/mysql" ... that doesn't have updates like WordPress does.

  • #2
    God Emperor Fou-Lu's Avatar
    Join Date
    Sep 2002
    Location
    Saskatoon, Saskatchewan
    Posts
    16,979
    Thanks
    4
    Thanked 2,659 Times in 2,628 Posts
    I'd assume that CMS and similar software like wordpress will update their own storage handling, so you'll simply need to get an update for it. They may even use it now, or PDO.
    If you've written something custom, and used the mysql library explicitly, than you'll need to rewrite those sections. If you've extended some functionality for something like wordpress, and used their access functions, than the conversion shouldn't need manual changing.
    But it's all going to come down to the system's implementation of the mysqli. Since it uses both raw and prepared statements, I don't know what they will do for changes. My *guess* would be that prepared would run through different functionality than the existing ones, and the existing will continue to be raw. This way existing functionality will work without needing to perform modifications to code that currently uses them.
    If its in the object oriented world, I'd expect an adapater of some sorts.
    PHP Code:
    header('HTTP/1.1 420 Enhance Your Calm'); 

  • Users who have thanked Fou-Lu for this post:

    mlseim (02-04-2013)

  • #3
    Master Coder mlseim's Avatar
    Join Date
    Jun 2003
    Location
    Cottage Grove, Minnesota
    Posts
    9,386
    Thanks
    8
    Thanked 1,077 Times in 1,068 Posts
    Thanks.
    That reply was helpful to myself as well as many others (I would assume).


  •  

    Posting Permissions

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