📁 File Manager
Editing:
/home/wedigitalindia/public_html/demo.wedigitalindia.com/dcl-erp/profile.php
<?php ob_start(); include_once("include/head.php"); function sanitizeInput($data) { return htmlspecialchars(strip_tags(trim($data))); } if($userType == 'Employee'){ $id = $_SESSION["employee_id"]; $sql = "SELECT e.*, b.branch_name, d.department_name, des.designation_name, r.role_name, m.first_name AS reporting_manager_name FROM employees e LEFT JOIN branches b ON e.branch_id = b.branch_id LEFT JOIN departments d ON e.department_id = d.department_id LEFT JOIN designations des ON e.designation_id = des.designation_id LEFT JOIN roles r ON e.role = r.role_id LEFT JOIN employees m ON e.reporting_to = m.employee_id WHERE e.employee_id = $id "; $result = $conn->query($sql); if ($result && $result->num_rows > 0) { $employee = $result->fetch_assoc(); } else { die("Employee not found"); } if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['submit'])) { $password = $_POST['password']; $hashed_password = password_hash($password, PASSWORD_BCRYPT); $currentDateTime = date('Y-m-d H:i:s'); $sql = "UPDATE employees SET password = ?, updated_at = ? WHERE employee_id = ?"; if ($stmt = mysqli_prepare($conn, $sql)) { mysqli_stmt_bind_param($stmt, "ssi", $hashed_password, $currentDateTime, $id); if (mysqli_stmt_execute($stmt)) { mysqli_stmt_close($stmt); mysqli_close($conn); $_SESSION['success_message'] = "Password updated successfully."; // echo'<script> window.location.reload(); </script>'; } else { echo "Error: " . mysqli_error($conn); } } else { echo "Error: " . mysqli_error($conn); } } ?> <div class="main-panel"> <div class="content-wrapper"> <div class="card"> <div class="card-body"> <h2 class="card-title">PROFILE DETAILS</h2> <div class="row"> <div class="col-md-6"> <p class="text-uppercase"><strong>Full Name:</strong> <?php echo htmlspecialchars($employee['first_name'] . ' ' . $employee['last_name']); ?></p> </div> <div class="col-md-6"> <p class="text-uppercase"><strong>Employee Code:</strong> <?php echo htmlspecialchars($employee['employee_code']); ?></p> </div> <div class="col-md-6"> <p class="text-uppercase"><strong>Branch:</strong> <?php echo htmlspecialchars($employee['branch_name']); ?></p> </div> <div class="col-md-6"> <p class="text-uppercase"><strong>Department:</strong> <?php echo htmlspecialchars($employee['department_name']); ?></p> </div> <div class="col-md-6"> <p class="text-uppercase"><strong>Designation:</strong> <?php echo htmlspecialchars($employee['designation_name']); ?></p> </div> <div class="col-md-6"> <p class="text-uppercase"><strong>Role:</strong> <?php echo htmlspecialchars($employee['role_name']); ?></p> </div> <div class="col-md-6"> <p class="text-uppercase"><strong>Reporting Manager:</strong> <?php echo htmlspecialchars($employee['reporting_manager_name']); ?></p> </div> <div class="col-md-6"> <p><strong>NID:</strong> <?php echo htmlspecialchars($employee['nid']); ?></p> </div> <div class="col-md-6"> <p class="text-uppercase"><strong>Contact Number:</strong> <?php echo htmlspecialchars($employee['contact_no']); ?></p> </div> <div class="col-md-6"> <p class="text-uppercase"><strong>Date Of Birth:</strong> <?php echo htmlspecialchars($employee['date_of_birth']); ?></p> </div> <div class="col-md-6"> <p class="text-uppercase"><strong>Date of Joining:</strong> <?php echo htmlspecialchars($employee['date_of_joining']); ?></p> </div> <div class="col-md-6"> <p class=""><strong>E-Mail:</strong> <?php echo htmlspecialchars($employee['email']); ?></p> </div> <div class="col-md-6"> <p class="text-uppercase"><strong>Address:</strong> <?php echo htmlspecialchars($employee['address']); ?></p> </div> </div> <div class="row"> <span class="border-top border-1 w-100 my-3"></span> <div class="col-md-12 mt-1"> <h2 class="card-title">UPDATE PASSWORD</h2> </div> <div class="col-md-8"> <?php session_start(); if (isset($_SESSION['success_message'])) { echo '<div class="alert alert-success">' . htmlspecialchars($_SESSION['success_message']) . '</div>'; unset($_SESSION['success_message']); } if (isset($_SESSION['error_message'])) { echo '<div class="alert alert-danger">' . htmlspecialchars($_SESSION['error_message']) . '</div>'; unset($_SESSION['error_message']); } ?> </div> <div class="col-md-6"> <form class="cmxform" id="commentForm" method="post" action="" enctype="multipart/form-data" onsubmit="return validateForm()"> <fieldset> <div class="row"> <div class="form-group col-md-6"> <label for="password">Enter New Password</label> <input class="form-control" type="text" name="password" > </div> </div> <input class="btn btn-primary" type="submit" value="Update" name="submit"> </fieldset> </form> </div> </div> </div> </div> </div> </div> <?php } else{ $sql1 = "SELECT * FROM users"; $result1 = $conn->query($sql1); if ($result1 && $result1->num_rows > 0) { $admin = $result1->fetch_assoc(); } else { die("data not found"); } if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['submit'])) { $username = sanitizeInput($_POST['username']); $email = sanitizeInput($_POST['email']); $newPassword = $_POST['newpassword']; $password = $_POST['password']; $adminId = $admin['id']; $sql_verify = "SELECT password FROM users WHERE id = $adminId"; $result = $conn->query($sql_verify); if ($result && $result->num_rows > 0) { $admin = $result->fetch_assoc(); } else { die("data not found"); } if (password_verify($newPassword, $admin['password'])) { $hashed_password = password_hash($password, PASSWORD_BCRYPT); $sql_update = "UPDATE users SET username = ?, email = ?, password = ? WHERE id = ?"; if ($stmt_update = $conn->prepare($sql_update)) { $stmt_update->bind_param("sssi", $username, $email, $hashed_password, $adminId); if ($stmt_update->execute()) { $stmt_update->close(); $conn->close(); $_SESSION['success_message'] = "Profile updated successfully."; header("Location: " . $_SERVER['PHP_SELF']); exit(); } else { echo "Error: " . $conn->error; } } else { echo "Error: " . $conn->error; } } else { $_SESSION['error_message'] = "Old password is incorrect."; } } ob_end_flush(); ?> <div class="main-panel"> <div class="content-wrapper"> <div class="card"> <div class="card-body"> <div class="row"> <div class="col-md-12 mt-1"> <?php session_start(); if (isset($_SESSION['success_message'])) { echo '<div class="alert alert-success">' . htmlspecialchars($_SESSION['success_message']) . '</div>'; unset($_SESSION['success_message']); } if (isset($_SESSION['error_message'])) { echo '<div class="alert alert-danger">' . htmlspecialchars($_SESSION['error_message']) . '</div>'; unset($_SESSION['error_message']); } ?> <h2 class="card-title">UPDATE PROFILE</h2> </div> <div class="col-md-12"> <form class="cmxform" id="commentForm" method="post" action="" enctype="multipart/form-data" onsubmit="return validateForm()"> <fieldset> <div class="row"> <div class="form-group col-md-3"> <label for="password">Username</label> <input class="form-control" type="text" name="username" value="<?php echo $admin['username']?>"> </div> <div class="form-group col-md-3"> <label for="password">Email</label> <input class="form-control" type="email" name="email" value="<?php echo $admin['email'] ?>"> </div> <div class="form-group col-md-3"> <label for="password">Old Password</label> <input class="form-control" type="text" name="newpassword" placeholder="**********" > </div> <div class="form-group col-md-3"> <label for="password">Enter New Password</label> <input class="form-control" type="text" name="password" > </div> </div> <input class="btn btn-primary" type="submit" value="Update" name="submit"> </fieldset> </form> </div> </div> </div> </div> </div> </div> <?php } ?> <?php include_once("include/footer.php"); ?> </body> </html>
Save
Cancel