Файловый менеджер - Редактировать - /home/d46091/invoice.ecogenix.in/save_challan.php
Назад
<?php require_once('includes/connection.php'); session_start(); if ($_SERVER["REQUEST_METHOD"] == "POST") { // echo '<pre>'; // print_r($_SESSION); // die(); // Sanitize input $consignorName = mysqli_real_escape_string($conn, $_POST['consignorName']); $consignorAddress = mysqli_real_escape_string($conn, $_POST['consignorAddress']); $consignorEmail = mysqli_real_escape_string($conn, $_POST['consignorEmail']); $consignorPhone = mysqli_real_escape_string($conn, $_POST['consignorPhone']); $consignorPincode = mysqli_real_escape_string($conn, $_POST['consignorPincode']); $consignorGst = mysqli_real_escape_string($conn, $_POST['consignorGst']); $order_date = mysqli_real_escape_string($conn, $_POST['order_date']); $name = mysqli_real_escape_string($conn, $_POST['name']); $address1 = mysqli_real_escape_string($conn, $_POST['address1']); $address2 = isset($_POST['address2']) ? mysqli_real_escape_string($conn, $_POST['address2']) : ''; $destination = mysqli_real_escape_string($conn, $_POST['destination']); $purchaseOrderNo = mysqli_real_escape_string($conn, $_POST['purchaseOrderNo']); $challanNo = mysqli_real_escape_string($conn, $_POST['challanNo']); $date = mysqli_real_escape_string($conn, $_POST['date']); $vehicleNo = mysqli_real_escape_string($conn, $_POST['vehicleNo']); $d_vehicle_date = mysqli_real_escape_string($conn, $_POST['d_vehicle_date']); $description = mysqli_real_escape_string($conn, $_POST['description']); $itemDescription = mysqli_real_escape_string($conn, $_POST['itemDescription']); $bags = mysqli_real_escape_string($conn, $_POST['bags']); $quantity = mysqli_real_escape_string($conn, $_POST['quantity']); $rate = mysqli_real_escape_string($conn, $_POST['rate']); $cus_state = mysqli_real_escape_string($conn, $_POST['cus_state']); $amount = mysqli_real_escape_string($conn, $_POST['amount']); $cgst = mysqli_real_escape_string($conn, $_POST['cgst']); $sgst = mysqli_real_escape_string($conn, $_POST['sgst']); $igst = mysqli_real_escape_string($conn, $_POST['igst']); $finalAmount = mysqli_real_escape_string($conn, $_POST['finalAmount']); $amountWords = mysqli_real_escape_string($conn, $_POST['amountWords']); $hsn = mysqli_real_escape_string($conn, $_POST['hsn']); $driverNo = mysqli_real_escape_string($conn, $_POST['driverNo']); $sig_datetime = mysqli_real_escape_string($conn, $_POST['sig_datetime']); $sig_datetime = date('Y-m-d H:i:s', strtotime($sig_datetime)); $created_by = $_SESSION['username']; // 1. Insert challan number into challan_master (if not already inserted) $checkStmt = $conn->prepare("SELECT id FROM challan_master WHERE challan_no = ?"); $checkStmt->bind_param("s", $challanNo); $checkStmt->execute(); $checkStmt->store_result(); if ($checkStmt->num_rows == 0) { $insertChallan = $conn->prepare("INSERT INTO challan_master (challan_no, created_at) VALUES (?, NOW())"); $insertChallan->bind_param("s", $challanNo); if (!$insertChallan->execute()) { echo "Error saving challan number: " . $insertChallan->error; exit(); } $insertChallan->close(); } $checkStmt->close(); // 2. Insert main road_challans record $sql = " INSERT INTO `road_challans` ( `name`, `address1`, `address2`, `purchase_order_no`, `challan_no`, `date`, `vehicle_no`, `bags`, `quantity`, `description`, `itemDescription`, `hsn`, `driver_no`, `created_at`, `consignorName`, `consignorAddress`, `consignorEmail`, `consignorPhone`, `consignorPincode`, `destination`, `consignorGst`, `d_vehicle_date`, `cus_state`, `rate`, `amount`, `cgst`, `sgst`, `igst`, `finalAmount`, `amountWords`, `order_date`, `sig_datetime`, `created_by` ) VALUES ( '$name', '$address1', '$address2', '$purchaseOrderNo', '$challanNo', '$date', '$vehicleNo', '$bags', '$quantity', '$description', '$itemDescription', '$hsn', '$driverNo', NOW(), '$consignorName', '$consignorAddress', '$consignorEmail', '$consignorPhone', '$consignorPincode', '$destination', '$consignorGst', '$d_vehicle_date', '$cus_state', '$rate', '$amount', '$cgst', '$sgst', '$igst', '$finalAmount', '$amountWords', '$order_date', '$sig_datetime', '$created_by' ) "; if (mysqli_query($conn, $sql)) { echo "Challan saved successfully"; } else { echo "Error saving road challan: " . mysqli_error($conn); } mysqli_close($conn); } else { header("Location: index.php"); exit(); }
| ver. 1.4 |
Github
|
.
| PHP 8.1.32 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка