<?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'])){
    $start = intval($_POST['start']);
   // now only receives category ID
    $target_location = $_POST['loadmores'];
    $heading = $_POST['heading'];
   $whr= $_POST['whr'];
   $start=$_POST['start'];
     $product_s= mysqli_query($GLOBALS['dbconn'],"select product_image,product_title,product_name,catalog,product_id,product_video,product_specfi from product_tbl WHERE " .$whr." order by product_id desc LIMIT $start, 2");


                          ?>
      <?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, 400, 600, $product_r['product_title'] . $product_r['product_id'] . $imgname['0'], "/uploaded-files/product-images/");
  $prod_imgsmall = getImage($probig_img, 175, 177, $product_r['product_title'] . $product_r['product_id'] . $imgname['0'], "/uploaded-files/product-images/");
  $productName = ($product_r['product_name'] != '') ? $product_r['product_name'] : $product_r['product_title'];
?>

                                            
                                            <div class="product_listing productlist">
                                             <div class="row">
                                                <div class="col-xxl-5 col-xl-5 col-lg-5 col-md-5 col-sm-5 col-12">
                                                   <div class="product productGallery">
                                                      <div class="single_image">
                                                         <a class="largeImage" id="bigImage<?= $i; ?>"
                                                            href="javascript:void(0);" data-bs-toggle="modal"
                                                            data-bs-target="#productID"
                                                            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 in <?= $admin_res['targetlocation']; ?>'); $('.catImg').attr('title','<?= $product_r['product_title']; ?> Manufacturers, Suppliers in <?= $admin_res['targetlocation']; ?>');"
                                                            title="<?= $product_r['product_title']; ?> Manufacturers, Suppliers in <?= $admin_res['targetlocation']; ?>">
                                                            <img id="myImage<?= $product_r['product_id']; ?>"
                                                               src="<?= $prod_img; ?>" class="clickable-image"
                                                               alt="<?= $product_r['product_title']; ?> Manufacturers, Suppliers in <?= $admin_res['targetlocation']; ?>"
                                                               title="<?= $product_r['product_title']; ?> Manufacturers, Suppliers in <?= $admin_res['targetlocation']; ?>">
                                                         </a>
                                                      </div>
                                                      <?php if (!empty($pro_image[1])) {
                                                         $snn = 1; ?>
                                                         <div class="small productThumbs">
                                                            <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, 450, 450, $product_r['product_title'] . $product_r['product_id'] . $snn, '/uploaded-files/product-images/'); ?>', this)">
                                                                        <img src="<?= getImage($pro_imag_vals, 100, 100, $product_r['product_title'] . $product_r['product_id'] . $snn, '/uploaded-files/product-images/'); ?>"
                                                                           class="w-100"
                                                                           alt="<?= $product_r['product_title']; ?> Manufacturers, Suppliers in <?= $admin_res['targetlocation']; ?>"
                                                                           title="<?= $product_r['product_title']; ?> Manufacturers, Suppliers in <?= $admin_res['targetlocation']; ?>">
                                                                     </div>
                                                               <?php $snn++;
                                                                  }
                                                               } ?>
                                                            </div>
                                                         </div>
                                                      <?php $snn++;
                                                      }  ?>
                                                   </div>
                                                </div>
                                                <div class="col-xxl-7 col-xl-7 col-lg-7 col-md-7 col-sm-7 col-12">
                                                   <div class="right-content">
                                                      <h4 class="productTitle"><?= $product_r['product_title']; ?></h4>
                                                      <div class="blue-line1"></div>
                                                      <div class="more_info infoDetails">
                                                         <div class="btn-grp">
                                                            <?php if ($product_r['catalog'] != '') { ?>
                                                               <div class="productBrochureandvideo">
                                                                  <a href="<?= site_url; ?>/uploaded-files/pdf/<?= $product_r['catalog']; ?>"
                                                                     title="<?= $product_r['product_title']; ?>"
                                                                     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>
                                                               </div>
                                                            <?php } ?>
                                                            <?php if ($product_r['product_video'] != '') { ?>
                                                               <a href="https://www.youtube.com/watch?v=QM8RDDBx55U"
                                                                  data-fancybox="" class="v-btn">
                                                                  <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>
                                                            <?php } ?>
                                                         </div>
                                                         <div class="mb-3">
                                                            <?= html_entity_decode($product_r['product_specfi']); ?>
                                                         </div>
                                                      </div>
                                                      <div class="clearfix"></div>
                                                      <a class="read_more_1 bg_btn_1" 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','<?= $prod_img; ?>'); $('.catImg').attr('alt','<?= $product_r['product_title']; ?> Manufacturers, Suppliers in <?= $admin_res['targetlocation']; ?>'); $('.catImg').attr('title','<?= $product_r['product_title']; ?> Manufacturers, Suppliers in <?= $admin_res['targetlocation']; ?>');"
                                                         title="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>
                                                         Get Best Quote <span></span>
                                                         <span></span>
                                                         <span></span>
                                                         <span></span>
                                                      </a>
                                                      <a 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_imgsmall; ?>'); $('.catImg').attr('alt','<?= $product_r['product_title']; ?> Manufacturers, Suppliers in <?= $admin_res['targetlocation']; ?>'); $('.catImg').attr('title','<?= $product_r['product_title']; ?> Manufacturers, Suppliers in <?= $admin_res['targetlocation']; ?>');"
                                                         class="read_more_1 bg_btn_1 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>
                                                         Request A Callback <span></span>
                                                         <span></span>
                                                         <span></span>
                                                         <span></span>
                                                      </a>
                                                   </div>
                                                </div>
                                             </div>
                                          </div>
                                           <?php $i++;
            } } }?>
            </div>