We apologize for the interruption. However, seabreezecomputers.com has been offering free tools and downloads for many years. Unfortunately, server expenses are now starting to exceed revenue earned. If you appreciate the free tools and downloads at seabreezcomputers.com please consider making a donation.
Convert any php MySQL code into MySQLi code instantly. Paste your code in the box below and press "Convert". Please make sure that you have a backup of your code before you use the code provided by this converter. There are no guarantees.
Your converted mysqli code will appear in the box below:
Copyright © 2017 by Jeff Baker
6/14/2020 - Version 1.2n - Bug Fix: Fixed a bug where the mysql connection link was defaulting to $mysqli instead of getting the link from a statement like $link = mysql_connect();
5/13/2020 - Version 1.2m - Converter was converting & to & in orginal source box. Hopefully that is fixed. Also, converter was having a problem with nested functions like: $sql_row = mysql_fetch_row(mysql_query($sql)); and only converting the first function to mysqli. Hopefully this has been fixed at well.
11/12/2019 - Version 1.2k - Fixed $link->close so it has parentheses with $link->close()
8/20/2019 - Version 1.2j - Added conversion for mysql_pconnect to mysqli_connect.
7/12/2019 - Version 1.2i - The converter was putting too many closing parentheses on object oriented ->data_seek(n). This has been fixed.
7/11/2019 - Version 1.2h - The converter was still getting confused with some nested parentheses. Hopefully this version has fixed the problem.
5/27/2019 - Version 1.2g - The converter is even better at capturing functions and variables with a better recursive balanced parentheses match algorithm.
5/2/2019 - Version 1.2f - Bug fix: $link = @mysql_connect() was converting to $link = @ = new mysqli() . Since @ is not recommended to suppress errors, the @ is now removed completely in front of mysql_connect when converted.
5/1/2019 - Version 1.2e - Bug fix: The object oriented conversion of mysql_result() was not putting the proper number of closing parentheses for $mysqli->query($dataquery->data_seek());
4/27/2019 - Version 1.2d - The bug fix for version 1.2c was accidentally capturing too many parentheses and getting multiple functions on one line such as: $result=mysql_query($query, $link) or die(mysql_error()). This has been fixed!
4/26/2019 - Version 1.2c - Bug fix: Previously the converter was having a difficult time with recursive parentheses in mysql statements and therefore splitting at the wrong commas. This has hopefully been fixed.
3/28/2019 - Version 1.2b - Bug Fix: Previously mysql_numrows was being incorrectly converted to mysqli_numrows. This has been fixed so that it correctly converts to mysqli_num_rows.
8/13/2018 - Version 1.2 - Bug Fix: A conversion of code like if (mysql_db_query($DBName, $Query, $Link)) was not converting to proper code. This has been fixed.
7/6/2018 - Version 1.1 - Changed conversion of MYSQL_NUM => MYSQLI_NUM to only convert if it is uppercase letters so that it will not convert mysql_num_rows to MYSQLI_NUM_rows.
08/01/2017 - Version 1.0 - Cool MySQL to MySQLi Online Converter Tool created.