Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ito po yung pagkuha sa ieedit
- <h2 align ="center" > Edit Employee Details </h2>
- <?php
- include("style.php");
- if (isset($_GET['emp_id'])) {
- ?>
- <form action = "editemp-exec.php" method = "post" name = "abc">
- <?php
- # echo "<img width = 200 height = 180 alt = 'Unable to View' src = '" . $row1["image"] . "'>";
- include('conn.php');
- echo '<table border = 1 align = "center">';
- $emp_id = $_GET['emp_id'];
- $result = mysqli_query($db_connect, "SELECT * FROM tbl_emp WHERE emp_id = $emp_id");
- while($row = mysqli_fetch_array($result)) {
- echo '<tr><input type="hidden" name="emp_id" value="'. $row['emp_id'] .'"></tr>';
- echo'<tr><td>Last Name: </td>'.'<td><input type="text" name="lastname" value="'. $row['lastname'] .'"</td></tr>';
- echo'<tr><td>First Name:</td> '.'<td><input type="text" name="firstname" value="'. $row['firstname'] .'"></td></tr>';
- echo'<tr><td>Middle Name: </td>'.'<td><input type="text" name="middlename" value="'. $row['middlename'] .'"></td></tr>';
- echo'<tr><td>TIN: </td>'.'<td><input type="text" name="tin_num" value="'. $row['tin_num'] .'"></td></tr>';
- echo'<tr><td>SSS: </td>'.'<td><input type="text" name="sss_num" value="'. $row['sss_num'] .'"></td></tr>';
- echo'<tr><td>PAGIBIG: </td>'.'<td><input type="text" name="pagibig_num" value="'. $row['PAGIBIG_num'] .'"></td></tr>';
- echo'<tr><td>PhilHealth: </td>'.'<td><input type="text" name="philhealth_num" value="'. $row['philhealth_num'] .'"></td></tr>';
- echo'<tr><td>Status: </td>'.'<td><input type="text" name="status" value="'. $row['status'] .'"></td></tr>';
- echo'<tr><td>Pay Grade: </td>'.'<td><input type="text" name="paygrade" value="'. $row['paygrade'] .'"></td></tr>';
- echo'<tr><td>Position: </td>'.'<td><input type="text" name="position" value="'. $row['position'] .'"></td></tr>';
- echo'<tr><td>Department: </td>'.'<td><input type = "text" name = "department" value = "'. $row['department'] .'"></td></tr>';
- echo '<tr>
- <td>User Name </td>
- <td><input type="text" name = "username" value = "'. $row['username'] .'" required></td>
- </tr>
- <tr>
- <td>Password </td>
- <td><input type = "password" name = "password" required></td>
- </tr>
- <tr>
- <td>Confirm Password </td>
- <td><input type = "password" name = "password2" required></td>
- </tr>';
- echo'<tr><td>System Status: </td>'.'<td><input type = "text" name = "sys_status" value="'. $row['sys_status'] .'"></td></tr>';
- echo '<tr><td>Upload image</td>
- <td><input type = "file" name = "imageUploaded"></td></tr>';
- echo '<tr><td><input name = "" type = "submit" value = "Save" class="tiny button" /></td></tr>';
- }
- echo '</table>';
- ?>
- </form>
- <?php }
- ?>
- ETO PO YUNG SA EXECUTION NUNG EDITEMP FILE NA SINEND KO PO SA MESSENGER KANNA
- <?php
- include('conn.php');
- function GetImageExtension($imagetype) {
- if(empty($imagetype)) return false;
- switch($imagetype) {
- case 'image/bmp': return '.bmp';
- case 'image/gif': return '.gif';
- case 'image/jpeg': return '.jpg';
- case 'image/png': return '.png';
- default: return false;
- }
- }
- $emp_id = $_POST['emp_id'];
- $username = trim($_POST['username']);
- $password = $_POST['password'];
- $lastname = ucwords(trim($_POST['lastname']));
- $firstname = ucwords(trim($_POST['firstname']));
- $middlename = ucwords(trim($_POST['middlename']));
- $tin_num = trim($_POST['tin_num']);
- $sss_num = trim($_POST['sss_num']);
- $pagibig_num = trim($_POST['pagibig_num']);
- $philhealth_num = trim($_POST['philhealth_num']);
- $status = trim($_POST['status']);
- $paygrade = trim($_POST['paygrade']);
- $position = strtoupper(trim($_POST['position']));
- $department = strtoupper(trim($_POST['department']));
- $sys_status = trim($_POST['sys_status']);
- if(!empty($_FILES["imageUploaded"]["name"])) {
- # get the file name, extension, path
- $file_name = $_FILES["imageUploaded"]["name"];
- $temp_name = $_FILES["imageUploaded"]["tmp_name"];
- $imgtype = $_FILES["imageUploaded"]["type"];
- $ext = GetImageExtension($imgtype);
- $imagename = $username."[".date("n-m-y")."]".$ext;
- $target_path = "images/".$imagename;
- if(move_uploaded_file($temp_name, $target_path)) {
- $update = mysqli_query($db_connect, "UPDATE tbl_emp
- SET username = '$username',
- password = '$password',
- lastname = '$lastname',
- firstname = '$firstname',
- middlename = '$middlename',
- tin_num = '$tin_num',
- sss_num = '$sss_num',
- PAGIBIG_num = '$pagibig_num',
- philhealth_num = '$philhealth_num',
- status = '$status',
- paygrade = '$paygrade',
- position = '$position',
- department = '$department',
- sys_status = '$sys_status',
- images_path = '$target_path'
- WHERE emp_id = $emp_id ") or die(mysqli_error($db_connect));
- }
- else {
- exit("Error While uploading image on the server");
- }
- }
- # If no image is uploaded by the user, retain image
- else {
- $update = mysqli_query($db_connect, "UPDATE tbl_emp
- SET username = '$username',
- password = '$password',
- lastname = '$lastname',
- firstname = '$firstname',
- middlename = '$middlename',
- tin_num = '$tin_num',
- sss_num = '$sss_num',
- PAGIBIG_num = '$pagibig_num',
- philhealth_num = '$philhealth_num',
- status = '$status',
- paygrade = '$paygrade',
- position = '$position',
- department = '$department',
- sys_status = '$sys_status',
- WHERE emp_id = $emp_id ") or die(mysqli_error($db_connect));
- }
- if($update === TRUE)
- echo "<script>alert('Changes successfully saved.')</script>";
- else
- echo "<script>alert('Changes not saved.')</script>";
- header("location: employee.php");
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement