'; // print_r($_POST); // die(); $product_name = $_POST['product_name']; $hsn = $_POST['hsn']; $cgst = $_POST['cgst']; $sgst = $_POST['sgst']; $igst = $_POST['igst']; $created_at = date('Y-m-d H:i:s'); $stmt = $conn->prepare("INSERT INTO `hsn_master` (`product_name`, `hsn`, `cgst`, `sgst`, `igst`, `created_at`) VALUES (?, ?, ?, ?, ?, ?)"); if ($stmt) { // Bind parameters: s = string, s = string, s = string $stmt->bind_param("ssssss", $product_name, $hsn, $cgst, $sgst, $igst, $created_at); // Execute the statement if ($stmt->execute()) { echo ""; // Optionally redirect or clear form here } else { echo "Error executing query: " . $stmt->error; } $stmt->close(); } else { echo "Failed to prepare statement: " . $conn->error; } } require_once('includes/header.php'); ?>

HSN Dashboard

HSN's Inventory
query($query); if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { // Determine status label and badge class echo ""; } } else { echo ''; } ?>
ID Product HSN Code CGST(%) SGST(%) IGST(%) Actions
{$row['id']} {$row['product_name']} {$row['hsn']} {$row['cgst']} {$row['sgst']} {$row['igst']}
No records found.