/** * Renderize the view. * * @return null */ public function render(ProviderCategory $providerCategory) { ?> <p> <?php echo REQUIRED_FIELDS_TEXT; ?> </p> <form action="<?php echo $this->generateURL('provider_category', 'edit', $providerCategory->getIdProviderCategory()); ?> " method="post"> <fieldset> <div class="row"> <div class="col-md-6"> <div> <label for="category_name"> Nombre <small>(*)</small> </label> <input name="category_name" type="text" required value="<?php echo $providerCategory->getCategoryName(); ?> " /> </div> </div> <div class="col-md-6"> <div> <input type="submit" value="Modificar" /> </div> </div> </div> </fieldset> </form> <?php }
/** * Modify a provider saved in the database. * * @param ProviderCategory $providerCategory * @return integer */ public function editProviderCategory(ProviderCategory $providerCategory) { $sql = "UPDATE provider_category \n\t\t\tSET category_name = '" . replaceCharacters($providerCategory->getCategoryName()) . "' WHERE id_provider_category = '" . $providerCategory->getIdProviderCategory() . "'"; return DB::query($sql); }