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/ |
<?php
$error = "";
$message = "";
include "db_connection.php";
include "sessioncheck.php";
$error = "";
$message = "";
if (!empty($_GET["id"])) {
$query = "SELECT * from page_ads_userdetail WHERE id='" . $_GET['id'] . "'";
$result = mysqli_query($connection, $query);
$row = mysqli_fetch_assoc($result);
if (!empty($row["id"])) {
} else {
header("Location:page_ads_userdetail_list");
}
} else {
header("Location:page_ads_userdetail_list");
}
if (!empty($_POST["Process"]) && trim($_POST["Process"]) == "EditNow") {
$file_name = test_input($_POST['file_name']);
$link = test_input($_POST['link']);
$img_title = test_input($_POST['img_title']);
$img_alt = test_input($_POST['img_title']);
$old_image_name = test_input($_POST['old_image_name']);
$ad_placement = test_input($_POST['ad_placement']);
#image upload
if (!empty($_FILES['image_name']['name'])) {
$tmp_name = $_FILES['image_name']['tmp_name'];
$path = "../../bg_images/";
$name = $_FILES['image_name']['name'];
$size = $_FILES['image_name']['size'];
$type = $_FILES['image_name']['type'];
$ext = strtolower(substr($name, strrpos($name, '.') + 1));
$name = time() . "_" . rand(0, 999999) . "." . $ext;
$target_file = $path . $name;
if (($ext == 'jpg' || $ext == 'jpeg' || $ext == 'png' || $ext == 'gif') && ($type == 'image/jpeg' || $type == 'image/png' || $type == 'image/gif')) {
if (move_uploaded_file($_FILES["image_name"]["tmp_name"], $target_file)) {
unlink($path . $old_image_name);
#update table with new file name
$sql_chk = mysqli_query($connection, "SELECT * FROM page_ads_userdetail WHERE image_name='$old_image_name'");
while ($row_chk = mysqli_fetch_assoc($sql_chk)) {
$sql = mysqli_query($connection, "UPDATE page_ads_userdetail SET file_name='$file_name', link='$link', image_name='$name', img_alt='$img_alt', img_title='$img_title', ad_placement='$ad_placement' WHERE id=" . $row_chk["id"] . "");
} //while($row_chk=mysqli_fetch_assoc($sql_chk))
}
}
} else {
//$sql=mysqli_query($connection,"UPDATE page_ads_userdetail SET file_name='$file_name', link='$link', img_alt='$img_alt', img_title='$img_title', ad_placement='$ad_placement' WHERE id=$id");
#update table with new file name
$sql_chk = mysqli_query($connection, "SELECT * FROM page_ads_userdetail WHERE image_name='$old_image_name'");
while ($row_chk = mysqli_fetch_assoc($sql_chk)) {
$sql = mysqli_query($connection, "UPDATE page_ads_userdetail SET file_name='$file_name', link='$link', img_alt='$img_alt', img_title='$img_title', ad_placement='$ad_placement' WHERE id=" . $row_chk["id"] . "");
} //while($row_chk=mysqli_fetch_assoc($sql_chk))
}
$message = "User Detail updated successfully";
$query = "SELECT * from page_ads_userdetail WHERE id='" . $_GET['id'] . "'";
$result = mysqli_query($connection, $query);
$row = mysqli_fetch_assoc($result);
}
?>
<!-- Header Start-->
<?php include("header.php"); ?>
<nav class=" navbar navbar-expand navbar-white navbar-light">
<ul class="navbar-nav">
<li class="nav-item">
<a class="nav-link" data-widget="pushmenu" href="#">
<i class="fa fa-bars" style="color:white;"></i>
</a>
</li>
</ul>
<div>
<ol class="breadcrumb float-sm-right">
<li class="breadcrumb-item ">User Detail</li>
<li class="breadcrumb-item">Edit User Detail</li>
</ol>
</div>
</nav>
<!-- Header Ends-->
<!-- Content Start-->
<section class="content">
<div class="container-fluid">
<div class="row">
<div class="col-12">
<div class="card">
<!--<div class="card-header">
<h3 class="card-title"><button type="button" class="btn btn-info" onClick="window.location.href='<?php echo MAIN_URL ?>/admin/page_ads_userdetail_list'">List User Detail Banner</button> </h3>
</div>-->
<!-- /.card-header -->
<div class="card-body">
<?php include_once 'notification.php'; ?>
<form action="" method="post" id="edit-page-ads-user-detail-form" enctype="multipart/form-data">
<input type="hidden" name="old_image_name" id="old_image_name" value="<?= $row["image_name"] ?>" />
<input type="hidden" name="ad_placement" id="ad_placement" value="<?= $row["ad_placement"] ?>" />
<div class="form-group">
<label for="usrname">Select Ad</label>
<?php $adQuery = mysqli_query($connection, "SELECT * FROM advertise ORDER BY id DESC"); ?>
<select class="form-control input_border_radius input-sm" name="file_name" id="file_name" required>
<option value="">Select Ad</option>
<?php while ($adData = mysqli_fetch_assoc($adQuery)) { ?>
<option value="<?= $adData['id'] ?>" <?= ($row['file_name'] == $adData['id']) ? 'selected' : '' ?>><?= $adData['id'] ?> - <?= $adData['profile_tile'] ?></option>
<?php } ?>
</select>
</div>
<div class="form-group">
<label for="link">Link</label>
<input type="text" class="form-control" id="link" name="link" placeholder="Enter Link" value="<?php if (!empty($row["link"])) {
echo $row["link"];
} ?>" required>
</div>
<div class="form-group">
<label>Upload Image :- <a target="_blank" href="../bg_images/<?= $row["image_name"] ?>"><?= $row["image_name"] ?></a></label>
<input name="image_name" id="image_name" type="file" placeholder="Upload Image" value="Upload Image">
</div>
<div class="form-group">
<label for="link">Title</label>
<input type="text" class="form-control" id="img_title" name="img_title" placeholder="Enter Title" value="<?php if (!empty($row["img_title"])) {
echo $row["img_title"];
} ?>">
</div>
<button type="submit" class="btn btn-primary">Edit</button>
<input type="hidden" name="Process" id="Process" value="EditNow" />
</form>
</div>
<!-- /.card-body -->
</div>
<!-- /.card -->
</div>
</div>
<!-- /.row (main row) -->
</div><!-- /.container-fluid -->
</section>
<!-- Content Ends-->
<!-- Footer Start-->
<?php include("footer.php"); ?>
<!-- Footer Ends-->