One Hat Cyber Team
Your IP :
108.162.241.210
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
Eksekusi
Dir :
~
/
home
/
thuruk
/
public_html
/
App
/
New
/
Edit File:
get_map_news_feed.php
<?php /* include("connections.php"); //database connection $keyword = mysqli_real_escape_string($connect,$_POST['keyword']); $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 ORDER BY newuser_plants.created_time DESC LIMIT 20"; }else{ $query="SELECT * FROM `users` inner join `newuser_plants` WHERE users.user_id=newuser_plants.user_id AND newuser_plants.plant_name LIKE '%$keyword%'"; } $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);*/ ?> <?php include("connections.php"); //database connection $keyword = 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 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 LOWER(newuser_plants.location) LIKE LOWER('%$keyword%') ORDER BY newuser_plants.created_time"; }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"; }*/ } $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); ?>
Simpan