1#@!#!123s

https 1#@!#!123s
: / home2 / affluencebiotech / public_html / alfa-resurs.co.uk /
Filename : product.php
back
<?php include "header.php"; ?>
<?php
require 'DB/db.php'; // Include the database connection file

$page_flname = $_REQUEST['file_name'];

$flname1 = str_replace(".php", "", $page_flname);
    
$flname = strtolower($flname1);
$sql = "SELECT * FROM products WHERE slug = '$flname'"; // Query to fetch product details

$result = $conn->query($sql);

if ($result->num_rows > 0) {
    $row = $result->fetch_assoc();
?>


    <main>
        <!-- breadcrumb_section - start
				================================================== -->
                
		<section class="page-title p_relative centred">
            <div class="bg-layer" style="background-image:url(imgupload/pUpload/<?php echo $row['p_img']; ?>);"></div>
            <div class="auto-container">
                <div class="content-box">
                    <h1><?php echo $row['p_name']; ?></h1>
                    <ul class="bread-crumb clearfix">
                        <li><a href="index.php">Home</a></li>
                        <li>products</li>
                    </ul>
                </div>
            </div>
        </section>
        <section class="shop-details pt_150 pb_90">
            <div class="auto-container">
                <div class="shop-details-content mb_100">
                    <div class="row clearfix">
                        <div class="col-lg-12 col-md-12">
                            <h3 class="shop-detail_title"><?php echo $row['p_name']; ?></h3>
                            <br>
                            <div class="table table-border"><?php echo $row['p_sec']; ?></div>
                        </div>
                        <div class="col-lg-6 col-md-12 col-sm-12 image-column">
                            <figure class="image-box"><a href="" class="lightbox-image" data-fancybox="gallery"><img src="imgupload/pUpload/<?php echo $row['p_img']; ?>" alt=""></a></figure>
                        </div>
                        <div class="col-lg-6 col-md-12 col-sm-12 content-column">
                            <div class="content-box ml_30">
                            <div class="table table-border"><?php echo $row['p_des']; ?></div>
                               <!--<button type="submit" type="button" class="theme-btn btn-one text-uppercase btns" data-bs-toggle="modal" data-bs-target="#exampleModal">I am Interested</button>-->
                              
                                <div class="btn-box">
                                <a class="theme-btn btn-one" data-bs-toggle="modal" data-bs-target="#exampleModal">I am Interested</a>
                                <a href="pay" style="border:2px solid #222222; " class="theme-btn btn-two" bis_skin_checked="1"><span style="color:#222222">Buy Now</span></a>
                            </div>
                            </div>
                        </div>
                    </div>
                </div>
  </div>
  </div>
<?php }

 include 'footer.php' ?>