echo file_name_with_get(); ?> " enctype="multipart/form-data" method="post" ><fieldset class="registration-form"> Name: <br><div class="form-group"><input type="text" class="form-control" name="name" value="" required/></div> <!-- default value needed for form --> <input type="hidden" class="form-control" name="MAX_FILE_SIZE" value="10000000" /> Image: <br><div class="form-group"><input type="file" class="btn btn-default btn-file btn-md" name="file_upload" /></div> Breed: <br><div class="form-group"><select name="breed" class="form-control"></div> <option value="0">Undefined</option> <?php //we need to display all available items //do a concatenation of the pet type and the breed $sql = "SELECT `b`.`breed_wk`, `b`.`pet_type_wk`, CONCAT(`p`.`name`,' - ',`b`.`name`) AS `name`, "; $sql .= "`b`.`create_dt` FROM `breed` AS `b` INNER JOIN `pet_type` AS `p` ON `p`.`pet_type_wk` = `b`.`pet_type_wk` "; $sql .= "WHERE `b`.`breed_wk` > 0 ORDER BY `p`.`name` ASC, `b`.`name` ASC"; $to_display = Breed::find_by_sql($sql); //loop through all items foreach ($to_display as $value) { echo "<option value=\"" . $value->breed_wk . "\""; echo ">" . $value->name . "</option>"; } ?> </select></div> Color: <br><div class="form-group"><select name="color" class="form-control"> <option value="0">Undefined</option> <?php //we need to display all available records $to_display = Color::find_all(); //loop through all items foreach ($to_display as $value) { echo "<option value=\"" . $value->color_wk . "\"";
echo "<input type=\"submit\" class=\"btn btn-success btn-md btn-block\" value=\"Add\" name=\"add_pet_type\">"; echo "</fieldset></form></section>"; /* Form */ // Loop through all of the breeds organized by pet type and create a form // to update their names. No delete functionality yet. Admin must ensure // no pets are associated to a particular breed or pet type before hard delete. echo "<section class=\"container center\">"; foreach ($pet_types_array as $type) { // create an update form for each breed within this pet type echo "<div class=\"container center\" ><div class=\"row\" ><fieldset class=\"registration-form\"> <div class=\"col-xs-6\"><form class=\"center\" role=\"form\" action=\"" . file_name_with_get() . "\" method=\"post\"> "; echo "<label style=\"text-transform:capitalize; font-size:30px; font-weight:bold;\">{$type->name}</label><br>"; echo "update to: <div class=\"form-group\"><input type=\"text\" class=\"form-control\" name=\"pet_type_name\" value=\"" . $type->name . "\" /></div>"; echo "<div class=\"form-group\"><input type=\"submit\" class=\"btn btn-success btn-md btn-block\" value=\"Update Pet Type\" name=\"submit_" . $type->name . "_name\"/></div>"; echo "<div class=\"form-group\"><input type=\"submit\" class=\"btn btn-success btn-md btn-block\" value=\"Delete Pet Type\" name=\"delete_" . $type->name . "_name\"/></div>"; echo "</form></div>"; $breeds_array = Breed::find_by_sql("SELECT * FROM `" . Breed::$table_name . "` WHERE `pet_type_wk` = " . $type->pet_type_wk . " ORDER BY `name` ASC;"); // update/delete form echo "<div class=\"col-xs-6\" ><br><br><form action=\"" . file_name_with_get() . "\" method=\"post\"> <fieldset class=\"registration-form\">"; $count = count($breeds_array); for ($i = 0; $i < $count; $i++) { echo "<div class=\"form-group row\"><input type=\"text\" class=\"form-control\" name=\"" . $breeds_array[$i]->breed_wk . "\" value=\"" . $breeds_array[$i]->name . "\">"; echo "Delete:<input type=\"checkbox\" name=\"delete_" . $breeds_array[$i]->breed_wk . "\" value=\"delete\" /></div>"; } echo "<div class=\"form-group\">Add new breed:<input type=\"text\" class=\"form-control\" name=\"new_breed\" value=\"\"></div>"; echo "<div class=\"form-group\"><input type=\"submit\" class=\"btn btn-success btn-md btn-block\" value=\"save\" name=\"submit_" . $type->name . "_breeds\"/></div>"; echo "</fieldset></form>"; echo "</div></fieldset></div></div> <hr> "; } echo "</section>"; //this is a special instance, remove the message, if it's set since we set the messages in this form $session->unset_variable('message');