Server : LiteSpeed System : Linux nl-srv-web1396.main-hosting.eu 4.18.0-553.83.1.lve.el8.x86_64 #1 SMP Wed Nov 12 10:04:12 UTC 2025 x86_64 User : u107206879 ( 107206879) PHP Version : 7.2.34 Disable Function : NONE Directory : /home/u107206879/domains/annoncelights.dk/public_html/admin/service/ |
<?php
include "../db_connection.php";
include "../sessioncheck.php";
if(!empty($_POST['value']) && !empty($_POST['slang'])){
$search_id = $_POST['value'];
$lang = $_POST['slang'];
#fetch the record of this Id
$sql=mysqli_query($connection,"SELECT * FROM search WHERE search_id=$search_id");
$row = mysqli_fetch_assoc($sql);
$data = array();
#now search whole table with same title
$sql_title=mysqli_query($connection,"SELECT * FROM search WHERE title='".$row['title']."'");
while($record=mysqli_fetch_assoc($sql_title)){
if(($lang==$lang_site_main_lang) && ($record['language']=="" || $record['language']==$lang_site_main_lang)){
$data = array();
$data = $record;
break;
}elseif($record['language']==$lang){
$data = array();
$data = $record;
break;
}
} //while($record=mysqli_fetch_assoc($sql))
}
echo json_encode(utf8ize($data));
?>