One Hat Cyber Team

Your IP : 172.69.214.198

Server IP : 188.114.96.3

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/

View File Name : get_news_id_list.php

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

        $session = mysqli_real_escape_string($connect,$_POST['session_id']);
    	$post_id = mysqli_real_escape_string($connect,$_POST['post_id']);

		$json;
		if($session!="5f0e6bfbafe255ds003434349") {
			$json['status'] = 400;
			$json['msg'] = 'Session Expired';
		} else {
			$rsData = array();
		
		    $query;
              
            $query="SELECT users.*,newuser_plants.*,plant_details.plant_details_id FROM `users` inner join `newuser_plants` inner join `plant_details` WHERE newuser_plants.user_plant_id='$post_id' AND  newuser_plants.plant_name=plant_details.title AND users.user_id=newuser_plants.user_id  ORDER BY newuser_plants.user_plant_id DESC";	
          
		    
            //            $query="SELECT * FROM `users` inner join `newuser_plants` WHERE newuser_plants.user_plant_id='$post_id' AND users.user_id=newuser_plants.user_id  ORDER BY //newuser_plants.user_plant_id DESC";	
	
		   $rs = mysqli_query($connect,$query) or die(mysqli_error($connect));

		   if($rs){
			   //location
			   	foreach($rs as $k => $v){
					$rsData[$k]['user_id'] = $v['user_id'];
					$rsData[$k]['name'] = $v['name'];
					$rsData[$k]['plant_name'] =  $v['plant_name'];
					$rsData[$k]['plant_description'] = $v['plant_description'];
					$rsData[$k]['created_date'] = $v['created_date'];
					$rsData[$k]['plant_image'] = $v['plant_image'];
					$rsData[$k]['location'] = $v['location'];
					$rsData[$k]['user_plant_id'] = $v['user_plant_id'];
					$rsData[$k]['status'] =  $v['status'];
					$rsData[$k]['profile'] =  $v['profile'];
                    $rsData[$k]['plant_details_id'] =  $v['plant_details_id'];
                         $rsData[$k]['lat'] =  $v['lat'];
                         $rsData[$k]['lng'] =  $v['lng'];
				}
			}
			$json['status'] = STATUS_OK;
			$json['msg'] = 'Success';
			$json['data'] = $rsData;
		}
//		header("Content-Type: application/json");
		
		echo json_encode($json);


?>