One Hat Cyber Team

Your IP : 108.162.241.225

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

Buat File | Buat Folder

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

Edit File: test1.php

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

$json;
	
			$rsData = array();
		
		    $query;
		    
		
		       	  $query="SELECT * FROM `users` inner join `user_plants` WHERE users.user_id=user_plants.user_id  ORDER BY user_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'];
				}
			}
			$json['status'] = 200;
			$json['msg'] = 'Success';
			$json['data'] = $rsData;
		
//		header("Content-Type: application/json");
		
		echo $json;
//json_encode( utf8_encode( $Content ) );

?>