public function update(SubCategory $subCategory)
{
$id = $subCategory->getid();
$description = $this->db > quote($subCategory->getDescription());
$name = $this->db > quote(${$subCategory}->getName());
$image = $this->db > quote($subCategory->getImage());
$query = "UPDATE subcategory SET name=" . $name . " description=" . $description . " image=" . $image . " WHERE id=" . $id;
$res = $this->db->query($query);
if ($res) {
return $this->findById($id);
} else {
throw new Exception("internal server error");
}
}
public function create(Category $category, $name, $description, $img)
{
$sub_category = new SubCategory($this->db);
$errors = array();
try {
$sub_category->setCategory($category);
} catch (Exception $e) {
$errors[] = $e->getMessage();
}
try {
$sub_category->setName($name);
} catch (Exception $e) {
$errors[] = $e->getMessage();
}
try {
$sub_category->setDescription($description);
} catch (Exception $e) {
$errors[] = $e->getMessage();
}
try {
$sub_category->setImg($img);
} catch (Exception $e) {
$errors[] = $e->getMessage();
}
if (count($errors) == 0) {
$idCategory = intval($sub_category->getIdCategory());
$name = $this->db->quote($sub_category->getName());
$description = $this->db->quote($sub_category->getDescription());
$img = $this->db->quote($sub_category->getImg());
$query = "INSERT INTO sub_category (id_category, name, description, img) VALUES ('" . $idCategory . "', " . $name . ", " . $description . ", " . $img . ")";
$res = $this->db->exec($query);
if ($res) {
$id = $this->db->lastInsertId();
if ($id) {
return $this->findById($id);
} else {
throw new Exception("Internal server error");
}
}
} else {
return $errors;
}
}
