function leaveDue($applicantUserCodeNumber, $livLeaveId) { $objForLeaveDaysRemain = new DbOperation(); $result = $objForLeaveDaysRemain->leaveDaysRemainForOneUser($applicantUserCodeNumber, $livLeaveId); if (mysqli_fetch_array($result) == null) { $objForLeaveDaysRemain = new DbOperation(); $leaveTotal = $objForLeaveDaysRemain->forLeaveDays($livLeaveId); while ($rowTotal = mysqli_fetch_array($leaveTotal)) { $livTotalLeaveDaysRemain = $rowTotal['lTotalDays']; } //echo "From If : TotalLeaveDaysRemain = ".$livTotalLeaveDaysRemain."<br/>"; return $livTotalLeaveDaysRemain; } else { $objForLeaveDaysRemain = new DbOperation(); $result = $objForLeaveDaysRemain->leaveDaysRemainForOneUser($applicantUserCodeNumber, $livLeaveId); while ($row = mysqli_fetch_array($result)) { $livTotalLeaveDaysRemain = $row['lTotalLeaveDaysRemain']; } //echo "From Else : TotalLeaveDaysRemain = ".$livTotalLeaveDaysRemain."<br/>"; return $livTotalLeaveDaysRemain; } $objDbOperation = new DbOperation(); $this->check = 0; $columnsName = "lTotalLeaveDaysRemain"; //database column name $tablesName = "employeeleaveapplicationdetails"; //database table name $conditions = "WHERE lLeaveId = " . $livLeaveId . " ORDER BY lId DESC LIMIT 1"; // conditions, what we want to apply $result = $objDbOperation->dbJoinSingleSelect($columnsName, $tablesName, $conditions); //var_dump($result); return $result; }