edit_emp.php ( File view )

  • By cox 2014-08-14
  • View(s):156
  • Download(s):9
  • Point(s): 2
			<?php
	    require_once('includes/start.php');
	include('includes/header.html');
?>
<link href="loginmodule.css" rel="stylesheet" type="text/css" />
<h1>Edit Employee</h1>
<?php

$page_title = 'Edit Employee';

if( (isset($_GET['id'])) && (is_numeric($_GET['id'])) ){

$id = $_GET['id'];

}elseif( (isset($_POST['id'])) && (is_numeric($_POST['id'])) ){

$id = $_POST['id'];

}else{

echo '<p>Page Error</p>
        <p class="error">Page has been accessed in error!</p><p><br /><br />
		</p>';
exit();

}
require_once('../dbcon.php');

if(isset($_POST['submitted'])) {


$errors = array();

if(empty($_POST['fname'])) {

$errors[] = 'Please enter First Name!';

}else{

$fname = escape_data($_POST['fname']);

}

if(empty($_POST['mname'])) {

$errors[] = 'Please enter Middle Name!';

}else{

$mname = escape_data($_POST['mname']);

}

if(empty($_POST['lname'])) {

$errors[] = 'Please enter Last Name!';

}else{

$lname = escape_data($_POST['lname']);

}

if(empty($_POST['bday'])) {

$errors[] = 'Please enter Bday!';

}else{

$bday = escape_data($_POST['bday']);

}

if(empty($_POST['age'])) {

$errors[] = 'Please enter age!';

}else{

$age = escape_data($_POST['age']);

}

if(empty($_POST['gendr'])) {

$errors[] = 'Please enter gender!';

}else{

$gendr = escape_data($_POST['gendr']);

}

if(empty($_POST['add'])) {

$errors[] = 'Please enter add!';

}else{

$add = escape_data($_POST['add']);

}

if(empty($_POST['stat'])) {

$errors[] = 'Please enter Last Name!';

}else{

$stat = escape_data($_POST['stat']);

}

if(empty($_POST['cont'])) {

$errors[] = 'Please enter Last Name!';

}else{

$cont = escape_data($_POST['cont']);

}

if(isset($_POST['posi']) && (is_array($_POST['posi']))){

$posi = TRUE;

}else{

$posi = FALSE;
echo '<p>Please select the position!</p>';

}
 	foreach($_POST['posi'] as $var){

if(empty($errors)) {


$query = "SELECT eid FROM employee WHERE fname='$fname' AND eid !=$id";
$result = mysql_query($query);
if(mysql_num_rows($result) ==0){

$query = "UPDATE employee SET fname='$fname', mname='$mname', lname='$lname', bday='$bday', age='$age', gender='$gendr', address='$add', status='$stat', contact='$cont', posid='$var' WHERE eid=$id";
$result = @mysql_query($query);
if(mysql_affected_rows() ==1){


echo '<p>Edit Employee</p>
	  <p>Employee has been edited!</p><p><br /><br /></p>';
	 echo "<meta http-equiv='refresh' content='3;url=view_emp.php'>";
	  exit();
	 
}else{

	   echo '<p>Warning!</p>
	   <p class="error">Employee Already Updated or</p>
	   <p class="error">No changes made!</p>
	   ';
	  /* echo '<p>'.mysql_error().'<br /><br />Query: '.$query.'</p>';*/
	
	   
}
	  
}else{

	  echo '<p>Error!</p>
	  <p class="error">Following Error(s) occured:<br />';
	  foreach($errors as $msg){

	  echo "-$msg<br />\n";
	  
}
	  echo '</p><p>Please Try Again</p><p><br /></p>';
	  
}
	  
}
	
}
	
}
//------Get employee profile------- 
	$query = "SELECT fname, mname, lname, bday, age, gender, address, status, contact, employee.posid, position.position FROM employee , position WHERE eid=$id AND position.posid = employee.posid";
	 $result = @mysql_query($query);
	 
	 if(mysql_num_rows($result) ==1){

	 $row = mysql_fetch_array($result, MYSQL_ASSOC);

	 echo '
     
	 <form action="edit_emp.php" method="post" target="_self">
	 <table align="center" border="1" bgcolor="lightgreen">
	 <tr>
	 <td><p>First Name:</td><td> <input name="fname" type="text" value="'.$row[fname].'" /></p></td></tr>
	 <tr><td><p>Middle Name: </td><td><input name="mname" type="text" value="'.$row[mname].'" /></p></td></tr>
	 <tr><td><p>Last Name:</td><td> <input name="lname" type="text" value="'.$row[lname].'" /></p> </td></tr>
	 <tr><td><p>Birth day:</td><td> <input name="bday" type="text" value="'.$row[bday].'" /></p> </td></tr>
	 <tr><td><p>Age:</td><td> <input name="age" type="text" value="'.$row[age].'" /></p> </td></tr>
	 <tr><td><p>Gender:</td><td> <input name="gendr" type="text" value="'.$row[gendr].'" /></p> </td></tr>
	 <tr><td><p>Address:</td><td> <input name="add" type="text" value="'.$row[add].'" /></p> </td></tr>
	 <tr><td><p>Status:</td><td> <input name="stat" type="text" value="'.$row[stat].'" /></p> </td></tr>
	 <tr><td><p>Contact:</td><td> <input name="cont" type="text" value="'.$row[cont].'" /></p> </td></tr>
	 <tr><td>Position:</td>    <td><select name="posi[]"> ';

$query ="SELECT posid, position FROM position ORDER BY posid ASC";
$result = @mysql_query($query);
while($row = mysql_fetch_array($result,MYSQL_NUM)){

echo "<option value=\"$row[0]\"";
if(isset($_POST['posi']) && (in_array($row[0], $_POST['posi']))){

echo ' selected="selected"';

}
echo ">$row[1]</option>\n";

}

echo '</select></td></td></tr>
	 <tr><td>&nbsp;</td><td><p><input name="submit" type="submit" value="Update" /></p></td></tr>
	 <input name="submitted" type="hidden" value="TRUE" />
	 <input name="id" type="hidden" value="'.$id.'" />
	 </td></tr></table>
	 </form>';
	 
	 
}else{

	 echo '<p>Page Error</p>
	 <p class="error">Page has been accessed in error!</p><p><br /><br /></p>';
	 
}

	 
mysql_close();
include('includes/footer.html');
?>
	 
	   			
...
Expand> <Close

Want complete source code? Download it here

Point(s): 2

Download
0 lines left, continue to read
Sponsored links

File list

Tips: You can preview the content of files by clicking file names^_^
Name Size Date
add-employee.php8.98 kB04-07-14 10:43
add-user.php3.26 kB04-07-14 10:27
approve.php157.00 B07-02-09 04:33
date-added.php496.00 B14-02-09 00:10
db-backup-1371292492-5cac8f65a378cc19b150279db357c567.sql3.23 kB15-06-13 06:34
db-backup-1371360757-5cac8f65a378cc19b150279db357c567.sql3.80 kB16-06-13 01:32
db-backup-1371377572-5cac8f65a378cc19b150279db357c567.sql4.88 kB16-06-13 06:12
db-backup-1402914697-5cac8f65a378cc19b150279db357c567.sql6.12 kB16-06-14 13:31
db_backup.php1.79 kB09-11-08 22:21
del-users.php2.39 kB09-02-09 14:49
delete-employee.php2.51 kB07-02-09 05:11
delete-users.php2.32 kB10-02-09 14:45
del_emp.php2.44 kB07-02-09 05:14
deny.php158.00 B07-02-09 04:33
edate.php499.00 B13-02-09 13:42
edit-user.php2.15 kB14-02-09 00:05
editemp-frm.php3.08 kB30-12-08 15:53
edit_emp.php5.08 kB29-11-08 23:07
emp-list.php6.30 kB04-02-09 14:35
emp-profile.php1.67 kB14-02-09 00:03
endate.php499.00 B13-02-09 13:44
fdate.php487.00 B12-02-09 13:24
footer.html104.00 B18-06-14 18:01
header.html5.94 kB18-06-14 15:10
start.php344.00 B16-12-08 05:35
dwsync.xml286.00 B18-06-14 18:01
index.php2.14 kB25-06-14 15:21
logout.php848.00 B18-06-14 17:45
main-index.php397.00 B16-06-14 13:26
month.php486.00 B11-02-09 07:10
month2.php499.00 B13-02-09 14:59
print-report.php1.17 kB11-02-09 07:07
print.php5.41 kB25-06-14 13:41
search-edit.php3.86 kB17-12-08 06:09
search-edituser.php3.86 kB17-12-08 06:11
search.php3.89 kB15-06-13 12:53
verify-editemp.php561.00 B09-02-09 08:09
verifyedit-user.php454.00 B09-02-09 14:35
view-leave.php3.06 kB17-06-13 04:32
viewedit-employee.php5.72 kB14-02-09 00:15
viewedit-user.php4.38 kB09-02-09 07:03
viewpending-leaves.php2.50 kB15-06-13 12:49
dwsync.xml860.00 B04-07-14 10:43
ccse.sql7.20 kB15-08-13 06:14
date.inc.php589.00 B07-11-08 17:12
dbcon.php467.00 B11-06-14 17:19
dapproved.php184.00 B27-02-09 02:11
ddeny.php191.00 B07-02-09 04:33
emp-profile.php1.66 kB14-02-09 00:02
footer.html104.00 B18-06-14 18:00
header.html6.01 kB18-06-14 17:50
start.php344.00 B08-09-08 13:34
dwsync.xml286.00 B18-06-14 18:00
logout.php848.00 B18-06-14 17:43
main-index.php403.00 B18-06-14 17:58
search.php3.96 kB16-06-13 00:26
view-leave.php1.98 kB16-06-13 01:29
viewpending-leaves.php2.50 kB16-06-13 00:28
dwsync.xml288.00 B18-06-14 17:58
fidfrm.php1.64 kB16-06-13 01:15
approval.jpg1.82 kB01-12-08 06:42
approved.jpg1.87 kB01-12-08 06:40
back.gif7.49 kB15-10-08 20:36
Brain_Mill_Logo_1b-1.gif8.41 kB16-02-09 13:23
cancel.gif2.49 kB11-02-09 00:45
delete.jpg1.61 kB01-12-08 06:43
disapproval.jpg1.99 kB01-12-08 06:42
disapproved.jpg2.07 kB01-12-08 06:42
edit.jpg1.35 kB30-11-08 00:37
exthome.png79.83 kB16-02-09 12:16
login.gif208.73 kB08-02-09 07:34
logo.png106.01 kB16-06-14 13:23
nzoia.jpg425.23 kB15-06-13 15:31
print2.gif2.50 kB31-12-08 03:14
resume.gif3.03 kB30-12-08 15:26
top.gif13.75 kB16-06-14 13:36
view.gif2.52 kB20-12-08 00:06
top.gif.mno113.00 B16-06-14 13:36
footer.html104.00 B16-06-14 12:39
header.html5.76 kB18-06-14 17:51
start.php344.00 B08-09-08 13:34
dwsync.xml286.00 B18-06-14 17:51
index.php2.17 kB19-06-14 10:24
leave.php8.69 kB30-07-14 17:17
logout.php842.00 B18-06-14 17:27
main-index.php380.00 B18-06-14 18:07
mysql_connect.php645.00 B07-11-08 03:55
<NSC>0.00 BSystem.ppt 1940992
Reminder.txt192.00 B12-05-09 07:22
Resume.doc35.50 kB18-06-13 00:14
search.php3.50 kB16-06-13 01:21
setid.php1.31 kB21-02-09 08:21
view-availableleave.php1.41 kB07-02-09 04:59
view-leave.php1.67 kB20-02-09 15:51
viewpending-leaves.php2.19 kB16-06-13 01:17
dwsync.xml621.00 B30-07-14 17:17
<_notes>0.00 B09-08-14 11:29
<_notes>0.00 B09-08-14 11:29
<includes>0.00 B09-08-14 11:29
<New>0.00 B0% 15-06-13
<_notes>0.00 B09-08-14 11:29
<includes>0.00 B09-08-14 11:29
<_notes>0.00 B09-08-14 11:29
<_notes>0.00 B09-08-14 11:29
<_notes>0.00 B09-08-14 11:29
<admin>0.00 B09-08-14 11:29
<database>0.00 B09-08-14 11:29
<director>0.00 B09-08-14 11:29
<images>0.00 B09-08-14 11:29
<includes>0.00 B09-08-14 11:29
<presentation>0.00 B09-08-14 11:29
<resume>0.00 B09-08-14 11:29
<sick-leave>0.00 B28-04-09 00:20
<_notes>0.00 B09-08-14 11:29
<OnlineLeaveSystem>0.00 B09-08-14 11:29
...
Sponsored links

edit_emp.php (931.49 kB)

Need 2 point
Your Point(s)

Your Point isn't enough.

Get point immediately by PayPal

More(Debit card / Credit card / PayPal Credit / Online Banking)

Submit your source codes. Get more point

LOGIN

Don't have an account? Register now
Need any help?
Mail to: support@codeforge.com

切换到中文版?

CodeForge Chinese Version
CodeForge English Version

Where are you going?

^_^"Oops ...

Sorry!This guy is mysterious, its blog hasn't been opened, try another, please!
OK

Warm tip!

CodeForge to FavoriteFavorite by Ctrl+D