fork(2) download
copy 
  1. <?php
  2.  
  3. $db['default'] = array(
  4.     'dsn'	=> '',
  5.     'hostname' => 'localhost',
  6.     'username' => 'your_username',
  7.     'password' => 'your_password',
  8.     'database' => 'employee_db',
  9.     'dbdriver' => 'mysql',
  10.     'dbprefix' => '',
  11.     'pconnect' => FALSE,
  12.     'db_debug' => TRUE,
  13.     'cache_on' => FALSE,
  14.     'cachedir' => '',
  15.     'char_set' => 'utf8',
  16.     'dbcollat' => 'utf8_general_ci',
  17.     'swap_pre' => '',
  18.     'encrypt' => FALSE,
  19.     'compress' => FALSE,
  20.     'stricton' => FALSE,
  21.     'failover' => array(),
  22.     'save_queries' => TRUE
  23. );
  24. $html = <<<HTML
  25. <div>
  26. <p>This is a paragraph</p>
  27. </div> // Added closing div tag
  28. HTML;
  29. defined('BASEPATH') OR exit('No direct script access allowed');
  30. ?>
  31. class Employee extends CI_Controller {
  32.   public function __construct() {
  33.     parent::__construct();
  34.     $this->load->model('Employee_model');
  35.   }
  36.  
  37.   public function index() {
  38.     $data['employees'] = $this->Employee_model->get_all_employees();
  39.     $this->load->view('employee_list', $data);
  40.   }
  41.  
  42.   public function add() {
  43.     if ($this->input->post()) {
  44.       $data = array(
  45.         'EMPNO' => $this->input->post('empno'),
  46.         'FIRSTNME' => $this->input->post('firstname'),
  47.         'MIDINIT' => $this->input->post('midinit'),
  48.         'LASTNAME' => $this->input->post('lastname'),
  49.         'WORKDEPT' => $this->input->post('workdept')
  50.       );
  51.       $this->Employee_model->add_employee($data);
  52.       redirect('employee');
  53.     } else {
  54.       $this->load->view('employee_add');
  55.     }
  56.   }
  57.  
  58.   public function view($empno) {
  59.     $data['employee'] = $this->Employee_model->get_employee($empno);
  60.     $this->load->view('employee_view', $data);
  61.   }
  62.  
  63.   public function edit($empno) {
  64.     if ($this->input->post()) {
  65.       $data = array(
  66.         'FIRSTNME' => $this->input->post('firstname'),
  67.         'MIDINIT' => $this->input->post('midinit'),
  68.         'LASTNAME' => $this->input->post('lastname'),
  69.         'WORKDEPT' => $this->input->post('workdept')
  70.       );
  71.       $this->Employee_model->update_employee($empno, $data);
  72.       redirect('employee');
  73.     } else {
  74.       $data['employee'] = $this->Employee_model->get_employee($empno);
  75.       $this->load->view('employee_edit', $data);
  76.     }
  77.   }
  78.  
  79.   public function delete($empno) {
  80.     $this->Employee_model->delete_employee($empno);
  81.     redirect('employee');
  82.   }
  83. }
  84. ?>
  85. <?php
  86. echo "<table border='1'>";
  87. echo "<tr>";
  88. echo "<th>EMPNO</th>";
  89. echo "<th>FIRSTNME</th>";
  90. echo "<th>MIDINIT</th>";
  91. echo "<th>LASTNAME</th>";
  92. echo "<th>WORKDEPT</th>";
  93. echo "<th>Action</th>";
  94. echo "</tr>";
  95.  
  96. foreach ($employees as $employee) {
  97.   echo "<tr>";
  98.   echo "<td>" . $employee['EMPNO'] . "</td>";
  99.   echo "<td>" . $employee['FIRSTNME'] . "</td>";
  100.   echo "<td>" . $employee['MIDINIT'] . "</td>";
  101.   echo "<td>" . $employee['LASTNAME'] . "</td>";
  102.   echo "<td>" . $employee['WORKDEPT'] . "</td>";
  103.   echo "<td>";
  104.   echo "<a href='" . site_url('employee/view/' . $employee['EMPNO']) . "'>View</a> | ";
  105.   echo "<a href='" . site_url('employee/edit/' . $employee['EMPNO']) . "'>Edit</a> | ";
  106.   echo "<a href='" . site_url('employee/delete/' . $employee['EMPNO']) . "'>Delete</a>";
  107.   echo "</td>";
  108.   echo "</tr>";
  109. }
  110. echo "</table>";
  111. ?>
  112. <form method="post" action="<?php echo site_url('employee/add'); ?>">
  113.   <label for="empno">EMPNO:</label>
  114.   <input type="text" name="empno" id="empno"><br><br>
  115.  
  116.   <label for="firstname">FIRSTNME:</label>
  117.   <input type="text" name="firstname" id="firstname"><br><br>
  118.  
  119.   <label for="midinit">MIDINIT:</label>
  120.   <input type="text" name="midinit" id="midinit"><br><br>
  121.  
  122.   <label for="lastname">LASTNAME:</label>
  123.   <input type="text" name="lastname" id="lastname"><br><br>
  124.  
  125.   <label for="workdept">WORKDEPT:</label>
  126.   <input type="text" name="workdept" id="workdept"><br><br>
  127.  
  128.   <input type="submit" value="Add Employee">
  129. </form>
  130. <h2>Employee Details</h2>
  131. <p><b>EMPNO:</b> <?php echo $employee['EMPNO']; ?></p>
  132. <p><b>FIRSTNME:</b> <?php echo $employee['FIRSTNME']; ?></p>
  133. <p><b>MIDINIT:</b> <?php echo $employee['MIDINIT']; ?></p>
  134. <p><b>LASTNAME:</b> <?php echo $employee['LASTNAME']; ?></p>
  135. <p><b>WORKDEPT:</b> <?php echo $employee['WORKDEPT']; ?></p>
  136. <form method="post" action="<?php echo site_url('employee/edit/' . $employee['EMPNO']); ?>">
  137.   <label for="firstname">FIRSTNME:</label>
  138.   <input type="text" name="firstname" id="firstname" value="<?php echo $employee['FIRSTNME']; ?>"><br><br>
  139.  
  140.   <label for="midinit">MIDINIT:</label>
  141.   <input type="text" name="midinit" id="midinit" value="<?php echo $employee['MIDINIT']; ?>"><br><br>
  142.  
  143.   <label for="lastname">LASTNAME:</label>
  144.   <input type="text" name="lastname" id="lastname" value="<?php echo $employee['LASTNAME']; ?>"><br><br>
  145.  
  146.   <label for="workdept">WORKDEPT:</label>
  147.   <input type="text" name="workdept" id="workdept" value="<?php echo $employee['WORKDEPT']; ?>"><br><br>
  148.  
  149.   <input type="submit" value="Update Employee">
  150. </form>
  151. $route['employee'] = 'employee';
  152. $autoload['libraries'] = array('database', 'session', 'form_validation');
  153. $autoload['helpers'] = array('url', 'form');
Success #stdin #stdout 0.02s 25356KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
No direct script access allowed
https://ideone.com/qBiuYj
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!