Example #1
0
     }
     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}"])) {