prepare("UPDATE `company_master` SET `c_name` = ?, `c_short` = ?, `c_address` = ?, `c_email` = ?, `c_mobile` = ?, `c_pincode` = ?, `c_gstin` = ?, `c_state` = ?, `c_inv` = ?, `updated_at` = ? WHERE `id` = ?"); if ($stmt) { $stmt->bind_param("ssssssssssi", $c_name, $c_short, $c_address, $c_email, $c_mobile, $c_pincode, $c_gstin, $c_state, $c_inv, $updated_at, $id); if ($stmt->execute()) { echo ""; } else { echo "Error updating record: " . $stmt->error; } $stmt->close(); } else { echo "Failed to prepare statement: " . $conn->error; } exit; } // Fetch existing data $stmt = $conn->prepare("SELECT * FROM `company_master` WHERE `id` = ?"); $stmt->bind_param("i", $id); $stmt->execute(); $result = $stmt->get_result(); if ($result->num_rows === 0) { echo "Item not found."; exit; } $item = $result->fetch_assoc(); $stmt->close(); require_once('includes/header.php'); ?>

Edit Company Details

Cancel