0) {
$row = mysqli_fetch_assoc($result);
$last_recptno = $row['recptno'];
$last_number = intval(substr($last_recptno, -5));
} else {
// No receipt number found for current year, start with 1
$last_number = 0;
}
// Increment the number and format it with the year as prefix
$next_number = $last_number + 1;
$next_recptno = $current_year . '/' . str_pad($next_number, 5, '0', STR_PAD_LEFT);
// echo '';
// Check if form has been submitted
if (isset($_POST['submit'])) {
// Retrieve form data
$accno = $_POST['accno'];
$trndate = $_POST['trndate'];
$recptno = $next_recptno;
$moneyin = $_POST['moneyin'];
$status = $_POST['status'];
$remark = $_POST['remark'];
// Insert data into tbl_bankin
echo $query = "INSERT INTO tbl_bankin (accno, trndate, recptno, moneyin, status, remark) VALUES ('$accno', '$trndate', '$recptno', '$moneyin', '$status', '$remark')";
$result = mysqli_query($connection, $query);
// Insert into running receipt no
$query03 = "INSERT INTO runrecptno (recptno) VALUES ('$recptno')";
$result03 = mysqli_query($conn, $query03);
// Display success or error message
if ($conn->query($query) === TRUE) {
echo "Success";
} else {
echo "Error: " . $query . "
" . $conn->error;
}
// if ($result) {
// echo "Transaction added successfully!
";
// } else {
// echo "Error adding transaction: " . $query . "
";
// }
}
?>
Add Money Transaction