CREATE DATABASE employee_db;
CREATE TABLE EMPLOYEE (
    EMPNO INT NOT NULL PRIMARY KEY,
    FIRSTNME VARCHAR(12) NOT NULL,
    MIDINIT CHAR(1) NOT NULL,
    LASTNAME VARCHAR(15) NOT NULL,
    WORKDEPT CHAR(3)
); 

Q1JFQVRFIERBVEFCQVNFIGVtcGxveWVlX2RiOwpDUkVBVEUgVEFCTEUgRU1QTE9ZRUUgKAogICAgRU1QTk8gSU5UIE5PVCBOVUxMIFBSSU1BUlkgS0VZLAogICAgRklSU1ROTUUgVkFSQ0hBUigxMikgTk9UIE5VTEwsCiAgICBNSURJTklUIENIQVIoMSkgTk9UIE5VTEwsCiAgICBMQVNUTkFNRSBWQVJDSEFSKDE1KSBOT1QgTlVMTCwKICAgIFdPUktERVBUIENIQVIoMykKKTsg

JGRiWydkZWZhdWx0J10gPSBhcnJheSgKICAgICdkc24nCT0mZ3Q7ICcnLAogICAgJ2hvc3RuYW1lJyA9Jmd0OyAnbG9jYWxob3N0JywKICAgICd1c2VybmFtZScgPSZndDsgJ3lvdXJfdXNlcm5hbWUnLAogICAgJ3Bhc3N3b3JkJyA9Jmd0OyAneW91cl9wYXNzd29yZCcsCiAgICAnZGF0YWJhc2UnID0mZ3Q7ICdlbXBsb3llZV9kYicsCiAgICAnZGJkcml2ZXInID0mZ3Q7ICdteXNxbCcsCiAgICAnZGJwcmVmaXgnID0mZ3Q7ICcnLAogICAgJ3Bjb25uZWN0JyA9Jmd0OyBGQUxTRSwKICAgICdkYl9kZWJ1ZycgPSZndDsgVFJVRSwKICAgICdjYWNoZV9vbicgPSZndDsgRkFMU0UsCiAgICAnY2FjaGVkaXInID0mZ3Q7ICcnLAogICAgJ2NoYXJfc2V0JyA9Jmd0OyAndXRmOCcsCiAgICAnZGJjb2xsYXQnID0mZ3Q7ICd1dGY4X2dlbmVyYWxfY2knLAogICAgJ3N3YXBfcHJlJyA9Jmd0OyAnJywKICAgICdlbmNyeXB0JyA9Jmd0OyBGQUxTRSwKICAgICdjb21wcmVzcycgPSZndDsgRkFMU0UsCiAgICAnc3RyaWN0b24nID0mZ3Q7IEZBTFNFLAogICAgJ2ZhaWxvdmVyJyA9Jmd0OyBhcnJheSgpLAogICAgJ3NhdmVfcXVlcmllcycgPSZndDsgVFJVRQopOwoKJmx0Oz9waHAKY2xhc3MgRW1wbG95ZWVfbW9kZWwgZXh0ZW5kcyBDSV9Nb2RlbCB7CiAgcHVibGljIGZ1bmN0aW9uIF9fY29uc3RydWN0KCkgewogICAgcGFyZW50OjpfX2NvbnN0cnVjdCgpOwogICAgJHRoaXMtJmd0O2xvYWQtJmd0O2RhdGFiYXNlKCk7CiAgfQoKICBwdWJsaWMgZnVuY3Rpb24gZ2V0X2FsbF9lbXBsb3llZXMoKSB7CiAgICAkcXVlcnkgPSAkdGhpcy0mZ3Q7ZGItJmd0O2dldCgnRU1QTE9ZRUUnKTsKICAgIHJldHVybiAkcXVlcnktJmd0O3Jlc3VsdF9hcnJheSgpOwogIH0KCiAgcHVibGljIGZ1bmN0aW9uIGdldF9lbXBsb3llZSgkZW1wbm8pIHsKICAgICR0aGlzLSZndDtkYi0mZ3Q7d2hlcmUoJ0VNUE5PJywgJGVtcG5vKTsKICAgICRxdWVyeSA9ICR0aGlzLSZndDtkYi0mZ3Q7Z2V0KCdFTVBMT1lFRScpOwogICAgcmV0dXJuICRxdWVyeS0mZ3Q7cm93X2FycmF5KCk7CiAgfQoKICBwdWJsaWMgZnVuY3Rpb24gYWRkX2VtcGxveWVlKCRkYXRhKSB7CiAgICAkdGhpcy0mZ3Q7ZGItJmd0O2luc2VydCgnRU1QTE9ZRUUnLCAkZGF0YSk7CiAgICByZXR1cm4gJHRoaXMtJmd0O2RiLSZndDtpbnNlcnRfaWQoKTsKICB9CgogIHB1YmxpYyBmdW5jdGlvbiB1cGRhdGVfZW1wbG95ZWUoJGVtcG5vLCAkZGF0YSkgewogICAgJHRoaXMtJmd0O2RiLSZndDt3aGVyZSgnRU1QTk8nLCAkZW1wbm8pOwogICAgJHRoaXMtJmd0O2RiLSZndDt1cGRhdGUoJ0VNUExPWUVFJywgJGRhdGEpOwogIH0KCiAgcHVibGljIGZ1bmN0aW9uIGRlbGV0ZV9lbXBsb3llZSgkZW1wbm8pIHsKICAgICR0aGlzLSZndDtkYi0mZ3Q7d2hlcmUoJ0VNUE5PJywgJGVtcG5vKTsKICAgICR0aGlzLSZndDtkYi0mZ3Q7ZGVsZXRlKCdFTVBMT1lFRScpOwogIH0KfQo/Jmd0OwoKCg==

$db['default'] = array(
    'dsn'	=> '',
    'hostname' => 'localhost',
    'username' => 'your_username',
    'password' => 'your_password',
    'database' => 'employee_db',
    'dbdriver' => 'mysql',
    'dbprefix' => '',
    'pconnect' => FALSE,
    'db_debug' => TRUE,
    'cache_on' => FALSE,
    'cachedir' => '',
    'char_set' => 'utf8',
    'dbcollat' => 'utf8_general_ci',
    'swap_pre' => '',
    'encrypt' => FALSE,
    'compress' => FALSE,
    'stricton' => FALSE,
    'failover' => array(),
    'save_queries' => TRUE
);

<?php
class Employee_model extends CI_Model {
  public function __construct() {
    parent::__construct();
    $this->load->database();
  }

  public function get_all_employees() {
    $query = $this->db->get('EMPLOYEE');
    return $query->result_array();
  }

  public function get_employee($empno) {
    $this->db->where('EMPNO', $empno);
    $query = $this->db->get('EMPLOYEE');
    return $query->row_array();
  }

  public function add_employee($data) {
    $this->db->insert('EMPLOYEE', $data);
    return $this->db->insert_id();
  }

  public function update_employee($empno, $data) {
    $this->db->where('EMPNO', $empno);
    $this->db->update('EMPLOYEE', $data);
  }

  public function delete_employee($empno) {
    $this->db->where('EMPNO', $empno);
    $this->db->delete('EMPLOYEE');
  }
}
?>