DAFTAR PUSTAKA
Anhar.2010. Panduan Menguasai PHP & MySQL Secara Otodidak. Mediakita : Jakarta Basuki Awan Pribadi.2010. Membangun Web Berbasis PHP dengan Framework Codeigniter.Penerbit Lokomedia Yogyakarta Dennis, A., Wixom, B. H., & Roth, R. M. (2012). System Analysis & Design 5th Edition. Amerika: John Wiley & Sons, Inc. Fandi Setyo Prambudi,et.al.2010. Sistem Informasi Monitoring Siswa Bermasalah Berbasis Web dan SMS Gateway (Studi Kasus : SMA Negeri 2 Trenggalek).Surabaya. Hidayat, Rahmat. (2010). Cara Praktis Membangun Website Gratis : Pengertian Website. Jakarta : PT Elex Media Komputindo Kompas,Gramedia Hakim, Lukmanul.2010. Membangun Web Berbasis PHP Dengan Framework CodeIgniter. Lokomedia: Yogyakarta Mujahidin dan Nyoman Dita.P.P 2010. Rancang Bangun Sistem Informasu Monitoring Mulyanto, Agus. Sistem Informasi Konsep & Aplikasi. Yogyakarta : Pustaka Pelajar Poerwadarminta. 2006. Kamus Umum Bahasa Indonesia. Edisi Ketiga. Jakarta : Balai Pustaka Rosa dan salahudin. 2013. Rekayasa Perangkat Lunak. Bandung. informatika Sutabri, Tata. 2012. Konsep Dasar Informasi. Yogyakarta: Andi Sangweni,Stan S.2008. Basic Concept in Monitoring and Evaluation.South Africa: THE PUBLIC SERVICE COMMNISSION (PSC) Whitten JL, Bentley LD, Dittman KC.2007. Metode Desain dan Analisis Sistem edisi 6. Andi. Terjemahan dari system analysis and Design Method. Yogyakarta
http://digilib.mercubuana.ac.id/
Sorce Code Database.php
Routes.php
$active_group = 'default';
$route['default_controller'] = 'login';
$query_builder = TRUE;
$route['404_override'] = '';
$db['default'] = array(
$route['translate_uri_dashes'] = FALSE;
'dsn'
=> '',
'hostname' => 'localhost', 'username' => 'root',
Crud_model.php
'password' => '',
'database' => 'suray',
if (!defined('BASEPATH'))
'dbdriver' => 'mysqli',
exit('No direct script access allowed');
'dbprefix' => '',
class Crud_model extends CI_Model {
'pconnect' => FALSE,
function __construct() {
'db_debug' => TRUE,
parent::__construct();
'cache_on' => FALSE,
}
'cachedir' => '',
function clear_cache() {
'char_set' => 'utf8',
$this->output->set_header('Cache-Control: nostore, no-cache, must-revalidate, post-check=0,
'dbcollat' => 'utf8_general_ci', 'swap_pre' => '', 'encrypt' => FALSE,
pre-check=0'); $this->output->set_header('Pragma: no-cache'); }
'compress' => FALSE, 'stricton' => FALSE, 'failover' => array(),
function get_type_name_by_id($type, $type_id = '', $field = 'name') {
'save_queries' => TRUE );
http://digilib.mercubuana.ac.id/
return $this->db->get_where($type, array($type . '_id' => $type_id))->row()->$field; }
} function get_teacher_info($teacher_id) { $query = $this->db->get_where('teacher',
////////STUDENT/////////////
array('teacher_id' => $teacher_id));
function get_students($class_id) {
return $query->result_array();
$query = $this->db->get_where('student',
}
array('class_id' => $class_id));
//////////SUBJECT/////////////
return $query->result_array();
function get_subjects() {
}
$query = $this->db->get('subject');
function get_student_info($student_id) { $query = $this->db->get_where('student',
return $query->result_array(); }
array('student_id' => $student_id)); function get_subject_info($subject_id) { return $query->result_array(); $query = $this->db->get_where('subject', }
array('subject_id' => $subject_id));
/////////TEACHER/////////////
return $query->result_array();
function get_teachers() {
}
$query = $this->db->get('teacher'); return $query->result_array();
function get_subjects_by_class($class_id) { $query = $this->db->get_where('subject',
}
array('class_id' => $class_id));
function get_teacher_name($teacher_id) {
return $query->result_array();
$query = $this->db->get_where('teacher',
}
array('teacher_id' => $teacher_id)); $res = $query->result_array(); foreach ($res as $row) return $row['name'];
function get_subject_name_by_id($subject_id) { $query = $this->db->get_where('subject', array('subject_id' => $subject_id))->row();
http://digilib.mercubuana.ac.id/
return $query->name;
