問題描述

在我的數(shù)據(jù)庫中，我有一些存儲(chǔ)過程.

In my db I have some stored procedures.

我想打電話給其中一個(gè)，根據(jù)我從這個(gè)程序得到的結(jié)果，我會(huì)決定天氣是否打電話給第二個(gè).

I want to call the one of them, and according to the results I get from this procedure, i will determine weather to call the second one or not.

正如您在 isUserValid() 方法中看到的，我使用了 $result->free_results()

As you can see in the isUserValid() method I've used $result->free_results()

但仍然在調(diào)用另一個(gè)過程時(shí)我得到:命令不同步；你現(xiàn)在不能運(yùn)行這個(gè)命令

but still when calling the other procedure I get: Commands out of sync; you can't run this command now

這是我對(duì) db 函數(shù)的調(diào)用:

This is my calling to the db functions:

    /**
     * Run a new query on the db.
     * this will open an close the connection to the db
     * @param $query string the query to run
     * @param $verifyAccessToken boolean true if user validation is needed before query is executed, false otherwise
     * @return bool|mysqli_result the result of the query if any or true or false in a non query
     * @throws Exception on connection and query errors
     */
    private function queryDb($query,$verifyAccessToken)
    {
       // if ($this->test)
//            echo $query . "<br>";
        //create a new mysqli connection
        $mysqli = new mysqli($this->DB_HOST, $this->DB_USER, $this->DB_PASS, $this->DB_NAME);
        //set the charset for the connection
        if (!$mysqli->set_charset("utf8"))
        {
            $mysqli->close();
            throw new Exception ("Error setting UTF 8 DB connection");
        }
        //check if the connection was ok
        if (mysqli_connect_errno())
        {
            $mysqli->close();
            throw new Exception("Error connecting DB");
        }

        //if verification is needed - verify access token
       if ($verifyAccessToken && !$this->isUserValid($mysqli))
       {
          $mysqli->close();
          throw new Exception(ACCESS_TOKEN_INCORRECT);
       }

        //get results
        $result = $mysqli->query($query);
        //check if there were now error in query. if so - throw an exception
        if (!$result)
        {
            $mysqlError = $mysqli->error . __LINE__;
            //close the connection
            $mysqli->close();
            throw new Exception ("mySQL Error: " . $mysqlError);
        }
        //fetch the results into an array
        $rows = $result->fetch_all(MYSQLI_BOTH);
        //close the connection
        $result->close();
        $result->free();
        $mysqli->close();
        //return the results if any
        return $rows;
    }

    /**
     * Check if user is valid
     * @param $mysqli mysqli connection to db
     * @return true if user is valid, false otherwise
     */
    function isUserValid($mysqli)
    {
        //Check if there is a saved access token. if not - throw an exception
        if (is_null($this->user) || $this->user->getPicoAccessToken() == null)
          throw new Exception(ACCESS_TOKEN_INCORRECT);
        //get user details
        $facebookId = $this->user->getFacebookId();
        $picoAccessToken = $this->user->getPicoAccessToken();
        //create verification query
        $verificationQuery = "Call isUserValid('$facebookId','$picoAccessToken')";
        //execute query
        $result = $mysqli->query($verificationQuery);

        //if query had error - throw exception
        if (!$result)
        {
         $mysqlError = $mysqli->error . __LINE__;
         //close the connection
         $mysqli->close();
         throw new Exception ("mySQL Error: " . $mysqlError);
        }
        $rows = $result->fetch_all(MYSQLI_ASSOC);
        $rows = $rows[0];
        $result->free_result();
        //return user valid status
        return isset($rows["isUserValid"]) && $rows["isUserValid"] == 1;
    }

推薦答案

每個(gè)存儲(chǔ)過程至少返回兩個(gè)結(jié)果

Every stored procedure returns at least two results

• 一個(gè)(或多個(gè))實(shí)際結(jié)果
• 一個(gè)空的結(jié)果告訴客戶沒有更多的結(jié)果.

你必須使用 mysqli_more_results()/mysqli_next_result() 來清理它們.

You have to use mysqli_more_results()/mysqli_next_result() to clean them.

如果您的過程只返回一個(gè)結(jié)果，或者您只想要第一個(gè)結(jié)果之外的任何額外結(jié)果，您可以使用以下代碼片段清理結(jié)果隊(duì)列:

If your procedure returns only one result, or you just don't want any extra results but the first one, you can clean up the results queue with this code snippet:

while($mysqli->more_results())
{
    $mysqli->next_result();
    if($res = $mysqli->store_result())
    {
        $res->free(); 
    }
}

這篇關(guān)于PHP mysqli 命令不同步；你現(xiàn)在不能運(yùn)行這個(gè)命令的文章就介紹到這了，希望我們推薦的答案對(duì)大家有所幫助，也希望大家多多支持html5模板網(wǎng)！