Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- class mahasiswam extends CI_Model{
- private $tblmahasiswa = 'tbl_mahasiswa';
- public function __construct(){
- parent::__construct();
- }
- public function ambilsemua(){
- $query = $this->db->get('tbl_mahasiswa');
- return $query->result();
- }
- public function get_all(){
- //$query = $this->db->get($this->table);
- $this->db->select('*')
- ->from('tbl_mahasiswa a')
- ->join('tbl_agama b','b.agama_id = a.agama_id')
- ->join('tbl_prodi c','c.prodi_id = a.prodi_id');
- $query = $this->db->get();
- return $query->result();
- }
- public function count_rows(){
- $query = $this->db->count_all_results($this->tblmahasiswa);
- return $query;
- }
- public function simpanmahasiswa($data) {
- $this->db->insert('tbl_mahasiswa',$data); }
- public function cari($id){
- $this->db->select('*')
- ->from('tbl_mahasiswa a')
- ->join('tbl_agama b','b.agama_id = a.agama_id')
- ->join('tbl_prodi c','c.prodi_id = a.prodi_id')
- ->where('a.mahasiswa_id = ', $id);
- $query = $this->db->get();
- return $query->row();
- }
- public function editdata($data, $id){
- $this->db->where('mahasiswa_id', $id);
- $this->db->update('tbl_mahasiswa', $data);
- }
- public function hapus($id){
- $this->db->where('mahasiswa_id', $id);
- $this->db->delete('tbl_mahasiswa');
- }
- public function search($keyword)
- {
- $this->db->LIKE('namamahasiswa',$keyword);
- $query=$this->db->get('tbl_mahasiswa');
- return $query->result();
- }
- public function validation() {
- $this->load->library('form_validation');
- $this->form_validation->set_rules('namamahasiswa','Nama Mahasiswa','required');
- $this->form_validation->set_rules('tempatlahir','Tempat Lahir','required');
- $this->form_validation->set_rules('alamat','Alamat','required');
- $this->form_validation->set_rules('hobi','Hobi','required');
- $this->form_validation->set_rules('notelp','No.Telepon','required|numeric|min_length[10]|max_length[12]');
- if ($this->form_validation->run() == FALSE) {
- return FALSE;}
- else {
- return TRUE;
- }
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment