| Server IP : 212.252.79.165 / Your IP : 216.73.216.24 [ Web Server : Apache System : Linux 212-252-79-165.cprapid.com 5.15.0-153-generic #163-Ubuntu SMP Thu Aug 7 16:37:18 UTC 2025 x86_64 User : cehaburo ( 1001) PHP Version : 8.1.33 Disable Function : exec,passthru,shell_exec,system Domains : 48 Domains MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/cehaburo/www/ |
Upload File : |
<?php
include('lib/include.php');
$search_term = $_POST['find_it'];
if (!preg_match('/[0-9]/', $search_term)) {
$product_result = $ceha->query("SELECT * FROM tbl_product
WHERE title_$lang LIKE '%$search_term%' AND active='1'
ORDER BY id");
} else {
$variation_result = $ceha->query("SELECT * FROM tbl_product_variation
WHERE title_$lang LIKE '%$search_term%' AND active='1'
ORDER BY id");
if ($variation_result->num_rows > 0) {
/* $variation = $variation_result->fetch_assoc();
$product_id = $variation['product_id'];
$product_result = $ceha->query("SELECT * FROM tbl_product
WHERE id='$product_id' AND active='1'
ORDER BY id"); */
$product_ids = array();
while ($variation = $variation_result->fetch_assoc()) {
$product_ids[] = $variation['product_id'];
}
$product_ids_string = implode(',', $product_ids);
$product_result = $ceha->query("SELECT * FROM tbl_product
WHERE id IN ($product_ids_string) AND active='1'
ORDER BY id");
} else {
}
}
$filter_product_result = $ceha->query("SELECT * FROM tbl_product WHERE category_id='$seo_id' AND active='1' ORDER BY id");
$filter_color_result = $ceha->query("SELECT * FROM tbl_product_colors WHERE active='1' ORDER BY id");
include('header.php');
?>
<main id="content" class="bg-white">
<section class="img-breadcrumb ptb--100 bg-img-cover-center" style="background-image: url('images/category/611f9f5a75e1d.jpg');">
<div class="img-breadcrumb-overlay"></div>
<div class="container">
<div class="row">
<div class="col-md-6">
<h2><?php echo $variable[47]; ?></h2>
<nav aria-label="breadcrumb text-white">
<ol class="breadcrumb py-0">
<li class="breadcrumb-item"><a href="<?php echo $page_url[1]; ?>"><?php echo $variable[18]; ?></a></li>
<li class="breadcrumb-item active" aria-current="page"><?php echo $variable[47]; ?></li>
</ol>
</nav>
</div>
</div>
</div>
</section>
<section class="py-7 pb-lg-13">
<div class="container">
<div id="filtered-products" class="row mt--50">
<?php
while ($product = $product_result->fetch_assoc()) {
$product_variation_result = $ceha->query("SELECT * FROM tbl_product_variation WHERE product_id='" . $product['id'] . "' AND active='1' ORDER BY sequence LIMIT 1");
$product_variation = $product_variation_result->fetch_assoc();
$product_data = $ceha->query("SELECT * FROM tbl_product WHERE id='" . $product['id'] . "' AND active='1' ORDER BY id");
$product_variation_data = $product_data->fetch_assoc();
$product_image_result = $ceha->query("SELECT * FROM tbl_product_image WHERE variation_id='" . $product_variation['id'] . "' AND active='1' ORDER BY sequence");
$product_image = $product_image_result->fetch_assoc();
?>
<div class="col-sm-6 col-lg-4 mb-8" data-animate="fadeInUp">
<div class="card border-0 hover-change-content product">
<div class="card-img-top position-relative">
<div style="background-image: url('<?php echo $product_image['image_url']; ?>')" class="card-img ratio bg-img-contain-center ratio-1-1"></div>
</div>
<div class="card-body px-0 pt-4 pb-0 d-flex align-items-end">
<div class="m-auto">
<div class="product-line"></div>
<a href="<?php echo $page_url[8]; ?>/<?php echo $product['id']; ?>" class="font-weight-bold mt-1 d-block text-center product-name"><?php echo $product_variation_data['title_' . $lang]; ?></a>
</div>
</div>
<div class="position-absolute pos-fixed-bottom px-4 px-sm-6 pb-5 d-flex w-100 justify-content-center content-change-horizontal">
<a href="<?php echo $page_url[8]; ?>/<?php echo $product['id']; ?>" title="<?php echo $variable[33]; ?>" class="inspect-product d-flex align-items-center justify-content-center"><?php echo $variable[33]; ?></a>
</div>
</div>
</div>
<?php } ?>
</div>
</div>
</section>
</main>
<?php include('footer.php'); ?>