Not Working with MySQLi

Discussion in 'Databases' started by Cozmic, May 26, 2010.

  1. #1
    Hey,

    I developed a PHP script which uses MySQL. Unfortunately, it yields errors when you try to use the script with MySQLi. My MySQL version is 5.1.36. Any idea what I need to do different to accommodate MySQLi users? I don't know too much about different databases - this definitely isn't my strong point. so, forgive me if I missed something obvious.
     
    Cozmic, May 26, 2010 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    MySQLi is just a database object layer. It has nothing to do with the database itself. I'm not sure what you mean by mysqli users? MySQLi is merely a set of function that allow you to interact with the database in a slightly different way than the normal php mysql function would. It would require completely rewriting your queries and and database functions. Is there something specific you are having problems with?
     
    jestep, May 27, 2010 IP
  3. Cozmic

    Cozmic Member

    Messages:
    146
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    48
    #3
    Interesting. That's all my research turned up too. Maybe it's the person who said they were using MySQLi and that caused it not to work who's in the wrong here. He said his MySQL version said "MySQLi", though.
     
    Cozmic, May 27, 2010 IP
  4. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #4
    It's possible that mysqli isn't enabled in your php installation. Do you allow users to upload their own scripts or have their own hosting?
     
    jestep, May 27, 2010 IP
  5. Cozmic

    Cozmic Member

    Messages:
    146
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    48
    #5
    Nah, I just developed a PHP script and a user complained that it "didn't work with MySQLi". I wasn't quite sure what he meant as all my research turned up what you explained to me, so I asked here. My PHP installation has the MySQL and MySQLi extensions enabled, yes.
     
    Cozmic, May 27, 2010 IP