public function update(Brand $brand, $errors = array()) { $id = $brand->getId(); $name = $this->db->quote($brand->getName()); $description = $this->db->quote($brand->getDescription()); $query = "UPDATE brand SET name = " . $name . ", description = " . $description . "WHERE id = " . $id; $data = $this->db->exec($query); if ($data) { $id = $this->db->lastInsertId(); if ($id) { try { $brand = $this->findByid($id); return $brand; } catch (Exception $e) { $errors[] = $e->getMessage(); return $errors; } } else { throw new Exception('Last insert error'); } } else { throw new Exception('Update error'); } }
/** * @param $name * @param $description * @param array $errors * @return object * @throws Exception */ public function create($name, $description, $errors = array()) { $category = new Brand($this->db); try { $category->setName($name); } catch (Exception $e) { $errors[] = $e->getMessage(); } try { $category->setDescription($description); } catch (Exception $e) { $errors[] = $e->getMessage(); } if (count($errors) == 0) { $name = $this->db->quote($category->getName()); $description = $this->db->quote($category->getDescription()); $query = "INSERT INTO category (name, description) VALUES(" . $name . ", " . $description . ")"; $data = $this->db->exec($query); if ($data) { $id = $this->db->lastInsertId(); if ($id) { try { $category = $this->findById($id); return $category; } catch (Exception $e) { $errors[] = $e->getMessage(); return $errors; } } else { throw new Exception('Last insert error'); } } else { throw new Exception('Insert error'); } } else { return $errors; } }