mysql - 在 php 5.6 上运行的查询不会在 php 7 上抛出错误

Question

如何将下面的代码转换为与 php7 一起使用？

else {
    $sql = "SELECT u.`steps`, c.`cityname` FROM `users` u LEFT JOIN `cities` c ".
           "ON u.`location` = c.`cityid` WHERE u.`userid` = '{$ir['userid']}'";
    $run = mysql_query($sql);
    $res = mysqli_fetch_array($run, MYSQL_ASSOC);


    $city_name  = $res['cityname'];
    $city_turns = $res['steps'];

Answer 1

来自 mysql_query 的文档:

This extension was deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0.

那就是你的问题了。

它接着说:

Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more information.

我建议使用 PDO路线。

请注意以后的问题:始终在问题文本中逐字包含错误消息，是吗？干杯。