home/abhiramc/public_html/acts.service/dashboard.employee.qr.php 0000644 00000036742 15021155136 0021047 0 ustar 00 '; //} ?> getConnection(); // Prepared statement to avoid SQL injection $selectQuery = "SELECT * FROM acts_emp WHERE empid = :empid"; // Prepare the SQL statement $stmt = $conn->prepare($selectQuery); // Bind the member ID to the prepared statement $stmt->bindParam(':empid', $memberId, PDO::PARAM_INT); // Execute the query $stmt->execute(); // Fetch the result $result = $stmt->fetch(PDO::FETCH_ASSOC); // Check if a result was returned if ($result) { // Successfully fetched the member details $memberDetails = $result; } else { echo "No data found for the provided employee ID."; } ?>