PHP MySQL第二次查询失败

Question

我的第二个MySQL查询似乎由于未知的原因而失败。只有在从$dbLink->query()中获得结果时，连接时才不会出现问题；

$photos = getPhotos(getID($_COOKIE[$uname_cookie], $_COOKIE[$passwd_cookie]));

function getID($uName, $passwd) {
    // Just in case, for modularity :P
    include 'misc.php';
    $query = "SELECT ID FROM Users WHERE UserName = '" . $uName . "' AND Password = '" . $passwd . "';";
    $dbLink = new mysqli($host, $user, $pass, $dbname);
    if ($dbLink->connect_errno) {
        echo "Failed to connect to database: " . $dbLink->connect_error;
        return null;
    } else {
        $results = $dbLink->query($query);
        print_r($results->fetch_array());
        $rows = $results->fetch_array();
        return $rows["ID"];
    }
}

function getPhotos($id) {
    // Just in case, for modularity :P
    include 'misc.php';
    $query = "SELECT Location FROM Photos WHERE UserID = " . $id . ";";
    $dbLink = new mysqli($host, $user, $pass, $dbname);
    if ($dbLink->connect_errno) {
        echo "Failed to connect to database: " . $dbLink->connect_error;
        return null;
    } else {
        $results = $dbLink->query($query);
        print_r($results->fetch_array());
        $rows = $results->fetch_array();
        return $rows["ID"];
    }
}

编辑:通过将$dbLink传递给函数IE getPhotos($id，$dbLink)获得它

Answer 1

$query = "SELECT Location FROM Photos WHERE UserID = '" . $id . "';";