<?php 
include_once("include/main.inc.php"); 
// ini_set('display_errors', 1);
// ini_set('display_startup_errors', 1);
// error_reporting(E_ALL);
 if(isset($_POST['loadmores'])){
    $error = array('success' => false);
    $in = $_POST;
    if(empty($in['start']) || !ctype_digit($in['start'])){$error['msg'] = 'invalid start';}
    if(empty($in['whr'])){$error['msg'] = 'invalid start';}
    if(!isset($error['msg'])){
    $target_location = $_POST['loadmores'];
   $whr= $_POST['whr'];
   $start=$_POST['start'];
   $product_s = mysqli_query($GLOBALS['dbconn'], "select product_image,product_title,catalog,product_id,product_video,product_specfi from product_tbl where " .$whr." order by product_id desc limit ".$start.", 3");
                        $num = mysqli_num_rows($product_s);
                        if ($num > 0) {    ?>
                       

                        <!-- <div class="you_may">You may Also Like These</div> -->

                        <div class="allListing">
                            <?php $i = 1;
                                    while ($product_r = mysqli_fetch_array($product_s)) {
                                        $pro_image =  explode(',', $product_r['product_image']);
                                        $probig_img = $pro_image[0];
                                        $imgname = explode('.', $pro_image[0]);
                                        $prod_img = getImage($probig_img, 375, 375, $product_r['product_title'] . $imgname[0], "/uploaded-files/product-images/");
                                        $prod_imgsmall = getImage($probig_img, 47, 47, $product_r['product_title'], "/uploaded-files/product-images/");

                                    ?>

                            <div class="product_listing productlist">

                                <div class="row">

                                    <div class="col-xxl-4 col-xl-4 col-lg-4 col-md-4 col-sm-12 col-12">

                                        <div class="product">

                                            <div class="single_image">

                                                <a class="largeImage " href="javascript:void(0);" data-bs-toggle="modal"
                                                    data-bs-target="#productID" id="bigImage<?= $i; ?>"
                                                    onclick="var src = $(this).find('img.clickable-image').attr('src');$('.catID').val('<?php echo $product_r['product_id']; ?>');$('.catName').html('<?php echo $product_r['product_title']; ?>');  $('.catImg').attr('src', src); $('.catImg').attr('alt','<?= $product_r['product_title']; ?> Manufacturers, Suppliers, Exporters, Importers in <?=$target_location; ?>'); $('.catImg').attr('title','<?= $product_r['product_title']; ?> Manufacturers, Suppliers, Exporters, Importers in <?=$target_location; ?>');"
                                                    title="<?= $product_r['product_title']; ?> Manufacturers, Suppliers, Exporters, Importers in <?=$target_location; ?>">

                                                    <img id="myImage<?= $product_r['product_id']; ?>" src="<?= $prod_img; ?>"
                                                        class="clickable-image"
                                                        alt="<?= $product_r['product_title']; ?> Manufacturers, Suppliers, Exporters, Importers in <?=$target_location; ?>"
                                                        title="<?= $product_r['product_title']; ?> Manufacturers, Suppliers, Exporters, Importers in <?=$target_location; ?>">

                                                </a>

                                            </div>

                                            <div class="small<?= $i; ?>">

                                                <div class="slider d-flex justify-content-center">
                                                    <?php
                                                                if (!empty($pro_image[1])) {
                                                                    $snn = 1;
                                                                    foreach ($pro_image as $pro_imag_vals) { ?>


                                                    <div class="slides p-0 h-auto d-block m-1 bg-dark  <?= $snn == 1 ? 'active' : ''; ?>"
                                                        onclick="imgMulti(<?= $product_r['product_id']; ?>, '<?= getImage($pro_imag_vals, 375, 375, $product_r['product_title'] . $product_r['product_id'] . $snn, '/uploaded-files/product-images/'); ?>', this)">

                                                        <img src="<?= getImage($pro_imag_vals, 60, 60, $product_r['product_title'] . $product_r['product_id'] . $snn, '/uploaded-files/product-images/'); ?>"
                                                            class="w-100"
                                                            alt="<?= $product_r['product_title']; ?> Manufacturers, Suppliers, Exporters, Importers in <?=$target_location; ?>"
                                                            title="<?= $product_r['product_title']; ?> Manufacturers, Suppliers, Exporters, Importers in <?=$target_location; ?>">

                                                    </div>
                                                    <?php $snn++;
                                                                    }
                                                                } ?>
                                                    <!-- <div class="slides  p-0 h-auto d-block m-1 bg-dark "

                            onclick="imgMulti(1, 'designer/images/t-shirt.jpg', this)">

                            <img src="designer/images/t-shirt.jpg" class="w-100" alt="">

                        </div>

                        <div class="slides p-0 h-auto d-block m-1 bg-dark "

                            onclick="imgMulti(1, 'designer/images/Mens-Polo-Shirt.jpg', this)">

                            <img src="designer/images/Mens-Polo-Shirt.jpg" class="w-100"

                                alt="">

                        </div> -->

                                                </div>





                                            </div>

                                        </div>

                                    </div>

                                    <div class="col-xxl-8 col-xl-8 col-lg-8 col-md-8 col-sm-12 col-12">

                                        <div class="right-content">

                                            <h4 class="head"><?= $product_r['product_title']; ?> in <?=$target_location;?>

                                            </h4>

                                            <div class="blue-line1"></div>
                                            <?php if ($product_r['catalog'] != '') { ?>

                                            <div class="productBrochureandvideo">

                                                <a href="<?= site_url; ?>/uploaded-files/pdf/<?= $product_r['catalog']; ?>"
                                                    title="Product Brochure" target="_blank">

                                                    <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16"
                                                        fill="currentColor" class="bi bi-filetype-pdf"
                                                        viewBox="0 0 16 16">

                                                        <path fill-rule="evenodd"
                                                            d="M14 4.5V14a2 2 0 0 1-2 2h-1v-1h1a1 1 0 0 0 1-1V4.5h-2A1.5 1.5 0 0 1 9.5 3V1H4a1 1 0 0 0-1 1v9H2V2a2 2 0 0 1 2-2h5.5L14 4.5ZM1.6 11.85H0v3.999h.791v-1.342h.803c.287 0 .531-.057.732-.173.203-.117.358-.275.463-.474a1.42 1.42 0 0 0 .161-.677c0-.25-.053-.476-.158-.677a1.176 1.176 0 0 0-.46-.477c-.2-.12-.443-.179-.732-.179Zm.545 1.333a.795.795 0 0 1-.085.38.574.574 0 0 1-.238.241.794.794 0 0 1-.375.082H.788V12.48h.66c.218 0 .389.06.512.181.123.122.185.296.185.522Zm1.217-1.333v3.999h1.46c.401 0 .734-.08.998-.237a1.45 1.45 0 0 0 .595-.689c.13-.3.196-.662.196-1.084 0-.42-.065-.778-.196-1.075a1.426 1.426 0 0 0-.589-.68c-.264-.156-.599-.234-1.005-.234H3.362Zm.791.645h.563c.248 0 .45.05.609.152a.89.89 0 0 1 .354.454c.079.201.118.452.118.753a2.3 2.3 0 0 1-.068.592 1.14 1.14 0 0 1-.196.422.8.8 0 0 1-.334.252 1.298 1.298 0 0 1-.483.082h-.563v-2.707Zm3.743 1.763v1.591h-.79V11.85h2.548v.653H7.896v1.117h1.606v.638H7.896Z">

                                                        </path>

                                                    </svg>

                                                    <span>Product Brochure</span>

                                                </a>
                                                <?php } ?>
                                                <?php if ($product_r['product_video'] != '') { ?>
                                                <div class="item youtube">

                                                    <a data-fancybox=""
                                                        href="https://www.youtube.com/watch?v=<?= $product_r['product_video']; ?>">

                                                        <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16"
                                                            fill="currentColor" viewBox="0 0 16 16">

                                                            <path
                                                                d="m11.596 8.697-6.363 3.692c-.54.313-1.233-.066-1.233-.697V4.308c0-.63.692-1.01 1.233-.696l6.363 3.692a.802.802 0 0 1 0 1.393z">

                                                            </path>

                                                        </svg>

                                                    </a>

                                                </div>
                                                <?php } ?>
                                            </div>


                                            <div class="more_info">



                                                <?= html_entity_decode($product_r['product_specfi']); ?>

                                            </div>



                                            <div class="clearfix"></div>

                                            <a class="readMore" href="javascript:void(0);" data-bs-toggle="modal"
                                                data-bs-target="#productID"
                                                onclick="$('.catID').val('<?php echo $product_r['product_id']; ?>');$('.catName').html('<?php echo $product_r['product_title']; ?>');  $('.catImg').attr('src','<?= site_url; ?>/uploaded-files/product-images/<?= $probig_img; ?>'); $('.catImg').attr('alt','<?= $product_r['product_title']; ?> Manufacturers, Suppliers, Exporters in <?=$target_location; ?>'); $('.catImg').attr('title','<?= $product_r['product_title']; ?> Manufacturers, Suppliers, Exporters in <?=$target_location; ?>');"
                                                title="Get Best Quote">

                                                Get Best Quote <svg xmlns="http://www.w3.org/2000/svg" width="16"
                                                    height="16" fill="currentColor" viewBox="0 0 16 16">

                                                    <path
                                                        d="M.05 3.555A2 2 0 0 1 2 2h12a2 2 0 0 1 1.95 1.555L8 8.414.05 3.555ZM0 4.697v7.104l5.803-3.558L0 4.697ZM6.761 8.83l-6.57 4.027A2 2 0 0 0 2 14h12a2 2 0 0 0 1.808-1.144l-6.57-4.027L8 9.586l-1.239-.757Zm3.436-.586L16 11.801V4.697l-5.803 3.546Z" />

                                                </svg></a>

                                            <a class="readMore" href="javascript:void(0);" data-bs-toggle="modal"
                                                data-bs-target="#callback"
                                                onclick="$('.catID').val('<?php echo $product_r['product_id']; ?>'); $('.catName').html('<?php echo $product_r['product_title']; ?>');  $('.catImg').attr('src','<?= $prod_img; ?>'); $('.catImg').attr('alt','<?= $product_r['product_title']; ?> Manufacturers, Suppliers, Exporters in <?=$target_location; ?>'); $('.catImg').attr('title','<?= $product_r['product_title']; ?> Manufacturers, Suppliers, Exporters in <?=$target_location; ?>');"
                                                title="Request A Callback">

                                                Request A Callback <svg fill="currentColor" width="24px" height="24px"
                                                    viewBox="0 0 24 24" xmlns="http://www.w3.org/2000/svg">

                                                    <g data-name="Layer 2">

                                                        <g data-name="phone-call">

                                                            <rect width="24" height="24" opacity="0" />

                                                            <path
                                                                d="M13 8a3 3 0 0 1 3 3 1 1 0 0 0 2 0 5 5 0 0 0-5-5 1 1 0 0 0 0 2z" />

                                                            <path
                                                                d="M13 4a7 7 0 0 1 7 7 1 1 0 0 0 2 0 9 9 0 0 0-9-9 1 1 0 0 0 0 2z" />

                                                            <path
                                                                d="M21.75 15.91a1 1 0 0 0-.72-.65l-6-1.37a1 1 0 0 0-.92.26c-.14.13-.15.14-.8 1.38a9.91 9.91 0 0 1-4.87-4.89C9.71 10 9.72 10 9.85 9.85a1 1 0 0 0 .26-.92L8.74 3a1 1 0 0 0-.65-.72 3.79 3.79 0 0 0-.72-.18A3.94 3.94 0 0 0 6.6 2 4.6 4.6 0 0 0 2 6.6 15.42 15.42 0 0 0 17.4 22a4.6 4.6 0 0 0 4.6-4.6 4.77 4.77 0 0 0-.06-.76 4.34 4.34 0 0 0-.19-.73zM17.4 20A13.41 13.41 0 0 1 4 6.6 2.61 2.61 0 0 1 6.6 4h.33L8 8.64l-.54.28c-.86.45-1.54.81-1.18 1.59a11.85 11.85 0 0 0 7.18 7.21c.84.34 1.17-.29 1.62-1.16l.29-.55L20 17.07v.33a2.61 2.61 0 0 1-2.6 2.6z" />

                                                        </g>

                                                    </g>

                                                </svg></a>

                                        </div>

                                    </div>

                                </div>

                            
                            <script>
                            $('#small<?= $i; ?> .item').click(function() {
                                $('#bigImage<?= $i; ?> img').attr('src', $(this).attr('src').replace('thumb',
                                    'large'));
                                if ($(this).hasClass("active")) {
                                    $("#small<?= $i; ?> .item").removeClass("active");
                                } else {
                                    $("#small<?= $i; ?> .item").removeClass("active");
                                    $(this).addClass("active");
                                }
                            });
                            </script>
                            <?php $i++;
                                    } ?>




                        </div>
                        <?php } } } ?>
