dqce48404 2016-10-01 10:07
浏览 25
已采纳

怎么做mysql到mysqli

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.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥15 地图软件开发技术答疑(api, 地点获取,外观样式)
  • ¥20 物理远程控制麦克风使用问题
  • ¥15 打印预览会泄漏纸钱包密码吗
  • ¥15 在hololens1上运行unity项目只有空窗口
  • ¥25 TABLEAU PREP无法打开
  • ¥15 百度帐号问题/centos
  • ¥15 关于#c语言#的问题:求完整代码条件好说
  • ¥100 HALCON DELPHI
  • ¥15 (需要远程,AI不回)VB6二进制文件转换成功,但是C#转换总是失败
  • ¥15 关于#matlab#的问题:有没有什么其他办法能够保证不退出进程(相关搜索:matlab调用)