1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / new_bank_loan / application / models /
Filename : Common_model.php
back
<?php
class Common_model extends CI_Model
{
	public function insert($sTableName = NULL, $aData = array()){
		if(!empty($sTableName) AND !empty($aData)){
			$aData = security_methods($aData);

			$this->db->insert( $sTableName , $aData );
			return $this->db->insert_id();
		}else{
			return false;
		}
	}
	
	public function update($sTableName = NULL, $aData = array(), $aWhere = array()){
		if(!empty($sTableName) AND !empty($aData) AND !empty($aWhere)){
			$aData = security_methods($aData);
			
			$this->db->where( $aWhere );
			return $this->db->update( $sTableName , $aData );
		}else{
			return false;
		}
	}

	public function delete($sTableName = NULL, $aWhere = array()){
		if(!empty($sTableName) AND !empty($aWhere)){
			$this->db->where($aWhere);
			return $this->db->delete($sTableName);
		}else{
			return false;
		}
	}
	
	public function getRow($sTableName = NULL, $aWhere = array()){
		$this->db->select('*');
		if(!empty($aWhere)){
			foreach($aWhere as $key => $row){
				$this->db->where($key,$row);
			}
		}
		$result = $this->db->get($sTableName)->row();
		
		return pdpadecryptdata($result);
	}
	
	public function getRowArray($sTableName = NULL, $aWhere = array()){
		$this->db->select('*');
		if(!empty($aWhere)){
			foreach($aWhere as $key => $row){
				$this->db->where($key,$row);
			}
		}
		$result = $this->db->get($sTableName)->row_array();
		
		return pdpadecryptdata($result);
	}
	
	public function getResult($sTableName = NULL, $aWhere = array(),$columName = NULL,$columOrder = NULL){
		$this->db->select('*');
		if(!empty($aWhere)){
			foreach($aWhere as $key => $row){
				$this->db->where($key,$row);
			}
		}
		if((!empty($columName)) && (!empty($columOrder))){
			$this->db->order_by($columName,$columOrder);
		}
		$result = $this->db->get($sTableName)->result();
		
		return pdpadecryptdata_multi_array($result);
	}
	
	public function getResultArray($sTableName = NULL, $aWhere = array()){
		$this->db->select('*');
		if(!empty($aWhere)){
			foreach($aWhere as $key => $row){
				$this->db->where($key,$row);
			}
		}
		$result = $this->db->get($sTableName)->result_array();
		
		return pdpadecryptdata_multi_array($result);
	}
}