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; }