53 lines
2.1 KiB
PHP
53 lines
2.1 KiB
PHP
<?php
|
|
class M_guru extends CI_Model{
|
|
|
|
function get_all_guru(){
|
|
$hsl=$this->db->query("SELECT * FROM tbl_guru");
|
|
return $hsl;
|
|
}
|
|
|
|
function simpan_guru($nik,$nama,$jenkel,$tmp_lahir,$tgl_lahir,$mapel,$photo){
|
|
$hsl=$this->db->query("INSERT INTO tbl_guru (guru_nik,guru_nama,guru_jenkel,guru_tmp_lahir,guru_tgl_lahir,guru_mapel,guru_photo) VALUES ('$nik','$nama','$jenkel','$tmp_lahir','$tgl_lahir','$mapel','$photo')");
|
|
return $hsl;
|
|
}
|
|
function simpan_guru_tanpa_img($nik,$nama,$jenkel,$tmp_lahir,$tgl_lahir,$mapel){
|
|
$hsl=$this->db->query("INSERT INTO tbl_guru (guru_nik,guru_nama,guru_jenkel,guru_tmp_lahir,guru_tgl_lahir,guru_mapel) VALUES ('$nik','$nama','$jenkel','$tmp_lahir','$tgl_lahir','$mapel')");
|
|
return $hsl;
|
|
}
|
|
|
|
function update_guru($kode,$nik,$nama,$jenkel,$tmp_lahir,$tgl_lahir,$mapel,$photo){
|
|
$hsl=$this->db->query("UPDATE tbl_guru SET guru_nik='$nik',guru_nama='$nama',guru_jenkel='$jenkel',guru_tmp_lahir='$tmp_lahir',guru_tgl_lahir='$tgl_lahir',guru_mapel='$mapel',guru_photo='$photo' WHERE guru_id='$kode'");
|
|
return $hsl;
|
|
}
|
|
function update_guru_tanpa_img($kode,$nik,$nama,$jenkel,$tmp_lahir,$tgl_lahir,$mapel){
|
|
$hsl=$this->db->query("UPDATE tbl_guru SET guru_nik='$nik',guru_nama='$nama',guru_jenkel='$jenkel',guru_tmp_lahir='$tmp_lahir',guru_tgl_lahir='$tgl_lahir',guru_mapel='$mapel' WHERE guru_id='$kode'");
|
|
return $hsl;
|
|
}
|
|
function hapus_guru($kode){
|
|
$hsl=$this->db->query("DELETE FROM tbl_guru WHERE guru_id='$kode'");
|
|
return $hsl;
|
|
}
|
|
|
|
//front-end
|
|
function guru(){
|
|
$hsl=$this->db->query("SELECT * FROM tbl_guru");
|
|
return $hsl;
|
|
}
|
|
function guru_perpage($offset,$limit){
|
|
$hsl=$this->db->query("SELECT * FROM tbl_guru limit $offset,$limit");
|
|
return $hsl;
|
|
}
|
|
|
|
// e-learning
|
|
function get_guru_id($username) {
|
|
return $this->db->query("SELECT pengguna_guru FROM tbl_pengguna WHERE pengguna_username='$username'");
|
|
}
|
|
|
|
function get_guru($id) {
|
|
return $this->db->query("SELECT * FROM tbl_guru WHERE guru_id='$id'");
|
|
}
|
|
|
|
function get_guru_kelas($id) {
|
|
return $this->db->query("SELECT ajar_kelas_id FROM tbl_ajar WHERE ajar_guru_id='$id'");
|
|
}
|
|
} |