Willy23

mahasiswam (model)

May 18th, 2016
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.18 KB | None | 0 0
  1. <?php
  2. class mahasiswam extends CI_Model{
  3. private $tblmahasiswa = 'tbl_mahasiswa';
  4. public function __construct(){
  5. parent::__construct();
  6. }
  7.  
  8. public function ambilsemua(){
  9. $query = $this->db->get('tbl_mahasiswa');
  10. return $query->result();
  11. }
  12.  
  13. public function get_all(){
  14. //$query = $this->db->get($this->table);
  15. $this->db->select('*')
  16. ->from('tbl_mahasiswa a')
  17. ->join('tbl_agama b','b.agama_id = a.agama_id')
  18. ->join('tbl_prodi c','c.prodi_id = a.prodi_id');
  19. $query = $this->db->get();
  20. return $query->result();
  21. }
  22.  
  23. public function count_rows(){
  24. $query = $this->db->count_all_results($this->tblmahasiswa);
  25. return $query;
  26. }
  27. public function simpanmahasiswa($data) {
  28. $this->db->insert('tbl_mahasiswa',$data); }
  29.  
  30. public function cari($id){
  31. $this->db->select('*')
  32. ->from('tbl_mahasiswa a')
  33. ->join('tbl_agama b','b.agama_id = a.agama_id')
  34. ->join('tbl_prodi c','c.prodi_id = a.prodi_id')
  35. ->where('a.mahasiswa_id = ', $id);
  36. $query = $this->db->get();
  37. return $query->row();
  38. }
  39.  
  40. public function editdata($data, $id){
  41. $this->db->where('mahasiswa_id', $id);
  42. $this->db->update('tbl_mahasiswa', $data);
  43. }
  44. public function hapus($id){
  45. $this->db->where('mahasiswa_id', $id);
  46. $this->db->delete('tbl_mahasiswa');
  47. }
  48.  
  49. public function search($keyword)
  50. {
  51. $this->db->LIKE('namamahasiswa',$keyword);
  52. $query=$this->db->get('tbl_mahasiswa');
  53. return $query->result();
  54. }
  55.  
  56. public function validation() {
  57. $this->load->library('form_validation');
  58. $this->form_validation->set_rules('namamahasiswa','Nama Mahasiswa','required');
  59. $this->form_validation->set_rules('tempatlahir','Tempat Lahir','required');
  60. $this->form_validation->set_rules('alamat','Alamat','required');
  61. $this->form_validation->set_rules('hobi','Hobi','required');
  62. $this->form_validation->set_rules('notelp','No.Telepon','required|numeric|min_length[10]|max_length[12]');
  63. if ($this->form_validation->run() == FALSE) {
  64. return FALSE;}
  65. else {
  66. return TRUE;
  67. }
  68. }
  69.  
  70. }
  71. ?>
Advertisement
Add Comment
Please, Sign In to add comment