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/escort46.de/public_html/admin/service/ |
<?php
include "../db_connection.php";
include "../sessioncheck.php";
// Delete Multiple search
if($_POST['crud']=='delete_multi_search_tag')
{
if(!empty($_POST['value']))
{
$ids = $_POST['value'];
$deleteResult = delete('search', 'search_id in('.$ids.')');
if($deleteResult)
{
echo json_encode(
array(
"success" => true,
'message' => "Record deleted sucessfully...!",
//'deleted_ids' =>$ids
)
);
}
else
{
echo json_encode(
array(
"success" => false,
'message' => "Something went wrong please try again...!"
)
);
}
}
else
{
echo json_encode(
array(
"success" => false,
'message' => "Please select atleast one...!"
)
);
}
die;
}
// Delete Single search
if(isset($_POST['crud']) && ($_POST['crud']=='delete') && !empty($_POST['crud']) && isset($_POST['value']) && !empty($_POST['value'])){
$id = $_POST['value'];
#fetch the title
$sql=mysqli_query($connection,"SELECT * FROM search WHERE search_id='$id'");
$row=mysqli_fetch_assoc($sql);
$delete_ids = array();
#seatch the title in whole table and delete that
$sql_search=mysqli_query($connection,"SELECT * FROM `search` WHERE `title` LIKE '".$row['title']."' ");
while($row_search=mysqli_fetch_assoc($sql_search)){
array_push($delete_ids,$row_search["search_id"]);
}
mysqli_query($connection,"DELETE FROM search WHERE search_id IN (".implode(",", $delete_ids).") ");
echo '1';
}
?>