Jump to content

mysql to mysqli


coppens

Recommended Posts

Good day,

 

I have a website that I have labored over as I am learning but determined, only to find out that mysql is depreciating.  How do I switch my site to mysqli?  I use a myphpadmin database with the site.  Thank you so much.

Link to comment
Share on other sites

I checked and they have no idea what I am talking about.  The tech keeps saying that mysql works fine.  Is this something that I fix on my website coding itself, or is it something that my hosting domain updates and I just tag along?

Edited by coppens
Link to comment
Share on other sites

If you are wanting to learn more about mysqli and hone in on your skills, you can check out the documentation on php.net: http://php.net/manual/en/book.mysqli.php

 

However, if you are looking to convert your current code from mysql functions to mysqli in a hurry, there was a converter tool on Oracle's website that I believe has been relocated to Github: https://github.com/philip/MySQLConverterTool

Link to comment
Share on other sites

Just to be clear, the database itself will still be a MySQL database - MySQL's not going anywhere.

 

MySQLi is a php class that's replacing the deprecated MySQL php functions. So it has nothing to do with the database itself, but rather with the way you interact with the database in php.

 

All the mysql_somethingfunction() that you see in the code itself need to be updated to use mysqli_comparativefunction().

  • Like 1
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.