public function DenyCie($_businessID) { $user = parent::DBQuery("SELECT business.userID, users.name, business.email FROM business\n INNER JOIN users ON business.userID = users.ID WHERE business.ID =" . $_businessID); $projects = parent::DBSearch("SELECT * FROM projects WHERE businessID =" . $_businessID); foreach ($projects as $project) { parent::DBExecute("DELETE FROM ratings WHERE projectID =" . $project['ID']); } parent::DBExecute("DELETE FROM projects WHERE businessID =" . $_businessID); parent::DBExecute("DELETE FROM business WHERE ID =" . $_businessID); parent::DBExecute("DELETE FROM users WHERE ID =" . $user["userID"]); $msg = "Votre entreprise, " . $user["name"] . ", a été refusée."; //Envoi du courriel de refus. $mail = mail($user["email"], $user["name"] . " Compte refusé", $msg); }