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.
3条回答 默认 最新
- dph6308 2016-10-01 10:20关注
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.
本回答被题主选为最佳回答 , 对您是否有帮助呢?解决 无用评论 打赏 举报 - Search for
悬赏问题
- ¥15 地图软件开发技术答疑(api, 地点获取,外观样式)
- ¥20 物理远程控制麦克风使用问题
- ¥15 打印预览会泄漏纸钱包密码吗
- ¥15 在hololens1上运行unity项目只有空窗口
- ¥25 TABLEAU PREP无法打开
- ¥15 百度帐号问题/centos
- ¥15 关于#c语言#的问题:求完整代码条件好说
- ¥100 HALCON DELPHI
- ¥15 (需要远程,AI不回)VB6二进制文件转换成功,但是C#转换总是失败
- ¥15 关于#matlab#的问题:有没有什么其他办法能够保证不退出进程(相关搜索:matlab调用)