[eluser]crispinatari[/eluser]
Thnaks for the reply!! does that mean i have to make a new column in my table called employeeID_Origin?
so here is the form view: does this mean i do this to the form?
Code:
<html>
<head>
<title><?=$title?></title>
<link rel="stylesheet" type="text/css" href="employee.css" />
</head>
<body>
<h1></h1>
<h3>Edit Employee Details</h3>
<form action="http://localhost/ci1/index.php/emps/update_emp" method="post">
<?//or using form helper //=form_open('blog/insertentry');?>
<?php if($query->num_rows()==1):?>
<?php foreach($query->result() as $row):?>
<p>Employee ID_Origin:<br><input type='text' value=<?=$row->employeeID_Origin;?> name='employeeID_Origin'></p>
<p>Employee ID:<br><input type='text' value=<?=$row->employeeID;?> name='employeeID'></p>
<p>Department ID:<br><input type='text' value=<?=$row->departmentID;?> name='departmentID'></p>
<p>First Name:<br><input type='text' value=<?=$row->first_name;?> name='first_name'></p>
<p>Last Name:<br><input type='text' value=<?=$row->last_name;?> name='last_name'></p>
<?php endforeach;?>
<p><input type='submit' value='update' ></p>
<?php else:?>
<?php echo"error";?>
<?php endif;?>
</form>
</body>
</html>
and list view:
Code:
<html>
<head>
<title>Display All Employees</title>
</head>
<body>
<center>
<form action="http://localhost/ci1/index.php/home/index" name="button2" align="left">
<INPUT type="submit" value="Back to Home"/>
</form>
<br>
<form action="http://localhost/ci1/index.php/side_menu/emps_add_page" name="button1" align="right">
<INPUT type="submit" value="Add Employee"/><br>
</form>
</center>
<br>
<?//if using url helper//=anchor('emps/addemp','Add Employee');?>
<table class="emps" width="57%" border="1" cellspacing="0" cellpadding="0" align="center">
<tr>
<th>Employee ID</th>
<th>Department ID</th>
<th>Employee First Name</th>
<th>Employee Last Name</th>
</tr>
<?php foreach($res as $row): ?>
<tr>
<td class="employeeID"><?=$row->employeeID?></td>
<td><?=$row->departmentID?></td>
<td ><?=$row->first_name?></td>
<td ><?=$row->last_name?></td>
<td><?=anchor('emps/editemp/'.$row->employeeID,'Edit');?></td>
<td><?=anchor('emps/deleteemp/'.$row->employeeID,'Delete');?></td>
</tr>
<?php endforeach; ?>
</table>
</div>
<br><br>
</body>
</html>