php - 对两个准备好的语句使用相同的 MySql 连接

Question

所以我的 PHP 代码有问题，我试图运行两个已用相同 $mysqli 对象“准备”的准备好的语句。

        require 'database.php';
        $mysqli = new mysqli($database_host, $database_user, $database_pass, $database_name);

        /*First check if there is already a preference record for this user
          with this particular course.*/
        $query = "SELECT * FROM timetablePrefs WHERE username=? AND courseID=?";
        $stmt = $mysqli->prepare($query);
        foreach ($courseList as $key => $value)
        {
            $stmt->bind_param("ss", $username, $key);
            $stmt->execute();
            if (($stmt->num_rows) === 1)
                continue;
            else
            {
                $query = "INSERT INTO timetablePrefs (username, courseID, hexColour, hidden) ";
                $query .= "VALUES (?, ?, ?, 0)";
                $prepared = $mysqli->prepare($query);
                $prepared->bind_param("sss", $username, $key, "#FFFFFF");
                if (!($prepared->execute()))
                    print("Sorry couldnt change your colour preferences.");
                $prepared->close();
            }
        }
        $stmt->close();
        $mysqli->close();

我可能在这里遗漏了一些东西；你甚至可以同时运行其中两个吗？如有任何帮助，我们将不胜感激!如有任何问题，请提出；)

我收到的错误与线路有关； $prepared->bind_param("sss", $username, $key, "#FFFFFF"); fatal error :在非对象上调用成员函数bind_param()

Answer 1

1. To get the actual error
2. To solve it 。从错误中您可以看出之前的查询有待处理的结果。需要存储它们