📁 File Manager
Editing:
/home/wedigitalindia/public_html/manralsolar.com/product-detail.php
<?php include_once('include/head.php'); ?> <body> <div class="main-page-wrapper"> <?php include_once('include/header.php'); ?> <?php /* ========================================================= INITIAL VARIABLES ========================================================= */ $slug = isset($_GET['slug']) ? trim($_GET['slug']) : ''; $tid = ''; $p_id = ''; $p_name = ''; $p_description23 = ''; $p_short_description23 = ''; $img = ''; $contact_success = ''; $contact_error = ''; $name = ''; $phone = ''; $email = ''; $message = ''; /* ========================================================= GET PRODUCT USING SLUG ========================================================= */ if ($slug == '') { header("Location: " . path() . "/404.php"); exit; } $slug_safe = mysqli_real_escape_string($conn, $slug); $query = mysqli_query( $conn, "SELECT * FROM tbl_product WHERE slug = '$slug_safe' LIMIT 1" ); /* ========================================================= PRODUCT NOT FOUND ========================================================= */ if (!$query || mysqli_num_rows($query) == 0) { header("Location: " . path() . "/404.php"); exit; } /* ========================================================= GET PRODUCT DATA ========================================================= */ $record = mysqli_fetch_assoc($query); $tid = $record['p_id']; $p_id = $record['p_id']; $p_name = $record['p_name']; $p_description23 = $record['p_description']; $p_short_description23 = $record['p_short_description']; /* ========================================================= GET PRODUCT IMAGE ========================================================= */ $p_id_safe = mysqli_real_escape_string($conn, $p_id); $photo = mysqli_query( $conn, "SELECT * FROM tbl_product_photo WHERE p_id = '$p_id_safe' LIMIT 1" ); if ($photo && mysqli_num_rows($photo) > 0) { $rok = mysqli_fetch_assoc($photo); $img = $rok['photo']; } /* ========================================================= ENQUIRY FORM SUBMISSION ========================================================= */ if (isset($_POST['submit_contact'])) { $name = trim($_POST['name'] ?? ''); $phone = trim($_POST['phone'] ?? ''); $email = trim($_POST['email'] ?? ''); /* * Message is optional */ $message = trim($_POST['message'] ?? ''); /* ===================================================== VALIDATION ===================================================== */ if ($name == '') { $contact_error = 'Please enter your name.'; } elseif ($phone == '') { $contact_error = 'Please enter your phone number.'; } elseif ($email == '') { $contact_error = 'Please enter your email address.'; } elseif (!filter_var($email, FILTER_VALIDATE_EMAIL)) { $contact_error = 'Please enter a valid email address.'; } else { /* ================================================= PRODUCT AUTOMATICALLY FROM CURRENT SLUG ================================================= */ $product = $p_name; /* ================================================= ADD INFO ================================================= */ $add_info = "Product: " . $product; if ($message != '') { $add_info .= "\nMessage: " . $message; } /* ================================================= ESCAPE DATA ================================================= */ $name_safe = mysqli_real_escape_string( $conn, $name ); $phone_safe = mysqli_real_escape_string( $conn, $phone ); $email_safe = mysqli_real_escape_string( $conn, $email ); $add_info_safe = mysqli_real_escape_string( $conn, $add_info ); /* ================================================= REQUIRED DATABASE FIELD cust_b_lname is NOT NULL in your table. We don't have this field in the form, so save an empty value. ================================================= */ $cust_b_lname = ''; $cust_b_lname_safe = mysqli_real_escape_string( $conn, $cust_b_lname ); /* ================================================= DATE + STATUS ================================================= */ $cust_datetime = date('Y-m-d H:i:s'); $cust_status = 1; /* ================================================= INSERT INTO tbl_customer ================================================= */ $insert_sql = " INSERT INTO tbl_customer ( cust_name, cust_email, cust_phone, cust_b_lname, add_info, cust_datetime, cust_status ) VALUES ( '$name_safe', '$email_safe', '$phone_safe', '$cust_b_lname_safe', '$add_info_safe', '$cust_datetime', '$cust_status' ) "; include_once('send_mail.php'); } } ?> <style> .product-enquiry-box { padding: 25px; background: #fff; border: 1px solid #eee; box-shadow: 0 10px 35px rgba(0, 0, 0, 0.08); } .product-enquiry-box h3 { font-size: 28px; font-weight: 700; color: #222; } .product-enquiry-form .form-control { width: 100%; height: 40px; border: 1px solid #ddd; border-radius: 4px; padding: 0 16px; font-size: 15px; color: #222 !important; background: #fff; } .w-100 { border-radius: 10px; } .product-enquiry-form textarea.form-control { height: 100px; padding: 15px 16px; resize: vertical; } .product-enquiry-form .form-control:focus { border-color: #ff6f01; box-shadow: 0 0 0 3px rgba(255, 111, 1, 0.08); outline: none; } .product-enquiry-form .form-control::placeholder { color: #555 !important; opacity: 1 !important; } .product-enquiry-form button { min-width: 170px; height: 52px; color: #fff; font-weight: 600; border-radius: 4px; } .product-enquiry-success { padding: 12px 15px; margin-bottom: 20px; background: #eaf8ee; border: 1px solid #b9e7c6; color: #217a35; border-radius: 4px; font-size: 14px; } .product-enquiry-error { padding: 12px 15px; margin-bottom: 20px; background: #fff1f1; border: 1px solid #f0bcbc; color: #c62828; border-radius: 4px; font-size: 14px; } @media (max-width: 767px) { .product-enquiry-box { padding: 25px 20px; margin-top: 20px; } .product-enquiry-box h3 { font-size: 24px; } } </style> <main> <!-- ===================================================== PAGE TITLE ====================================================== --> <div class="page-title-area text-center pt-100 pb-100 pt-lg-130 pb-lg-130" data-background="assets/img/bg/main-bg.png"> <div class="container"> <h2 class="page-title mb-15"> <?php echo htmlspecialchars( $p_name, ENT_QUOTES, 'UTF-8' ); ?> </h2> </div> </div> <!-- ===================================================== SERVICE DETAILS SECTION ====================================================== --> <div class="service-details-section pt-150 pt-lg-100 pb-95 pb-lg-60"> <div class="container"> <div class="row"> <div class="col-lg-12 ps-xxl-5"> <div class="service-details-content mb-60"> <!-- ================================================= PRODUCT IMAGE + ENQUIRY FORM ================================================== --> <div class="row align-items-center"> <!-- ================================================= LEFT - PRODUCT IMAGE ================================================== --> <div class="col-md-6"> <div class="img-box mb-30"> <?php if ($img != '') { ?> <img class="w-100" src="<?php path(); ?>/admin/assets/images/product-image/<?php echo htmlspecialchars($img, ENT_QUOTES, 'UTF-8'); ?>" alt="<?php echo htmlspecialchars($p_name, ENT_QUOTES, 'UTF-8'); ?>"> <?php } ?> </div> </div> <!-- ================================================= RIGHT - ENQUIRY FORM ================================================== --> <div class="col-md-6"> <div class="product-enquiry-box"> <h3 class="mb-20"> Enquire Now </h3> <!-- ================================================= SUCCESS MESSAGE ================================================== --> <?php if ($contact_success != '') { ?> <div class="product-enquiry-success"> <?php echo htmlspecialchars( $contact_success, ENT_QUOTES, 'UTF-8' ); ?> </div> <?php } ?> <!-- ================================================= ERROR MESSAGE ================================================== --> <?php if ($contact_error != '') { ?> <div class="product-enquiry-error"> <?php echo htmlspecialchars( $contact_error, ENT_QUOTES, 'UTF-8' ); ?> </div> <?php } ?> <!-- ================================================= ENQUIRY FORM ================================================== --> <form method="POST" action="" class="product-enquiry-form"> <div class="row"> <!-- NAME --> <div class="col-md-6 mb-3"> <input type="text" name="name" class="form-control" placeholder="Name" value="<?php echo htmlspecialchars($name, ENT_QUOTES, 'UTF-8'); ?>" required> </div> <!-- PHONE --> <div class="col-md-6 mb-3"> <input type="text" name="phone" class="form-control phone" placeholder="Phone" value="<?php echo htmlspecialchars($phone, ENT_QUOTES, 'UTF-8'); ?>" required> </div> <!-- EMAIL --> <div class="col-md-6 mb-3"> <input type="email" name="email" class="form-control" placeholder="Email" value="<?php echo htmlspecialchars($email, ENT_QUOTES, 'UTF-8'); ?>" required> </div> <!-- ================================================= PRODUCT AUTOMATIC FROM CURRENT SLUG ================================================== --> <div class="col-md-6 mb-3"> <input type="text" class="form-control" value="<?php echo htmlspecialchars($p_name, ENT_QUOTES, 'UTF-8'); ?>" readonly> </div> <!-- ================================================= MESSAGE - OPTIONAL ================================================== --> <div class="col-md-12 mb-3"> <textarea name="message" class="form-control" rows="5" placeholder="Message"><?php echo htmlspecialchars($message, ENT_QUOTES, 'UTF-8'); ?></textarea> </div> <div class="g-recaptcha form-group col-md-12 mb-3" data-sitekey="6LdWhb8qAAAAABZO-gA6yiy-qRXSflpUAnbAQtgt"></div> <!-- SUBMIT --> <div class="col-md-12"> <button type="submit" name="submit_contact" class="btn btn-brand" style="background:#ff6f01; border-color:#ff6f01;"> Send <i class="bi bi-arrow-right"></i> </button> </div> </div> </form> </div> </div> </div> <!-- ================================================= PRODUCT DESCRIPTION ================================================== --> <p> <?php echo $p_description23; ?> </p> </div> </div> </div> </div> </div> </main> <?php include_once('include/footer.php'); ?> </div> </body> </html>
Save
Cancel