:: **Zploit** v1.0 | Current Path: **/home/kreativepixelz/www/crm/quatation/**
:: Editing File: coldstorage_add.php
<?php error_reporting(E_ALL); ini_set('display_errors', '1'); include_once("session.php"); include("db.php"); // database connection $user_id = $_SESSION['user_id']; if ($_SERVER['REQUEST_METHOD'] === 'POST') { print_r($_POST); echo $sql = "INSERT INTO cold_storage (grn_no, company_name, address, gst_no, pan_no, contact_person1, contact_phone1, contact_person2, contact_phone2, received_date, doc_type, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NOW())"; if ($stmt = $conn->prepare($sql)) { $stmt->bind_param( "sssssssssss", $_POST['grn_no'], $_POST['company_name'], $_POST['address'], $_POST['gst_no'], $_POST['pan_no'], $_POST['contact_person1'], $_POST['contact_phone1'], $_POST['contact_person2'], $_POST['contact_phone2'], $_POST['received_date'], $_POST['doc_type'] ); if ($stmt->execute()) { $_SESSION['success'] = "✅ Cold Storage entry added successfully!"; // optional notification insert $msg = "✅ Cold Storage entry added successfully!"; $type = "success"; $conn->query("INSERT INTO notifications (user_id, message, type) VALUES ('$user_id', '$msg', '$type')"); header("Location: coldstorage_list.php"); exit(); } else { $_SESSION['error'] = "❌ Error adding cold storage: " . $stmt->error; } $stmt->close(); } else { $_SESSION['error'] = "❌ Database error: " . $conn->error; } } include("header.php"); // page header ?> <main> <div class="container-fluid"> <!-- Breadcrumb start --> <div class="row m-1"> <div class="col-12"> <h4 class="main-title">Add Cold Storage</h4> <ul class="app-line-breadcrumbs mb-3"> <li> <a class="f-s-14 f-w-500" href="dashboard.php"> <i class="ph-duotone ph-bank f-s-16"></i> Home </a> </li> <li> <a class="f-s-14 f-w-500" href="coldstorage_list.php"> <i class="ph-duotone ph-table f-s-16"></i> Cold Storage List </a> </li> <li class="active"> <a class="f-s-14 f-w-500" href="#">Add Cold Storage</a> </li> </ul> </div> </div> <!-- Breadcrumb end --> <div class="row"> <div class="col-12"> <div class="card"> <div class="card-body"> <?php if (isset($_SESSION['success'])) { echo '<div class="alert alert-success" id="autoAlert">' . $_SESSION['success'] . '</div>'; unset($_SESSION['success']); } if (isset($_SESSION['error'])) { echo '<div class="alert alert-danger" id="autoAlert">' . $_SESSION['error'] . '</div>'; unset($_SESSION['error']); } ?> <form class="row g-3 app-form" method="post" action=""> <div class="col-md-6"> <label class="form-label">GRN No</label> <input class="form-control" name="grn_no" type="text" required> </div> <div class="col-md-6"> <label class="form-label">Company Name</label> <input class="form-control" name="company_name" type="text" required> </div> <div class="col-md-12"> <label class="form-label">Address</label> <textarea class="form-control" name="address" rows="2"></textarea> </div> <div class="col-md-6"> <label class="form-label">GST No</label> <input class="form-control" name="gst_no" type="text"> </div> <div class="col-md-6"> <label class="form-label">PAN No</label> <input class="form-control" name="pan_no" type="text"> </div> <div class="col-md-6"> <label class="form-label">Contact Person 1</label> <input class="form-control" name="contact_person1" type="text"> </div> <div class="col-md-6"> <label class="form-label">Contact Phone 1</label> <input class="form-control" name="contact_phone1" type="text"> </div> <div class="col-md-6"> <label class="form-label">Contact Person 2</label> <input class="form-control" name="contact_person2" type="text"> </div> <div class="col-md-6"> <label class="form-label">Contact Phone 2</label> <input class="form-control" name="contact_phone2" type="text"> </div> <div class="col-md-6"> <label class="form-label">Received Date</label> <input class="form-control" name="received_date" type="date"> </div> <div class="col-md-6"> <label class="form-label">Document Type</label> <input class="form-control" name="doc_type" type="text"> </div> <div class="col-12"> <button type="submit" class="btn btn-primary">Add Cold Storage</button> </div> </form> </div> </div> </div> </div> <?php include("footer.php"); ?>