Convert php to mysqli

Saved searches

Use saved searches to filter your results more quickly

You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session.

philip/MySQLConverterTool

This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?

Sign In Required

Please sign in to use Codespaces.

Launching GitHub Desktop

If nothing happens, download GitHub Desktop and try again.

Launching GitHub Desktop

If nothing happens, download GitHub Desktop and try again.

Launching Xcode

If nothing happens, download Xcode and try again.

Launching Visual Studio Code

Your codespace will open once ready.

There was a problem preparing your codespace, please try again.

Latest commit

Git stats

Files

Failed to load latest commit information.

README.md

This project has, essentially, been abondoned. Do consider an alternative described below.

The old MySQL extension ( ext/mysql ) was deprecated in PHP 5.5 and removed in PHP 7.0.

This tool converts ext/mysql code to ext/mysqli code, as ext/mysqli is the current MySQL extension. There’s also PDO_MySQL but this tool does not use that. This tool is not perfect but will help with the conversion.

Library: A quicker and simpler short-term fix is to use a bundled native PHP library such as php7-mysql-shim. Instead of converting code (e.g., mysql_connect() to mysqli_connect() ) it uses ext/mysqli to define ext/mysql functions in PHP. Much easier but more of a short-term fix. Although php7-mysql-shim contains PHP 7 in the name, it works with older PHP versions but only if ext/mysql is not installed on your system.

Convertor: The Rector tool is popular and maintained; and it includes tools to convert ext/mysql code to ext/mysqli code. See its mysqltomysqli rules.

There are two interfaces: GUI and CLI. Example usages:

Using PHP’s built-in web server

For example, in a terminal you might do this:

shell> wget https://github.com/philip/MySQLConverterTool/archive/master.zip shell> unzip master.zip shell> cd MySQLConverterTool-master/GUI shell> php -S localhost:8000 

Then, go to http://localhost:8000 . From there you can choose to convert a snippet (copy-n-paste), a single file, or a directory. You can choose to convert the files themselves (assuming the web server has rights), make backups, or simply output the code to your browser.

Download as you did above, and here is an example to convert a file named /tmp/my.php

$ cd MySQLConverterTool-master $ php cli.php -f /tmp/my.php 

Execute php cli.php -h to see the available options.

That absolutely NO security checks are performed by the tool which prevent users from trying to read and convert files (e.g. /etc/passwd ). Make sure to add security measures, if needed.

See the wiki for additional information, including screenshots.

Also, a mysql_result equivelant does not exist in ext/mysqli so you must define mysqli_result . The tool does suggest code for this but it does not insert this definition into your converted markup:

function mysqli_result($result, $number, $field=0) < mysqli_data_seek($result, $number); $type = is_numeric($field) ? MYSQLI_NUM : MYSQLI_ASSOC; $out = mysqli_fetch_array($result, $type); if ($out === NULL || $out === FALSE || (!isset($out[$field]))) < return FALSE; > return $out[$field]; >

The php7-mysql-shim PHP library defines all mysql_ functions for you, so simply include it (a single PHP file) and your code should work without a need to convert. It uses ext/mysqli and works fine in PHP 5.3 or greater. There are pros and cons to each approach.

Also, consider refactoring your code. Whether you convert your code with MySQLConverterTool or define ext/mysql functions using a library such as php7-mysql-shim, these are considered stop-gap measures until you rewrite your code. For example, your new code will probably use prepared statements.

Although unit tests exist, they were not maintained by the lazy developer here. Perhaps one day, see UnitTests/README .

All forms of feedback is welcome and encouraged! Either as bug reports, feature requests, pull requests, complaints, and so on.

Источник

Saved searches

Use saved searches to filter your results more quickly

You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session.

PHP 7 Converter converts a code with mysql Extensions easy to mysqli

License

julianschmuckli/php7converter

This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?

Sign In Required

Please sign in to use Codespaces.

Launching GitHub Desktop

If nothing happens, download GitHub Desktop and try again.

Launching GitHub Desktop

If nothing happens, download GitHub Desktop and try again.

Launching Xcode

If nothing happens, download Xcode and try again.

Launching Visual Studio Code

Your codespace will open once ready.

There was a problem preparing your codespace, please try again.

Latest commit

Git stats

Files

Failed to load latest commit information.

README.md

With PHP7Converter, you can convert your PHP files, which uses the old syntax mysql to the new standard mysqli.

It supports code convert, which you can only paste the code, convert it and copy it from the page. It also supports Multi-File Convert, so you can paste your Directory and simply convert all files, which are in the directory.

To install the PHP 7 Converter, you only put the files from the zip on your server, and start it via the web browser.

Put in your code and click on «Convert».

Click on the button «Convert Directory» and write in your directory, which must be convert.

About

PHP 7 Converter converts a code with mysql Extensions easy to mysqli

Источник

Cool MySQL to MySQLi Online Converter Tool

Newsletter Don’t miss out on new Internet Tips and Tools. Sign up for the seabreezecomputers.com Internet Tips and Tools newsletter:

A message from Sea Breeze Computers 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. 0.00 has been donated. —>

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: Sea Breeze Computers Home Page Copyright © 2017 by Jeff Baker
History 11/7/2021 — Version 1.2p — Bug Fix: A semicolon in a MySQL Query was causing the mysql function not to be converted to mysqli. This has been fixed. 11/4/2021 — Version 1.2o — Bug Fix: Previously the converter was looking to see if an optional $link was provided at the end of mysql functions such as mysql_query($query, $link). It knew not to look for the optional $link in quotes but it didn’t know not to look for the optional $link in parentheses. This has been fixed. Example. Previously it was converting:
$resultu2 = mysql_query( «SELECT DATE_FORMAT(‘$UpDate1’, ‘%W, %M %D’) FROM Scoring LIMIT 1»);
to:
$resultu2 = %M %D’) FROM Scoring LIMIT 1″->query( «SELECT DATE_FORMAT(‘$UpDate1’, ‘%W);
This has been fixed so that it now correctly converts to:
$resultu2 = $mysqli->query( «SELECT DATE_FORMAT(‘$UpDate1’, ‘%W, %M %D’) FROM Scoring LIMIT 1»); 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 original 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.

• Type emails with your voice
• Write documents with your voice
• Control the Inernet with your voice
• Chrome Extension

Источник