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
require "../db_connection.php";
include "../sessioncheck.php";
$response = array();
if(!empty($_POST['id'])) {
$id = $_POST["id"];
$ad_id = $_POST["adid"];
$sql = "SELECT * FROM images WHERE ad_id = ".$ad_id;
$result = mysqli_query($connection,$sql);
$sql = "UPDATE images set is_profile = 0 WHERE ad_id=".$ad_id;
$result1 = mysqli_query($connection,$sql);
$sql = "UPDATE images set is_profile = 1 WHERE id=".$id;
$result2 = mysqli_query($connection,$sql);
$sql = "SELECT * FROM images WHERE ad_id = ".$ad_id." AND is_profile=1";
$result3 = mysqli_query($connection,$sql);
$row = mysqli_fetch_array($result3);
$response['images'] = MAIN_URL."/user_images/".$row['photo'];
$response['status'] = 1;
}
echo json_encode($response, true);
?>