:: **Zploit** v1.0 | Current Path: **/home/kreativepixelz/public_html/crm/**
:: Editing File: vcard_inquiry_add.php
<?php ob_start(); include 'header.php'; $page_title = "Add VCard Inquiry"; $page_parent = "VCards"; $page_parent_link = "vcard_list.php"; include 'breadcrumb.php'; include 'menu.php'; $message = ""; // ✅ Handle form submit if ($_SERVER['REQUEST_METHOD'] === 'POST') { $vcard_id = intval($_POST['vcard_id']); $name = mysqli_real_escape_string($conn, $_POST['name']); $phone = mysqli_real_escape_string($conn, $_POST['phone']); $email = mysqli_real_escape_string($conn, $_POST['email']); $msg = mysqli_real_escape_string($conn, $_POST['message']); $status = 1; if ($vcard_id == 0 || $name == '') { $message = "VCard and Name are required."; } if ($message == '') { $sql = "INSERT INTO vcard_inquiries (vcard_id, name, phone, email, message, status, created_at) VALUES ('$vcard_id', '$name', '$phone', '$email', '$msg', '$status', NOW())"; if (mysqli_query($conn, $sql)) { header("Location: vcard_inquiries_list.php?msg=Inquiry added successfully"); exit; } else { $message = "Database Error: " . mysqli_error($conn); } } } ?> <!-- ✅ Page Body --> <div class="page-body"> <div class="container-fluid"> <div class="row"> <div class="col-sm-12"> <div class="card"> <div class="card-header pb-0 card-no-border"> <h2>Add VCard Inquiry</h2> </div> <div class="card-body"> <?php if ($message): ?> <div class="alert alert-danger"><?= htmlspecialchars($message); ?></div> <?php endif; ?> <form method="POST"> <div class="row"> <div class="col-md-6"> <label class="form-label">Select VCard *</label> <select name="vcard_id" class="form-control" required> <option value="">-- Select VCard --</option> <?php $vcards = mysqli_query($conn, "SELECT id, full_name FROM vcards WHERE status=1 ORDER BY full_name"); while ($v = mysqli_fetch_assoc($vcards)) { echo "<option value='{$v['id']}'>" . htmlspecialchars($v['full_name']) . "</option>"; } ?> </select> </div> <div class="col-md-6"> <label class="form-label">Name *</label> <input type="text" name="name" class="form-control" required> </div> <div class="col-md-6 mt-3"> <label class="form-label">Phone</label> <input type="text" name="phone" class="form-control"> </div> <div class="col-md-6 mt-3"> <label class="form-label">Email</label> <input type="email" name="email" class="form-control"> </div> <div class="col-md-12 mt-3"> <label class="form-label">Message</label> <textarea name="message" class="form-control" rows="4"></textarea> </div> </div> <br> <div class="text-start"> <button type="submit" class="btn btn-success">Save Inquiry</button> <a href="vcard_inquiries_list.php" class="btn btn-secondary">Cancel</a> </div> </form> </div> </div> </div> </div> </div> </div> <?php include 'footer.php'; ob_end_flush(); ?>