One Hat Cyber Team

Your IP : 172.69.130.199

Server IP : 188.114.96.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

View File Name : plant_sub_list.php

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

		$post_id = mysqli_real_escape_string($connect,$_REQUEST['post_id']);
	    $session = mysqli_real_escape_string($connect,$_REQUEST['session_id']);
   //  $post_id = mysqli_real_escape_string($connect,$_REQUEST['post_id']);
		//$session = mysqli_real_escape_string($connect,$_REQUEST['session_id']);
		$json;

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

		   if($rs){
			   //location
			   	foreach($rs as $k => $v){

				
					$rsData[$k]['update_date'] =  $v['update_date'];
					$rsData[$k]['description'] = $v['description'];
					$rsData[$k]['image_url'] = $v['image_url'];
					$rsData[$k]['plant_image'] = $v['plant_image'];
					$rsData[$k]['location'] = $v['location'];
				
				}
			}
			$json['status'] = 200;
			$json['msg'] ='Success';
			$json['data'] = $rsData;
		}
	header("Content-Type: application/json");
		
		echo json_encode($json);


?>