fork download
copy 
  1. CREATE DATABASE employee_db;
  2. CREATE TABLE EMPLOYEE (
  3.     EMPNO INT NOT NULL PRIMARY KEY,
  4.     FIRSTNME VARCHAR(12) NOT NULL,
  5.     MIDINIT CHAR(1) NOT NULL,
  6.     LASTNAME VARCHAR(15) NOT NULL,
  7.     WORKDEPT CHAR(3)
  8. );
Success #stdin #stdout 0.04s 25388KB
comments (?)
stdin
copy 
$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');
  }
}
?>
<?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');
  }

  public function index() {
    $data['employees'] = $this->Employee_model->get_all_employees();
    $this->load->view('employee_list', $data);
  }

  public function add() {
    if ($this->input->post()) {
      $data = array(
        'EMPNO' => $this->input->post('empno'),
        'FIRSTNME' => $this->input->post('firstname'),
        'MIDINIT' => $this->input->post('midinit'),
        'LASTNAME' => $this->input->post('lastname'),
        'WORKDEPT' => $this->input->post('workdept')
      );
      $this->Employee_model->add_employee($data);
      redirect('employee');
    } else {
      $this->load->view('employee_add');
    }
  }

  public function view($empno) {
    $data['employee'] = $this->Employee_model->get_employee($empno);
    $this->load->view('employee_view', $data);
  }

  public function edit($empno) {
    if ($this->input->post()) {
      $data = array(
        'FIRSTNME' => $this->input->post('firstname'),
        'MIDINIT' => $this->input->post('midinit'),
        'LASTNAME' => $this->input->post('lastname'),
        'WORKDEPT' => $this->input->post('workdept')
      );
      $this->Employee_model->update_employee($empno, $data);
      redirect('employee');
    } else {
      $data['employee'] = $this->Employee_model->get_employee($empno);
      $this->load->view('employee_edit', $data);
    }
  }

  public function delete($empno) {
    $this->Employee_model->delete_employee($empno);
    redirect('employee');
  }
}
?>
<?php
echo "<table border='1'>";
echo "<tr>";
echo "<th>EMPNO</th>";
echo "<th>FIRSTNME</th>";
echo "<th>MIDINIT</th>";
echo "<th>LASTNAME</th>";
echo "<th>WORKDEPT</th>";
echo "<th>Action</th>";
echo "</tr>";

foreach ($employees as $employee) {
  echo "<tr>";
  echo "<td>" . $employee['EMPNO'] . "</td>";
  echo "<td>" . $employee['FIRSTNME'] . "</td>";
  echo "<td>" . $employee['MIDINIT'] . "</td>";
  echo "<td>" . $employee['LASTNAME'] . "</td>";
  echo "<td>" . $employee['WORKDEPT'] . "</td>";
  echo "<td>";
  echo "<a href='" . site_url('employee/view/' . $employee['EMPNO']) . "'>View</a> | ";
  echo "<a href='" . site_url('employee/edit/' . $employee['EMPNO']) . "'>Edit</a> | ";
  echo "<a href='" . site_url('employee/delete/' . $employee['EMPNO']) . "'>Delete</a>";
  echo "</td>";
  echo "</tr>";
}
echo "</table>";
?>
<form method="post" action="<?php echo site_url('employee/add'); ?>">
  <label for="empno">EMPNO:</label>
  <input type="text" name="empno" id="empno"><br><br>

  <label for="firstname">FIRSTNME:</label>
  <input type="text" name="firstname" id="firstname"><br><br>

  <label for="midinit">MIDINIT:</label>
  <input type="text" name="midinit" id="midinit"><br><br>

  <label for="lastname">LASTNAME:</label>
  <input type="text" name="lastname" id="lastname"><br><br>

  <label for="workdept">WORKDEPT:</label>
  <input type="text" name="workdept" id="workdept"><br><br>

  <input type="submit" value="Add Employee">
</form>
<h2>Employee Details</h2>
<p><b>EMPNO:</b> <?php echo $employee['EMPNO']; ?></p>
<p><b>FIRSTNME:</b> <?php echo $employee['FIRSTNME']; ?></p>
<p><b>MIDINIT:</b> <?php echo $employee['MIDINIT']; ?></p>
<p><b>LASTNAME:</b> <?php echo $employee['LASTNAME']; ?></p>
<p><b>WORKDEPT:</b> <?php echo $employee['WORKDEPT']; ?></p>
<form method="post" action="<?php echo site_url('employee/edit/' . $employee['EMPNO']); ?>">
  <label for="firstname">FIRSTNME:</label>
  <input type="text" name="firstname" id="firstname" value="<?php echo $employee['FIRSTNME']; ?>"><br><br>

  <label for="midinit">MIDINIT:</label>
  <input type="text" name="midinit" id="midinit" value="<?php echo $employee['MIDINIT']; ?>"><br><br>

  <label for="lastname">LASTNAME:</label>
  <input type="text" name="lastname" id="lastname" value="<?php echo $employee['LASTNAME']; ?>"><br><br>

  <label for="workdept">WORKDEPT:</label>
  <input type="text" name="workdept" id="workdept" value="<?php echo $employee['WORKDEPT']; ?>"><br><br>

  <input type="submit" value="Update Employee">
</form>
$route['employee'] = 'employee';
$autoload['libraries'] = array('database', 'session', 'form_validation');
$autoload['helpers'] = array('url', 'form');
stdout
copy 
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)
);
https://ideone.com/laNmzt
test
language:
PHP (php 7.3.5)
created:
1 day ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!