private function _insert() { $dateNow = date('Y-m-d H:i:s', time()); $sql = ' INSERT INTO animals (category, subcategory, name, description, eat, date_created) VALUES (:category, :subcategory, :name, :description, :eat, :date_created) '; $params = array('category' => $this->_category, 'subcategory' => $this->_subcategory, 'name' => $this->_name, 'description' => $this->_description, 'eat' => $this->_eat, 'date_created' => $dateNow); self::$db->prepare($sql, $params)->execute(); if (self::$db->getAffectedRows() > 0) { $this->id = self::$db->getLastInsertId(); $animal = new \models\Animal($this->id); if ($animal->setId($this->id)->save()) { return true; } } }
/** * White information from XML files to database */ public function writeXMLInDB() { if ($this->isDerectory()) { $dirTree = $this->getXMLPaths($this->_dir_path); foreach ($dirTree as $value) { $xml_content = simplexml_load_file($value); foreach ($xml_content as $key => $value) { $is_exist = \models\Animal::getAnimals(array('name' => $value->name)); if ($is_exist) { //update $animal_id = key($is_exist); $animal = new \models\Animal($animal_id); $animal->setCategory($value->category); $animal->setSubcategory($value->subcategory); $animal->setName($value->name); $animal->setDescription($value->description); $animal->setEat($value->eat); $animal->save(); } else { //new animal $animal = new \models\Animal(); $animal->setCategory($value->category); $animal->setSubcategory($value->subcategory); $animal->setName($value->name); $animal->setDescription($value->description); $animal->setEat($value->eat); $animal->save(); } } } } }