Shravan patil Prof:- Umar Mohammed Shaikh
PRN 2022018100094052
<?PHP
// DATABASE CONNECTION PARAMETERS
$SERVERNAME = "LOCALHOST";
$USERNAME = "ROOT";
$PASSWORD = "";
$DATABASE = "OFFICE"; // YOUR DATABASE NAME
$TABLE = "SALARY"; // YOUR TABLE NAME
// CREATE CONNECTION
$CONN = NEW MYSQLI($SERVERNAME, $USERNAME, $PASSWORD, $DATABASE);
// CHECK CONNECTION
IF ($CONN->CONNECT_ERROR) {
DIE(“CONNECTION FAILED: “ . $CONN->CONNECT_ERROR);
}
// FUNCTION TO CALCULATE PAYMENT
FUNCTION CALCULATEPAYMENT($SALARY, $TOTALLEAVEAPPLIED) {
// CALCULATE TOTAL DEDUCTIONS
$TOTALDEDUCTION = $TOTALLEAVEAPPLIED * 500; IF ($TOTALLEAVEAPPLIED
> 5) {
// ADDITIONAL DEDUCTION FOR LEAVE MORE THAN 5 DAYS
$ADDITIONALDEDUCTION = ($TOTALLEAVEAPPLIED - 5) * 700;
$TOTALDEDUCTION += $ADDITIONALDEDUCTION;
}
$FINALDEDUCTION = $TOTALDEDUCTION + 100;
BFCACS – Sem V
Shravan patil Prof:- Umar Mohammed Shaikh
PRN 2022018100094052
// CALCULATE FINAL PAYMENT
$FINALPAYMENT = $SALARY - $FINALDEDUCTION; RETURN $FINALPAYMENT;
}
// HTML FORM TO SELECT EMPLOYEE
ECHO “<FORM
METHOD=’POST’>”; ECHO
“SELECT EMPLOYEE: “;
ECHO “<SELECT NAME=’EMPLOYEEID’>”;
// SQL QUERY TO FETCH EMPLOYEE IDS AND NAMES
$SQL = "SELECT `ID.NO`, EMP_NAME, LEAVE_APPLY FROM $TABLE";
$RESULT = $CONN->QUERY($SQL);
IF ($RESULT->NUM_ROWS > 0) {
WHILE ($ROW = $RESULT->FETCH_ASSOC()) {
ECHO "<OPTION VALUE='" . $ROW["ID.NO"] . "'>" . $ROW["EMP_NAME"] . "</OPTION>";
}}
ECHO "</SELECT>";
ECHO "<INPUT TYPE='SUBMIT' VALUE='GET PAYMENT'>";
ECHO "</FORM>";
// DISPLAY SELECTED EMPLOYEE'S PAYMENT
IF ($_SERVER[“REQUEST_METHOD”] == “POST”) {
$EMPLOYEEID = $_POST[“EMPLOYEEID”];
// SQL QUERY TO FETCH EMPLOYEE DATA
$SQL = “SELECT `ID.NO`, EMP_NAME, SALARY, TOTAL_LEAVE, LEAVE_APPLY FROM
$TABLE WHERE `ID.NO` = $EMPLOYEEID”;
$RESULT = $CONN->QUERY($SQL);
IF ($RESULT->NUM_ROWS > 0) {
BFCACS – Sem V
Shravan patil Prof:- Umar Mohammed Shaikh
PRN 2022018100094052
ECHO “<H2>EMPLOYEE PAYMENT DETAILS</H2>”;
ECHO “<TABLE BORDER=’1’>”;
ECHO “<TR><TH>EMPLOYEE ID</TH><TH>EMPLOYEE NAME</TH><TH>TOTAL
PAYMENT</TH></TR>”;
WHILE ($ROW = $RESULT->FETCH_ASSOC()) {
// CALCULATE PAYMENT
$SALARY = $ROW[“SALARY”];
$TOTALLEAVEAPPLIED = $ROW[“LEAVE_APPLY”];
$FINALPAYMENT = CALCULATEPAYMENT($SALARY, $TOTALLEAVEAPPLIED);
// DISPLAY RESULT IN TABLE
ECHO “<TR>”;
ECHO “<TD>” . $ROW[“ID.NO”] . “</TD>”;
ECHO “<TD>” . $ROW[“EMP_NAME”] . “</TD>”;
ECHO “<TD>” . $FINALPAYMENT . “</TD>”; ECHO “</TR>”;
// DISPLAY MESSAGE FOR EMPLOYEES WITH MORE THAN 5 LEAVES APPLIED
IF ($TOTALLEAVEAPPLIED > 5) {
ECHO “<TR><TD COLSPAN=’3’>FROM NEXT MONTH, IF LEAVE IS MORE THAN 5, $700 WILL BE REDUCED FOR
EACH LEAVE.</TD></TR>”;
}
}
ECHO “</TABLE>”;
} ELSE {
ECHO “NO RECORDS FOUND FOR SELECTED EMPLOYEE.”;
}
}
// CLOSE CONNECTION
BFCACS – Sem V
Shravan patil Prof:- Umar Mohammed Shaikh
PRN 2022018100094052
$CONN->CLOSE();
?>
BFCACS – Sem V
Saurabh Jha Prof:-
Umar Mohammed Shaikh
PRN 2022018100094133
BFCACS – Sem V
