怎么做mysql到mysqli

Question

Not to a specific query but all of software queries to be converted from mysql to mysqli due to the advent of PHP 7. It is a very old coding and so there are many occurrences as such. Piece of string or syntax is mysql_query($query, $link);to be converted to mysqli_query($link, $query); $link1, $link2 can be for different database connections.

Answer 1

Use regular expressions. I have not checked that my expression works as advertised, and regular expression syntax varies depending on the tool you use. But in general it should work this way:

• Search for mysql_query\(("[^"]*"), *(\$[a-zA-Z0-9_]+)\)
• Replace with mysqli_query($2, $1)

As an example, in Eclipse IDE, use "Search/File...", tick the checkbox "Regular expression", specify "*.php" as file name pattern and enter this as under "Containing text":

mysql_query\(("[^"]*"), *(\$[a-zA-Z0-9_]+)\)

Then hit the "Replace..." button and enter this under "With":

mysqli_query($1, $2)

Click Preview to check the results. If done correctly, this can update hundreds of files within seconds. Remember to test your code afterwards.