LaCReMeL adlı üyeden alıntı: mesajı görüntüle
Kodun tamamini paylasirsan daha saglikli olur.
//controller
$kategori1 ="mobilya";
$kategori2 ="giyim";
$category_name1 = array();
$category_name1[] =$kategori1;
$category_name1[] =$kategori2;
foreach($category_name1 as $category_name){} 
$kategori_id = $this->model_module_entegrasyon->getCategoryID($category_name);

//Model
public function getCategoryID($category_name) {
		$query=$this->db->query("SELECT category_id FROM " .DB_PREFIX . "category_description  WHERE name='".$category_name."' LIMIT 1")->row;
		if (!isset($query["category_id"])){ 
			$this->db->query("INSERT INTO " .DB_PREFIX . "category VALUES ('','', '0', '1', '3', '', '1', NOW(), NOW())");
			$category_id=$this->db->getLastId();
			$this->db->query("INSERT INTO " .DB_PREFIX . "category_description VALUES ('$category_id','1', '".$category_name."', '', '".$category_name."','','')");

			$this->db->query("INSERT INTO " .DB_PREFIX . "category_to_store VALUES ('$category_id','0')");

		}
		else {$category_id=$query["category_id"];}
		return $category_id;
	}