Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement