} redirect_head(current_url()); } /* if Pet_Type breed(s) is/are being updated or deleted*/ if (isset($_POST["submit_" . $type->name . "_breeds"])) { $breeds_array = Breed::find_by_sql("SELECT * FROM `" . Breed::$table_name . "` WHERE `pet_type_wk` = " . $type->pet_type_wk . ";"); foreach ($breeds_array as $breed) { // check if the breed is being deleted if (isset($_POST["delete_" . $breed->breed_wk])) { $success = true; // tracks if pets are successfully saved // Reassign all pets associated with this breed to the undefined // breed associated with the pet type $undefined_breed = Breed::find_by_sql("SELECT * FROM `" . Breed::$table_name . "` WHERE `pet_type_wk` = " . $breed->pet_type_wk . " AND `name` = 'undefined' LIMIT 1;"); if (!$undefined_breed) { $undefined_breed = Breed::find_by_id(0); } $database->query("UPDATE `" . Pet::$table_name . "` SET `breed_wk` = " . $undefined_breed->breed_wk . " WHERE `breed_wk` = " . $breed->breed_wk . ";"); // now delete the actual breed if ($success) { if ($breed->delete()) { $session->message($session->message . "The breed {$breed->name} was successfully deleted!<br />"); } else { $session->message($session->message . "The breed {$breed->name} was not deleted. Please try again.<br />"); } } else { $session->message($session->message . "Unable to delete the {$breed->name} breed because pets are still associated with it.<br />"); } } elseif ($breed->name != $_POST["{$breed->breed_wk}"]) { // check if empty if (empty($_POST["{$breed->breed_wk}"])) {