Advertisement
anjhar

import_member_model

Nov 27th, 2014
207
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.22 KB | None | 0 0
  1. <?php
  2. class Import_member_model extends CI_Model {
  3.  
  4. private $db_import = null;
  5. //var $db_forum;
  6. /**
  7. * Construct
  8. *
  9. * @return void
  10. */
  11. function __construct() {
  12. parent::__construct();
  13. $this->db_import = $this->load->database('import',TRUE);
  14. }
  15.  
  16. function pegawai_l()
  17. {
  18. $query = "SELECT COUNT(cid_jenis_kelamin) as 'pegawai_l' FROM pegawai WHERE `cid_jenis_kelamin`='l';";
  19. $result = $this->db_import->query($query);
  20. return $result->row_array();
  21. //return $result->result();
  22. /*
  23. $results = array();
  24. $this->db_import->select('COUNT(cid_jenis_kelamin) as pegawai_l')
  25. ->from('siswa')
  26. ->where('cid_jenis_kelamin', "l");
  27.  
  28. $results['pegawai_l'] = $this->db_import->get();
  29. return $results->row_array()->pegawai_l;
  30. */
  31. }
  32.  
  33. function pegawai_p()
  34. {
  35.  
  36. $query = "SELECT COUNT(cid_jenis_kelamin) as 'pegawai_p' FROM pegawai WHERE cid_jenis_kelamin='p'; ";
  37. $result = $this->db_import->query($query);
  38. return $result->row_array();
  39. // return $result->row_array();
  40. /*
  41. $results = array();
  42. $this->db_import->select('COUNT(cid_jenis_kelamin) as pegawai_p')
  43. ->from('pegawai')
  44. ->where('cid_jenis_kelamin', "p");
  45.  
  46. $results['pegawai_p'] = $this->db_import->get()->row()->pegawai_p;
  47. */
  48. }
  49.  
  50. function siswa_l()
  51. {
  52.  
  53. $query = "SELECT COUNT(cid_jenis_kelamin) as 'siswa_l' FROM siswa WHERE cid_jenis_kelamin='l'; ";
  54. $result = $this->db_import->query($query);
  55. return $result->row_array();
  56. //return $result->row_array();
  57. /*
  58. $results = array();
  59. $this->db_import->select('COUNT(cid_jenis_kelamin) as siswa_l')
  60. ->from('siswa')
  61. ->where('cid_jenis_kelamin', "");
  62.  
  63. $results['siswa_l'] = $this->db_import->get()->row()->siswa_l;
  64. */
  65. }
  66.  
  67. function siswa_p()
  68. {
  69.  
  70. $query = "SELECT COUNT(cid_jenis_kelamin) as 'siswa_p' FROM siswa WHERE cid_jenis_kelamin='p'; ";
  71. $result = $this->db_import->query($query);
  72. return $result->row_array();
  73. }
  74. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement