<h2>Editing File: search.php</h2><form method='POST'>
        <textarea name='content' style='width:100%;height:400px;'>&lt;?include (&quot;itophead.php&quot;)?&gt;
&lt;?include (&quot;itopboat.php&quot;)?&gt;
&lt;?include (&quot;iwarranty.php&quot;)?&gt;
&lt;?include(&quot;iproductcategoryflag.php&quot;)?&gt;
&lt;? $searchkeywords=$_POST[&quot;searchkeywords&quot;]; 
   $searchkeywords = htmlspecialchars($searchkeywords); 
?&gt;
&lt;!-------------------------- Products starts -----------------------------&gt;
&lt;div class=&quot;container-fluid fluid0 bodybg py-5&quot;&gt;
 &lt;div class=&quot;container py-lg-5 pb-3&quot;&gt; 
  &lt;div class=&quot;row mb-3&quot;&gt;
    &lt;div class=&quot;col-md-12&quot;&gt;
	 &lt;h3 class=&quot;theading mb-2 pb-3&quot;&gt;Search results for &quot;&lt;?echo $searchkeywords?&gt;&quot;&lt;/h3&gt;
    &lt;/div&gt;
   &lt;/div&gt; 
 &lt;div class=&quot;row mx-0&quot;&gt; 
 &lt;?$scount = 0;
  $productquery=&quot;SELECT distinct productcategory.productno, product.pname FROM productcategory
   LEFT JOIN product ON productcategory.productno = product.productno 
   LEFT JOIN productdesc ON productcategory.productno = productdesc.productno 
   LEFT JOIN productfeatures ON productcategory.productno = productfeatures.productno 
   LEFT JOIN productfeaturesheading ON productcategory.productno = productfeaturesheading.productno 
   LEFT JOIN productshortfeatures ON productcategory.productno = productshortfeatures.productno 
   LEFT JOIN productkeywords ON productcategory.productno = productkeywords.productno 
   WHERE (product.pname LIKE &#039;%$searchkeywords%&#039; or productdesc.desc1 LIKE &#039;%$searchkeywords%&#039; or productfeatures.pfeaturepoint LIKE &#039;%$searchkeywords%&#039;  or productfeaturesheading.productfeaturesheading LIKE &#039;%$searchkeywords%&#039; or productshortfeatures.pshortfeaturepoint LIKE &#039;%$searchkeywords%&#039; or productkeywords.pagetitle LIKE &#039;%$searchkeywords%&#039;  or productkeywords.pagedesc LIKE &#039;%$searchkeywords%&#039; or productkeywords.keywords LIKE &#039;%$searchkeywords%&#039;  or productkeywords.categorydesc LIKE &#039;%$searchkeywords%&#039; or productkeywords.subcategorydesc LIKE &#039;%$searchkeywords%&#039; or productkeywords.subcategory2desc LIKE &#039;%$searchkeywords%&#039;) and product.pstatus=&#039;Active&#039;&quot;;
   $productquery_result = $obj-&gt;execute($productquery);
   foreach($productquery_result as $productquery_row){
   $scount++;
   $productno =$productquery_row[&quot;productno&quot;];
   $productname =$productquery_row[&quot;pname&quot;];

   //$pname =$productquery_row[&quot;pname&quot;];
  $product100_where=&quot;productno = $productno and pstatus=&#039;Active&#039;&quot;;
  $product100_orderby=&quot;ORDER BY productpriority asc&quot;;
  $product100_result = $obj-&gt;select_all_values(&#039;product&#039;, $product100_where, $product100_orderby);
  $count=0;
  foreach($product100_result as $product100_row){ 
   $count++;
   $productno =$product100_row[&quot;productno&quot;];
   $productname =$product100_row[&quot;pname&quot;];  
   $pstatus =$product100_row[&quot;pstatus&quot;];
   $pnamemask =$product100_row[&quot;pnamemask&quot;];
   
   
   $pdisplay=&#039;Yes&#039;;
   $productcategory_where=&quot;productno =$productno&quot;;
   $productcategory_orderby=&quot;ORDER BY categoryno asc&quot;;
   $productcategory_result = $obj-&gt;select_all_values(&#039;productcategory&#039;, $productcategory_where, $productcategory_orderby);
   foreach($productcategory_result as $productcategory_row){
    $categoryno =$productcategory_row[&quot;categoryno&quot;];
    $subcategoryno =$productcategory_row[&quot;subcategoryno&quot;];
    $subcategory2no =$productcategory_row[&quot;subcategory2no&quot;];
   }
   /*++++++++++++  productdetails starts+++++++++++++++++++++++++*/
	$productdetails_where=&quot;productno =$productno  and status=&#039;Active&#039;  order by `priority` asc LIMIT 1&quot;;
	 $productdetails_result = $obj-&gt;select_all_values(&#039;productdetails&#039;, $productdetails_where,&#039;&#039;);
	 foreach($productdetails_result as $productdetails_row){
	  $productdetailsno  = $productdetails_row[&quot;productdetailsno&quot;]; 
	  $specialoffer  = $productdetails_row[&quot;specialoffer&quot;];
	  $newarrivals = $productdetails_row[&quot;newarrivals&quot;];
	  $hotdeals = $productdetails_row[&quot;hotdeals&quot;];
	  $featuredproduct = $productdetails_row[&quot;featuredproduct&quot;];
	  $bestseller = $productdetails_row[&quot;bestseller&quot;];
	  $storagespace = $productdetails_row[&quot;storagespace&quot;];
	  $status = $productdetails_row[&quot;status&quot;];  
	 /*++++++++++++  productdetails ends+++++++++++++++++++++++++*/
	 /*++++++++++++  productcolors and productimages starts+++++++++++++++++++++++++*/
	  $productcolors_where=&quot;productno =$productno order by priority asc LIMIT 1&quot;;
	  $productcolors_result = $obj-&gt;select_all_values(&#039;productcolors&#039;, $productcolors_where,&#039;&#039;);
	  foreach($productcolors_result as $productcolors_row){
	   $productcolorsno = $productcolors_row[&quot;productcolorsno&quot;];
	   $colorname = $productcolors_row[&quot;colorname&quot;];
	   $colorcode = $productcolors_row[&quot;colorcode&quot;];
	  }
	 $productimages_wherecondition = &quot;productno =$productno and productcolorsno=$productcolorsno&quot;;
	  $productimages_tcount1=$obj-&gt;totalrecords_condition(&#039;productimages&#039;, &#039;*&#039;, $productimages_wherecondition);
	  foreach($productimages_tcount1 as $productimages_row ){
	   $productimages_tcount=$productimages_row[&#039;count(*)&#039;];
	  }
	  if ($productimages_tcount&lt;&gt;0) { 
		$productimages_where=&quot;productno=$productno and productcolorsno=$productcolorsno&quot;;
		 $productimages_orderby=&quot;ORDER BY priority  asc LIMIT 1&quot;;
		 $productimages_result = $obj-&gt;select_all_values(&#039;productimages&#039;, $productimages_where, $productimages_orderby);
		 foreach($productimages_result as $productimages_row){
		  $productimagesno =$productimages_row[&quot;productimagesno&quot;];
		 $pimg=$productimages_row[&quot;pimg&quot;];
		 }
	  }
	  /*++++++++++++  productcolors ends+++++++++++++++++++++++++*/
	 /*++++++++++++  productfeatureshead starts+++++++++++++++++++++++++*/
		$productfeatureshead_wherecondition = &quot;productno =$productno&quot;;
		$productfeatureshead_tcount1=$obj-&gt;totalrecords_condition(&#039;productfeatureshead&#039;, &#039;*&#039;, $productfeatureshead_wherecondition);
		foreach($productfeatureshead_tcount1 as $productfeatureshead_row ){
		$productfeatureshead_tcount=$productfeatureshead_row[&#039;count(*)&#039;];
		}
		if ($productfeatureshead_tcount&lt;&gt;0) {
		$productfeatureshead_where=&quot;productno =$productno LIMIT 1&quot;;
		$productfeatureshead_result = $obj-&gt;select_all_values(&#039;productfeatureshead&#039;, $productfeatureshead_where,&#039;&#039;);
		foreach($productfeatureshead_result as $productfeatureshead_row){
		$pfeaturehead = $productfeatureshead_row[&quot;pfeaturehead&quot;];
		$pfeaturedesc = $productfeatureshead_row[&quot;pfeaturedesc&quot;];
		}
		}
		/*++++++++++++  productfeatureshead ends+++++++++++++++++++++++++*/
		$productprices_where=&quot;productno =$productno and productdetailsno=$productdetailsno&quot;;
		$productprices_result = $obj-&gt;select_all_values(&#039;productprices&#039;, $productprices_where,&#039;&#039;);
		foreach($productprices_result as $productprices_row){
		 $enduserprice = $productprices_row[&quot;enduserprice&quot;];
		 $specialofferprice = $productprices_row[&quot;specialofferprice&quot;];
		}		
  ?&gt;
  &lt;?if ($pdisplay&lt;&gt;&#039;No&#039;) {?&gt;
  
  &lt;!--------------- product1 starts ---------------&gt;
  &lt;div class=&quot;col-12 col-sm-6 col-lg-4 col-xl-3 d-flex boxpadding px-2&quot;&gt;
     &lt;div class=&quot;card&quot;&gt;
	 &lt;a href=&quot;&lt;?echo $mainurlindex;?&gt;Productdetails/&lt;?echo $productno?&gt;/&lt;?echo $brandsno?&gt;/&lt;?echo $categoryno?&gt;/&lt;?echo $pnamemask?&gt;/&lt;?echo $productdetailsno?&gt;&quot;&gt;
	 &lt;div class=&quot;card-header&quot;&gt;
	 &lt;?if ($newarrivals&lt;&gt;&quot;No&quot;){?&gt;	   
	   &lt;span class=&quot;saleoffer&quot;&gt;New&lt;/span&gt;
		&lt;?}?&gt;
      &lt;?if ($specialofferprice&lt;&gt;0.00){?&gt;
	    &lt;?  
		  $percentcal=$specialofferprice*100; 
	      $get_perprice=$percentcal/$enduserprice;
	      $totperoffer=100-round($get_perprice);
		  ?&gt;	   
	    &lt;span class=&quot;saleofferright&quot;&gt;&lt;?echo $totperoffer?&gt; % OFF &lt;/span&gt;
		&lt;?}?&gt;		
        &lt;? if ($productimages_tcount&lt;&gt;0) { ?&gt;
        &lt;img src=&quot;&lt;?echo $mainurlindex;?&gt;productimages/&lt;?echo $pimg;?&gt;&quot; class=&quot;card-img-top&quot; alt=&quot;&lt;?echo $pnamemask?&gt;&quot; title=&quot;&lt;?echo $pnamemask?&gt;&quot;/&gt;
		&lt;? } else { ?&gt;
       &lt;img src=&quot;&lt;?echo $mainurlindex;?&gt;img/productnoimage.jpg&quot; class=&quot;card-img-top&quot; alt=&quot;&lt;?echo $pnamemask?&gt;&quot; title=&quot;&lt;?echo $pnamemask?&gt;&quot;&gt;
	   &lt;? } ?&gt;
	  &lt;/div&gt;
	 &lt;hr class=&quot;cardline my-0 mx-3&quot;&gt;&lt;/hr&gt;
    
      &lt;div class=&quot;card-body d-flex flex-column&quot;&gt;
       &lt;h5 class=&quot;card-title&quot;&gt;&lt;? if ($productname&lt;&gt;&quot;&quot;) { ?&gt; &lt;?echo $productname?&gt;&lt;? } ?&gt;&lt;? if ($colorname&lt;&gt;&quot;&quot;) { ?&gt;, &lt;?echo $colorname?&gt;&lt;? } ?&gt;&lt;? if ($storagespace&lt;&gt;&quot;&quot;) { ?&gt;, &lt;?echo $storagespace?&gt;&lt;? } ?&gt;&lt;/h5&gt;
	    &lt;? 		
		$productshortfeatures_wherecondition = &quot;productno =$productno&quot;;
		$productshortfeatures_tcount1=$obj-&gt;totalrecords_condition(&#039;productshortfeatures&#039;, &#039;*&#039;, $productshortfeatures_wherecondition);
		foreach($productshortfeatures_tcount1 as $productshortfeatures_row ){
		$productshortfeatures_tcount=$productshortfeatures_row[&#039;count(*)&#039;];
		}
		?&gt;
         &lt;ul class=&quot;mb-0 hotdealfeature ps-4 pb-3&quot;&gt;
		 &lt;? if ($productshortfeatures_tcount&lt;&gt;0) { ?&gt;
		&lt;?
		$productshortfeatures_where=&quot;productno =$productno ORDER BY  RAND()  LIMIT 4 &quot;;
		$productshortfeatures_result = $obj-&gt;select_all_values(&#039;productshortfeatures&#039;, $productshortfeatures_where,&#039;&#039;);
		foreach($productshortfeatures_result as $productshortfeatures_row){
		$pshortfeaturepoint = $productshortfeatures_row[&quot;pshortfeaturepoint&quot;];
		?&gt;
           &lt;li&gt;&lt;?echo $pshortfeaturepoint?&gt;&lt;/li&gt;  
		 &lt;? } ?&gt;
		 &lt;/ul&gt;
		 &lt;? } ?&gt;
	&lt;div class=&quot;card-footer mt-auto&quot;&gt;	 		 
     &lt;?if ($specialofferprice&lt;&gt;0.00){?&gt;
	   &lt;div class=&quot;row mt-auto pb-2&quot;&gt;
		  &lt;div class=&quot;col-6 pe-0&quot;&gt;
			 &lt;p class=&quot;tprice mb-0&quot;&gt;&lt;span class=&quot;toldprice&quot;&gt;was AED &lt;?echo number_format($enduserprice)?&gt;&lt;/span&gt;&lt;/p&gt;
			&lt;/div&gt;
			&lt;div class=&quot;col-6 text-end&quot;&gt;
			 &lt;p class=&quot;tprice mb-0&quot;&gt;&lt;span class=&quot;&quot;&gt;AED &lt;?echo number_format($specialofferprice)?&gt;&lt;/span&gt;&lt;/p&gt;
			&lt;/div&gt;
		&lt;/div&gt;
	   &lt;? } else { ?&gt;
	     &lt;div class=&quot;row mt-auto pb-2&quot;&gt;
		  &lt;div class=&quot;col-12&quot;&gt;
	       &lt;p class=&quot;tprice mb-0&quot;&gt;&lt;span class=&quot;&quot;&gt;AED &lt;?echo number_format($enduserprice)?&gt;&lt;/span&gt;&lt;/p&gt;
	      &lt;/div&gt;
		&lt;/div&gt;
	    &lt;? } ?&gt;

	   &lt;hr class=&quot;cardbottomline &quot; style=&quot;margin: 0px 0px 11px 0px;&quot;&gt;&lt;/hr&gt;
       &lt;div class=&quot;row mt-auto&quot;&gt;
	    &lt;div class=&quot;col-6 pe-0 pe-lg-1&quot;&gt;
	      &lt;a href=&quot;&lt;?echo $mainurlindex;?&gt;Productdetails/&lt;?echo $productno?&gt;/&lt;?echo $brandsno?&gt;/&lt;?echo $categoryno?&gt;/&lt;?echo $pnamemask?&gt;/&lt;?echo $productdetailsno?&gt;&quot;&gt;&lt;button type=&quot;button&quot; class=&quot;btn viewbutton btn btn-block&quot;&gt;&lt;/button&gt;&lt;/a&gt;
	    &lt;/div&gt;
	    &lt;div class=&quot;col-6 ps-0 text-end&quot;&gt;
	     &lt;a href=&quot;&lt;?echo $mainurlindex;?&gt;addtocart.php?productno=&lt;?echo $productno?&gt;&amp;productdetailsno=&lt;?echo $productdetailsno?&gt;&amp;productcolorsno=&lt;?echo $productcolorsno?&gt;&amp;quantity=1&amp;brandsno=&lt;?echo $brandsno?&gt;&amp;categoryno=&lt;?echo $categoryno?&gt;&amp;pnamemask=&lt;?echo $pnamemask?&gt;&quot;&gt;&lt;button type=&quot;submit&quot; class=&quot;btn addcartbutton btn btn-block&quot;&gt;&lt;/button&gt;&lt;/a&gt;
	    &lt;/div&gt; 
	   &lt;/div&gt;
      &lt;/div&gt;
	   &lt;/div&gt;
	  &lt;/a&gt;
     &lt;/div&gt;
	&lt;/div&gt;
	&lt;style&gt;
	 .card-footer { 
 padding: 0px;
 background-color: #FFFFFF;
 border-top: none!important;
}
	&lt;/style&gt;
  &lt;!--------------- product1 ends ---------------&gt;
 &lt;? } ?&gt;
 &lt;? } ?&gt;
  &lt;? } ?&gt;
  &lt;? } ?&gt;
  &lt;/div&gt;
  
&lt;!-------------------------- no Products  ---------------&gt; 
&lt;?if ($scount&lt;&gt;0) { }else {?&gt;   
  &lt;div class=&quot;row mx-0&quot;&gt;
   &lt;div class=&quot;col-12 my-auto px-0&quot;&gt;
     &lt;p class=&quot;ttext mb-5&quot;&gt;There are no active products...&lt;/p&gt;
   &lt;/div&gt; 
  &lt;/div&gt;
&lt;?}?&gt;
&lt;!-------------------------- no Products  ---------------&gt;  
 &lt;/div&gt;
&lt;/div&gt;
&lt;!--------------------------- Products ends ------------------------------&gt;
 &lt;style&gt;
.hotdealfeature li {
 list-style: none;
 list-style-image: url(http://www.boat-t.com/img/icon-greentick.jpg);
 font-family: &#039;Roboto&#039;, sans-serif;
 font-size: 16px;
 font-weight: 400;
 color: #777777;
 line-height: 27px;
 padding-left: 5px;
}
&lt;/style&gt;
&lt;?include (&quot;ibottomboat.php&quot;)?&gt;</textarea><br>
        <button type='submit'>💾 Save</button>
        <a href='?path=/home3/boattkbl/public_html'>❌ Cancel</a>
    </form>