???????????????????? ?????????????????? ÿØÿà JFIF    ÿÛ C    !"$"$ÿÛ C  ÿ p " ÿÄ     ÿÄ   ÿÚ   ÕÔË® (% aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥ BQ¤¢ X«)X…€¤  @ adadasdasdasasdasdas .....................................................................................................................................???????????????????? ?????????????????? ÿØÿà JFIF    ÿÛ C    !"$"$ÿÛ C  ÿ p " ÿÄ     ÿÄ   ÿÚ   ÕÔË® (% aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥ BQ¤¢ X«)X…€¤  @ adadasdasdasasdasdas ..................................................................................................................................... Insert Page page
0) { // City exists, fetch the current serial $row = mysqli_fetch_assoc($result); $current_serial = $row['invoice_serial']; // Don't increment, just use current value // Generate the invoice serial number (e.g., JSR001) $office_prefix = strtoupper(substr($office, 0, 3)); $invoice_serial_number = $office_prefix . str_pad($current_serial, 3, "0", STR_PAD_LEFT); } else { // City does not exist, initialize serial $current_serial = 0; // Insert the new city into the CitySerials table $sql_insert_city = "INSERT INTO cityserials (city, invoice_serial) VALUES ('$office', $current_serial)"; mysqli_query($conn, $sql_insert_city); // Generate initial invoice serial number $office_prefix = strtoupper(substr($office, 0, 3)); $invoice_serial_number = $office_prefix . str_pad($current_serial, 3, "0", STR_PAD_LEFT); } // Insert data into the users table $sql = "INSERT INTO users (gstin, userid, pass, office, address, invoiceserial, moneyserial, consignmentserial, can_invoice, can_moneyreceipt, can_consignment) VALUES ('$gstno', '$userid', '$password', '$office', '$address', '$invoice_serial_number','$moneyserial','$consignmentserial', $can_invoice, $can_moneyreceipt, $can_consignment)"; if (mysqli_query($conn, $sql)) { echo ''; } else { echo "ERROR: Hush! Sorry $sql. " . mysqli_error($conn); } // Close connection mysqli_close($conn); ?>