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/en/ |
<?php
require "db_connection.php";
include "sessioncheck.php";
$sql = "select * from advertise where em_id =".$_SESSION['id']." AND id =".$_REQUEST['profile_id'];
$res = mysqli_query($connection,$sql);
if(mysqli_num_rows($res)==0){
header("location: ".SUB_URL."/myaccount");
}else{
$list = mysqli_fetch_array($res);
$qry = "SELECT * from advertise WHERE em_id=".$_SESSION['id'];
$ad_gallary = mysqli_query($connection,$qry);
while($ads=mysqli_fetch_array($ad_gallary)){
if($ads['id']==$list['id']){
$sql = "UPDATE advertise SET main_profile=1 WHERE id=".$list['id'];
mysqli_query($connection, $sql);
}else{
$sql = "UPDATE advertise SET main_profile=0 WHERE id=".$ads['id'];
mysqli_query($connection, $sql);
}
}
}
header("location: ".SUB_URL."/myaccount");
?>