application/
├── controllers/
│   └── Employee.php
├── models/
│   └── Employee_model.php
├── views/
│   ├── employee_list.php
│   ├── employee_add.php
│   ├── employee_delete.php
│   └── employee_view.php  (Optional - for viewing details)
 
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
 
class Employee extends CI_Controller {
 
    public function __construct() {
        parent::__construct();
        $this->load->model('Employee_model'); // Load the model
    }
 
    public function index() {
        $data['employees'] = $this->Employee_model->get_all_employees();
        $this->load->view('employee_list', $data);
    }
 
    public function add() {
        if ($this->input->post()) {
            $this->Employee_model->add_employee($this->input->post());
            redirect('employee'); // Redirect to the employee list
        }
        $this->load->view('employee_add');
    }
 
    public function delete($empno) {
        $this->Employee_model->delete_employee($empno);
        redirect('employee');
    }
    //Optional View Function
    public function view($empno){
        $data['employee'] = $this->Employee_model->get_employee($empno);
        $this->load->view('employee_view', $data);
    }
 
}

YXBwbGljYXRpb24vCuKUnOKUgOKUgCBjb250cm9sbGVycy8K4pSCICAg4pSU4pSA4pSAIEVtcGxveWVlLnBocArilJzilIDilIAgbW9kZWxzLwrilIIgICDilJTilIDilIAgRW1wbG95ZWVfbW9kZWwucGhwCuKUnOKUgOKUgCB2aWV3cy8K4pSCICAg4pSc4pSA4pSAIGVtcGxveWVlX2xpc3QucGhwCuKUgiAgIOKUnOKUgOKUgCBlbXBsb3llZV9hZGQucGhwCuKUgiAgIOKUnOKUgOKUgCBlbXBsb3llZV9kZWxldGUucGhwCuKUgiAgIOKUlOKUgOKUgCBlbXBsb3llZV92aWV3LnBocCAgKE9wdGlvbmFsIC0gZm9yIHZpZXdpbmcgZGV0YWlscykKCjw/cGhwCmRlZmluZWQoJ0JBU0VQQVRIJykgT1IgZXhpdCgnTm8gZGlyZWN0IHNjcmlwdCBhY2Nlc3MgYWxsb3dlZCcpOwoKY2xhc3MgRW1wbG95ZWUgZXh0ZW5kcyBDSV9Db250cm9sbGVyIHsKCiAgICBwdWJsaWMgZnVuY3Rpb24gX19jb25zdHJ1Y3QoKSB7CiAgICAgICAgcGFyZW50OjpfX2NvbnN0cnVjdCgpOwogICAgICAgICR0aGlzLT5sb2FkLT5tb2RlbCgnRW1wbG95ZWVfbW9kZWwnKTsgLy8gTG9hZCB0aGUgbW9kZWwKICAgIH0KCiAgICBwdWJsaWMgZnVuY3Rpb24gaW5kZXgoKSB7CiAgICAgICAgJGRhdGFbJ2VtcGxveWVlcyddID0gJHRoaXMtPkVtcGxveWVlX21vZGVsLT5nZXRfYWxsX2VtcGxveWVlcygpOwogICAgICAgICR0aGlzLT5sb2FkLT52aWV3KCdlbXBsb3llZV9saXN0JywgJGRhdGEpOwogICAgfQoKICAgIHB1YmxpYyBmdW5jdGlvbiBhZGQoKSB7CiAgICAgICAgaWYgKCR0aGlzLT5pbnB1dC0+cG9zdCgpKSB7CiAgICAgICAgICAgICR0aGlzLT5FbXBsb3llZV9tb2RlbC0+YWRkX2VtcGxveWVlKCR0aGlzLT5pbnB1dC0+cG9zdCgpKTsKICAgICAgICAgICAgcmVkaXJlY3QoJ2VtcGxveWVlJyk7IC8vIFJlZGlyZWN0IHRvIHRoZSBlbXBsb3llZSBsaXN0CiAgICAgICAgfQogICAgICAgICR0aGlzLT5sb2FkLT52aWV3KCdlbXBsb3llZV9hZGQnKTsKICAgIH0KCiAgICBwdWJsaWMgZnVuY3Rpb24gZGVsZXRlKCRlbXBubykgewogICAgICAgICR0aGlzLT5FbXBsb3llZV9tb2RlbC0+ZGVsZXRlX2VtcGxveWVlKCRlbXBubyk7CiAgICAgICAgcmVkaXJlY3QoJ2VtcGxveWVlJyk7CiAgICB9CiAgICAvL09wdGlvbmFsIFZpZXcgRnVuY3Rpb24KICAgIHB1YmxpYyBmdW5jdGlvbiB2aWV3KCRlbXBubyl7CiAgICAgICAgJGRhdGFbJ2VtcGxveWVlJ10gPSAkdGhpcy0+RW1wbG95ZWVfbW9kZWwtPmdldF9lbXBsb3llZSgkZW1wbm8pOwogICAgICAgICR0aGlzLT5sb2FkLT52aWV3KCdlbXBsb3llZV92aWV3JywgJGRhdGEpOwogICAgfQoKfQ==

LS0gQ3JlYXRlIHRoZSBkYXRhYmFzZQpDUkVBVEUgREFUQUJBU0UgSUYgTk9UIEVYSVNUUyBlbXBsb3llZV9kYjsKCi0tIFVzZSB0aGUgZGF0YWJhc2UKVVNFIGVtcGxveWVlX2RiOwoKLS0gQ3JlYXRlIHRoZSBFTVBMT1lFRSB0YWJsZQpDUkVBVEUgVEFCTEUgRU1QTE9ZRUUgKAogICAgRU1QTk8gSU5UIE5PVCBOVUxMLAogICAgRklSU1ROTUUgVkFSQ0hBUigxMikgTk9UIE5VTEwsCiAgICBNSURJTklUIENIQVIoMSkgTk9UIE5VTEwsCiAgICBMQVNUTkFNRSBWQVJDSEFSKDE1KSBOT1QgTlVMTCwKICAgIFdPUktERVBUIENIQVIoMyksCiAgICBQUklNQVJZIEtFWSAoRU1QTk8pCik7

-- Create the database
CREATE DATABASE IF NOT EXISTS employee_db;

-- Use the database
USE employee_db;

-- Create the EMPLOYEE table
CREATE TABLE EMPLOYEE (
    EMPNO INT NOT NULL,
    FIRSTNME VARCHAR(12) NOT NULL,
    MIDINIT CHAR(1) NOT NULL,
    LASTNAME VARCHAR(15) NOT NULL,
    WORKDEPT CHAR(3),
    PRIMARY KEY (EMPNO)
);