customer_add.php

<?php
// customer_add.php
include 'header.php';
include 'sidebar.php';

$add_message = '';

// Handle form submission
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $customer_name = trim($_POST['customer_name']);
    $contact_no = trim($_POST['contact_no']);
    $status = trim($_POST['status']);

    $sql = "INSERT INTO customers (customer_name, contact_no, status) VALUES (?, ?, ?)";

    if ($stmt = $conn->prepare($sql)) {
        $stmt->bind_param("sss", $customer_name, $contact_no, $status);

        if ($stmt->execute()) {
            $add_message = "<div class='bg-green-100 border border-green-400 text-green-700 px-4 py-3 rounded relative mb-4'>New customer added successfully!</div>";
        } else {
            $add_message = "<div class='bg-red-100 border border-red-400 text-red-700 px-4 py-3 rounded relative mb-4'>Error: " . $stmt->error . "</div>";
        }
        $stmt->close();
    }
    $conn->close();
}
?>

<!-- Main Content -->
<div class="bg-white p-8 rounded-lg shadow-md w-full">
    <h4 class="text-2xl font-bold text-gray-700 mb-6">Add New Customer</h4>

    <?php echo $add_message; ?>

    <form action="customer_add.php" method="post">
        <div class="grid grid-cols-1 md:grid-cols-2 gap-6">
            <div>
                <label class="block text-gray-700 text-sm font-bold mb-2">Customer Name</label>
                <input type="text" name="customer_name" required
                    class="shadow border rounded w-full py-2 px-3 text-gray-700">
            </div>
            <div>
                <label class="block text-gray-700 text-sm font-bold mb-2">Contact No</label>
                <input type="text" name="contact_no" required
                    class="shadow border rounded w-full py-2 px-3 text-gray-700">
            </div>
            <div>
                <label class="block text-gray-700 text-sm font-bold mb-2">Status</label>
                <select name="status" class="shadow border rounded w-full py-2 px-3 text-gray-700">
                    <option value="Enable">Enable</option>
                    <option value="Disable">Disable</option>
                </select>
            </div>
        </div>

        <div class="mt-8 flex justify-end">
            <a href="customer_master.php"
                class="bg-gray-500 hover:bg-gray-600 text-white font-bold py-2 px-4 rounded mr-2">
                Back to List
            </a>
            <button type="submit" class="bg-pink-600 hover:bg-pink-700 text-white font-bold py-2 px-4 rounded">
                Add Customer
            </button>
        </div>
    </form>
</div>

<?php
include 'footer.php';
?>