import_member_model

<?php
 class Import_member_model extends CI_Model {

   private $db_import = null;

   function __construct() {
      parent::__construct();
      $this->db_import = $this->load->database('import',TRUE);
   }

   function pegawai_l()
   {
      /*
      $query  = "SELECT COUNT(cid_jenis_kelamin) as 'pegawai_l' FROM pegawai WHERE `cid_jenis_kelamin`='l'";
      $result = $this->db_import->query($query);
      return $result->row_array();
       *
       */
      $query = $this->db_import->query('SELECT COUNT(cid_jenis_kelamin) as pegawai_l FROM pegawai WHERE cid_jenis_kelamin="l"');
      $result = $query->result();
      return $result[0]->pegawai_l;
      //return $result->result();
      /*
      $results = array();
        $this->db_import->select('COUNT(cid_jenis_kelamin) as pegawai_l')
                ->from('siswa')
                ->where('cid_jenis_kelamin', "l");

        $results['pegawai_l'] = $this->db_import->get();
        return $results->row_array()->pegawai_l;
        */
   }

   function pegawai_p()
   {
      $query = $this->db_import->query('SELECT COUNT(cid_jenis_kelamin) as pegawai_p FROM pegawai WHERE cid_jenis_kelamin="p"');
      $result = $query->result();
      return $result[0]->pegawai_p;
   }

   function siswa_l()
   {

      $query = $this->db_import->query('SELECT COUNT(cid_jenis_kelamin) as siswa_l FROM siswa WHERE cid_jenis_kelamin="l"');
      $result = $query->result();
      return $result[0]->siswa_l;
   }

   function siswa_p()
   {
      $query = $this->db_import->query('SELECT COUNT(cid_jenis_kelamin) as siswa_p FROM siswa WHERE cid_jenis_kelamin="p"');
      $result = $query->result();
      return $result[0]->siswa_p;
   }
}