/home/hdwebsolution/www/sareen-1/application/models/Insert_model.php
<?php
class Insert_model extends CI_Model{
	public function query_insert($table,$array){
	   $q=$this->db->insert($table,$array);			               			 
	}
   public function alearady_exitquery_insert($table,$where,$array){
	   $q=$this->db->select('*')->where($where) ->get($table);	
		            if(!$q->num_rows()){
						$q=$this->db->insert($table,$array);
					} else {
						return False;
					}
	}
    public function addcsvfile($table){
		
		
				$count=0;
				$fp = fopen($_FILES['csv']['tmp_name'],'r') or die("can't open file");
				while($csv_line = fgetcsv($fp,1024))
				{
					$count++;
					if($count == 1)
					{
						continue;
					}//keep this if condition if you want to remove the first row
					for($i = 0, $j = count($csv_line); $i < $j; $i++)
					{
						$insert_csv = array();
						$insert_csv['area'] = $csv_line[0];//remove if you want to have primary key,
						$insert_csv['pincode'] = $csv_line[2];
						$insert_csv['district'] = $csv_line[5];
						$insert_csv['state'] = $csv_line[6];

					}
					$i++;
					$array = array(
						'area' => $insert_csv['area'] ,
						'pincode' => $insert_csv['pincode'],
						'district' => $insert_csv['district'],
						'state' => $insert_csv['state']);
						 $q=$this->db->insert('tbl_location',$array);	
				}
				fclose($fp) or die("can't close file");
				$data['success']="success";
				return $data;
			
	}	
	
	public function registration($table,$where,$array){
	   $q=$this->db->select('*')->where($where)->get($table);
		            if(!$q->num_rows()){
						$q=$this->db->insert($table,$array);
					} else {
						return False;
					}
	}     
}	
?>