One Hat Cyber Team

Your IP : 172.69.130.198

Server IP : 188.114.97.4

Server : Linux thuru 6.5.11-4-pve #1 SMP PREEMPT_DYNAMIC PMX 6.5.11-4 (2023-11-20T10:19Z) x86_64

Server Software : Apache/2.4.51 (Unix) OpenSSL/1.0.2k-fips

PHP Version : 7.3.33

Buat File | Buat Folder

Dir : ~/home/thuruk/public_html/App/New/

Edit File: search_results.php

<?php
   
         include("connections.php"); //database connection

$keyword = strtolower(mysqli_real_escape_string($connect,$_POST['keyword']));
        $type = mysqli_real_escape_string($connect,$_POST['type']);
        $session = mysqli_real_escape_string($connect,$_POST['session_id']);

$json;
		if($session !="5f0e6bfbafe255ds003434349") {
			$json['status'] = 400;
			$json['msg'] = 'Session Expired';
		} else {
			$rsData = array();
		
		    $query;
		    
            if($keyword==""){
              
                    $query="SELECT * FROM `users` inner join `newuser_plants` WHERE users.user_id=newuser_plants.user_id AND newuser_plants.status='activate' ORDER BY newuser_plants.created_time DESC LIMIT 20 ";
                //$query="SELECT * FROM `users` inner join `newuser_plants` WHERE users.user_id=newuser_plants.user_id  ORDER BY newuser_plants.created_time DESC LIMIT 20";

}else{
              
              
           /*if($type=="Location"){
                
                                $query="SELECT * FROM `users` inner join `newuser_plants` WHERE users.user_id=newuser_plants.user_id  AND newuser_plants.location LIKE '%$keyword%'";	
 
                
              }else{
                                $query="SELECT * FROM `users` inner join `newuser_plants` WHERE users.user_id=newuser_plants.user_id  AND newuser_plants.plant_name LIKE '%$keyword%'";	
 
                
                
              }*/

if($type=="Location"){

//    $query="SELECT * FROM `users` inner join `newuser_plants` WHERE users.user_id=newuser_plants.user_id  AND lower(newuser_plants.location) LIKE '%$keyword%'  ORDER BY newuser_plants.created_time DESC";	
                      
                        $query="SELECT * FROM `users` inner join `newuser_plants` WHERE users.user_id=newuser_plants.user_id AND newuser_plants.status='activate' AND lower(newuser_plants.location) LIKE '%$keyword%'  ORDER BY newuser_plants.created_time DESC  ";

}else{
                                                    $query="SELECT * FROM `users` inner join `newuser_plants` WHERE users.user_id=newuser_plants.user_id  AND LOWER(newuser_plants.plant_name) LIKE LOWER('%$keyword%') ORDER BY newuser_plants.created_time DESC";

}

$rs = mysqli_query($connect,$query) or die(mysqli_error($connect));

$word_array=array();
				if($rs){
					
					while ($row = mysqli_fetch_assoc($rs))
					{
					
						$word_array[] = $row;
					}
				}
          	$json['count'] =$keyword; 
			$json['status'] = 200;
			$json['msg'] = 'Success';
			$json['data'] = $word_array;
		}
    
        header("Content-Type: application/json");
		
		echo json_encode($json);

?>