Create Extra Fee | Xcel Training Institute

?????????????? ?????????????? query($delsql); exit; } // Generate next Extra Fee No (query MAX from extra_fee table) $extraRes = $conn->query("SELECT MAX(CAST(extra_fee_no AS UNSIGNED)) as max_no FROM extra_fee"); $maxRow = $extraRes->fetch_assoc(); $maxNo = $maxRow['max_no'] ?? 0; $nextExtraNo = str_pad($maxNo + 1, 3, '0', STR_PAD_LEFT); $user = 'xceljsr_db'; $password = 'xcel@123#$'; $database = 'xceljsr_db'; $servername = 'localhost'; $mysqli = new mysqli($servername, $user, $password, $database); // Checking for connections if ($mysqli->connect_error) { die('Connect Error (' . $mysqli->connect_errno . ') ' . $mysqli->connect_error); } // Use the userid (username) directly from session $userId = mysqli_real_escape_string($mysqli, $_SESSION['uid']); $sql10 = "SELECT * FROM extra_fee WHERE addedby = '$userId' ORDER BY id DESC"; $result10 = $mysqli->query($sql10); $a = 0; ?> Create Extra Fee | Xcel Training Institute

Create Extra Fee Receipt

Admission No

Student Details

Student Name

Father's Name

Mobile No

Course Name

Extra Fee

Payment For

Reason

Extra Paid Fee

Payment Details

Extra Fee No

Received Amount

Payment Mode

Date

Transaction ID

Bank/UPI

Extra Fees

fetch_assoc()) { ?>

S.No.	Extra Fee No	Admission No	Student Name	Payment For	Received Amount	Date	Action