Advertisement
Guest User

EDIT

a guest
Jun 12th, 2017
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.75 KB | None | 0 0
  1. ito po yung pagkuha sa ieedit
  2. <h2 align ="center" > Edit Employee Details </h2>
  3. <?php
  4. include("style.php");
  5. if (isset($_GET['emp_id'])) {
  6. ?>
  7. <form action = "editemp-exec.php" method = "post" name = "abc">
  8. <?php
  9. # echo "<img width = 200 height = 180 alt = 'Unable to View' src = '" . $row1["image"] . "'>";
  10. include('conn.php');
  11. echo '<table border = 1 align = "center">';
  12. $emp_id = $_GET['emp_id'];
  13. $result = mysqli_query($db_connect, "SELECT * FROM tbl_emp WHERE emp_id = $emp_id");
  14.  
  15. while($row = mysqli_fetch_array($result)) {
  16. echo '<tr><input type="hidden" name="emp_id" value="'. $row['emp_id'] .'"></tr>';
  17. echo'<tr><td>Last Name: </td>'.'<td><input type="text" name="lastname" value="'. $row['lastname'] .'"</td></tr>';
  18. echo'<tr><td>First Name:</td> '.'<td><input type="text" name="firstname" value="'. $row['firstname'] .'"></td></tr>';
  19. echo'<tr><td>Middle Name: </td>'.'<td><input type="text" name="middlename" value="'. $row['middlename'] .'"></td></tr>';
  20. echo'<tr><td>TIN: </td>'.'<td><input type="text" name="tin_num" value="'. $row['tin_num'] .'"></td></tr>';
  21. echo'<tr><td>SSS: </td>'.'<td><input type="text" name="sss_num" value="'. $row['sss_num'] .'"></td></tr>';
  22. echo'<tr><td>PAGIBIG: </td>'.'<td><input type="text" name="pagibig_num" value="'. $row['PAGIBIG_num'] .'"></td></tr>';
  23. echo'<tr><td>PhilHealth: </td>'.'<td><input type="text" name="philhealth_num" value="'. $row['philhealth_num'] .'"></td></tr>';
  24. echo'<tr><td>Status: </td>'.'<td><input type="text" name="status" value="'. $row['status'] .'"></td></tr>';
  25. echo'<tr><td>Pay Grade: </td>'.'<td><input type="text" name="paygrade" value="'. $row['paygrade'] .'"></td></tr>';
  26. echo'<tr><td>Position: </td>'.'<td><input type="text" name="position" value="'. $row['position'] .'"></td></tr>';
  27. echo'<tr><td>Department: </td>'.'<td><input type = "text" name = "department" value = "'. $row['department'] .'"></td></tr>';
  28. echo '<tr>
  29. <td>User Name </td>
  30. <td><input type="text" name = "username" value = "'. $row['username'] .'" required></td>
  31. </tr>
  32. <tr>
  33. <td>Password </td>
  34. <td><input type = "password" name = "password" required></td>
  35. </tr>
  36. <tr>
  37. <td>Confirm Password </td>
  38. <td><input type = "password" name = "password2" required></td>
  39. </tr>';
  40.  
  41. echo'<tr><td>System Status: </td>'.'<td><input type = "text" name = "sys_status" value="'. $row['sys_status'] .'"></td></tr>';
  42. echo '<tr><td>Upload image</td>
  43. <td><input type = "file" name = "imageUploaded"></td></tr>';
  44. echo '<tr><td><input name = "" type = "submit" value = "Save" class="tiny button" /></td></tr>';
  45. }
  46. echo '</table>';
  47. ?>
  48. </form>
  49. <?php }
  50. ?>
  51.  
  52.  
  53.  
  54.  
  55. ETO PO YUNG SA EXECUTION NUNG EDITEMP FILE NA SINEND KO PO SA MESSENGER KANNA
  56.  
  57. <?php
  58. include('conn.php');
  59. function GetImageExtension($imagetype) {
  60. if(empty($imagetype)) return false;
  61. switch($imagetype) {
  62. case 'image/bmp': return '.bmp';
  63. case 'image/gif': return '.gif';
  64. case 'image/jpeg': return '.jpg';
  65. case 'image/png': return '.png';
  66. default: return false;
  67. }
  68. }
  69.  
  70. $emp_id = $_POST['emp_id'];
  71. $username = trim($_POST['username']);
  72. $password = $_POST['password'];
  73. $lastname = ucwords(trim($_POST['lastname']));
  74. $firstname = ucwords(trim($_POST['firstname']));
  75. $middlename = ucwords(trim($_POST['middlename']));
  76. $tin_num = trim($_POST['tin_num']);
  77. $sss_num = trim($_POST['sss_num']);
  78. $pagibig_num = trim($_POST['pagibig_num']);
  79. $philhealth_num = trim($_POST['philhealth_num']);
  80. $status = trim($_POST['status']);
  81. $paygrade = trim($_POST['paygrade']);
  82. $position = strtoupper(trim($_POST['position']));
  83. $department = strtoupper(trim($_POST['department']));
  84. $sys_status = trim($_POST['sys_status']);
  85.  
  86. if(!empty($_FILES["imageUploaded"]["name"])) {
  87. # get the file name, extension, path
  88. $file_name = $_FILES["imageUploaded"]["name"];
  89. $temp_name = $_FILES["imageUploaded"]["tmp_name"];
  90. $imgtype = $_FILES["imageUploaded"]["type"];
  91. $ext = GetImageExtension($imgtype);
  92. $imagename = $username."[".date("n-m-y")."]".$ext;
  93. $target_path = "images/".$imagename;
  94. if(move_uploaded_file($temp_name, $target_path)) {
  95. $update = mysqli_query($db_connect, "UPDATE tbl_emp
  96. SET username = '$username',
  97. password = '$password',
  98. lastname = '$lastname',
  99. firstname = '$firstname',
  100. middlename = '$middlename',
  101. tin_num = '$tin_num',
  102. sss_num = '$sss_num',
  103. PAGIBIG_num = '$pagibig_num',
  104. philhealth_num = '$philhealth_num',
  105. status = '$status',
  106. paygrade = '$paygrade',
  107. position = '$position',
  108. department = '$department',
  109. sys_status = '$sys_status',
  110. images_path = '$target_path'
  111. WHERE emp_id = $emp_id ") or die(mysqli_error($db_connect));
  112. }
  113. else {
  114. exit("Error While uploading image on the server");
  115. }
  116. }
  117. # If no image is uploaded by the user, retain image
  118. else {
  119. $update = mysqli_query($db_connect, "UPDATE tbl_emp
  120. SET username = '$username',
  121. password = '$password',
  122. lastname = '$lastname',
  123. firstname = '$firstname',
  124. middlename = '$middlename',
  125. tin_num = '$tin_num',
  126. sss_num = '$sss_num',
  127. PAGIBIG_num = '$pagibig_num',
  128. philhealth_num = '$philhealth_num',
  129. status = '$status',
  130. paygrade = '$paygrade',
  131. position = '$position',
  132. department = '$department',
  133. sys_status = '$sys_status',
  134. WHERE emp_id = $emp_id ") or die(mysqli_error($db_connect));
  135. }
  136. if($update === TRUE)
  137. echo "<script>alert('Changes successfully saved.')</script>";
  138. else
  139. echo "<script>alert('Changes not saved.')</script>";
  140. header("location: employee.php");
  141. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement