Exemplo n.º 1
0
function deletePicture($data)
{
    $results = [];
    //checks if requests needed are present and not empty
    $dataNeeded = array("username");
    if (checkData($data, $dataNeeded)) {
        //check if user provided exists
        $user = getAUser($data["username"]);
        if ($user["count"] > 0) {
            //update database
            $db = new pdodb();
            $query = "UPDATE User SET Picture = null WHERE Username = :username;";
            $bindings = array(":username" => $data["username"]);
            $picture = $db->query($query, $bindings);
            //if update was ok
            if ($picture["count"] > 0) {
                //checks if file exists to delete the picture
                if (file_exists($user["rows"][0]["Picture"])) {
                    unlink($user["rows"][0]["Picture"]);
                }
                //return updated user
                $results = getAUser($data["username"]);
                $results["meta"]["ok"] = true;
            } else {
                //check if database provided any meta data if so problem with executing query
                if (isset($picture["meta"])) {
                    $results = $picture;
                } else {
                    $results["meta"]["ok"] = false;
                }
            }
        } else {
            //check if database provided any meta data if so problem with executing query
            if (isset($user["meta"])) {
                $results = $user;
            } else {
                $results["meta"] = noUserFound($data["username"]);
            }
        }
    } else {
        $results["meta"] = dataNotProvided($dataNeeded);
    }
    return $results;
}
function deletePicture($data)
{
    //checks if requests needed are present and not empty
    $dataNeeded = array("username", "password", "projectID", "file");
    if (checkData($data, $dataNeeded)) {
        //checks if user provided exists
        $results = login($data);
        if ($results["meta"]["ok"] === true) {
            //error getting goal
            $results = getProject($data["projectID"]);
            if ($results["count"] > 0) {
                //update database
                $db = new pdodb();
                $query = "DELETE FROM PortfolioProjectImage WHERE ProjectID = :projectID AND File = :file;";
                $bindings = array(":projectID" => $data["projectID"], ":file" => $data["file"]);
                $results = $db->query($query, $bindings);
                //if update was ok
                if ($results["count"] > 0) {
                    //checks if file exists to delete the picture
                    if (file_exists($data["file"])) {
                        unlink($data["file"]);
                    }
                    $results["meta"]["ok"] = true;
                    $results["rows"]["file"] = $data["file"];
                } else {
                    //check if database provided any meta data if so problem with executing query
                    if (!isset($results["meta"])) {
                        $results["meta"]["ok"] = false;
                    }
                }
            }
        }
    } else {
        $results["meta"] = dataNotProvided($dataNeeded);
    }
    return $results;
}