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/ |
<?php
$error = "";
$message = "";
include "db_connection.php";
include "sessioncheck.php";
$error = "";
$message = "";
if (!empty($_GET["id"])) {
$query = "SELECT * from seo_adservices WHERE id='" . $_GET['id'] . "'";
$result = mysqli_query($connection, $query);
$row = mysqli_fetch_assoc($result);
if (!empty($row["id"])) {
} else {
header("Location:users_list");
}
} else {
header("Location:users_list");
}
if (!empty($_POST["Process"]) && trim($_POST["Process"]) == "EditNow") {
$id = $_POST['adservice_u_id'];
$language = trim($_POST['language']);
$adservice = trim($_POST['adservice']);
$keyword = test_input($_POST['keyword']);
$meta_keyword = test_input($_POST['meta_keyword']);
$meta_title = test_input($_POST['meta_title']);
$meta_description = test_input($_POST['meta_description']);
$h1_title = test_input($_POST['h1_title']);
$h1_description = test_input($_POST['h1_description']);
$adservice_anchor = test_input($_POST['adservice_anchor']);
$adservice_outgoing_link = test_input($_POST['adservice_outgoing_link']);
$h2_title_1 = test_input($_POST['h2_title_1']);
$h2_description_1 = test_input($_POST['h2_description_1']);
$h2_title_2 = test_input($_POST['h2_title_2']);
$h2_description_2 = test_input($_POST['h2_description_2']);
$h2_title_3 = test_input($_POST['h2_title_3']);
$h2_description_3 = test_input($_POST['h2_description_3']);
$bottom_title = test_input($_POST['bottom_title']);
$bottom_description = test_input($_POST['bottom_description']);
$bottom_title_1 = test_input($_POST['bottom_title_1']);
$bottom_description_1 = test_input($_POST['bottom_description_1']);
$bottom_title_2 = test_input($_POST['bottom_title_2']);
$bottom_description_2 = test_input($_POST['bottom_description_2']);
$bottom_title_3 = test_input($_POST['bottom_title_3']);
$bottom_description_3 = test_input($_POST['bottom_description_3']);
if ($id == "new") {
#this is new lang and insert into db
$sql = mysqli_query($connection, "insert into seo_adservices SET language='" . addslashes($language) . "', keyword='" . addslashes($keyword) . "', adservice='" . addslashes($adservice) . "', meta_keyword='" . addslashes($meta_keyword) . "', meta_title='" . addslashes($meta_title) . "', meta_description='" . addslashes($meta_description) . "', h1_title='" . addslashes($h1_title) . "', h1_description='" . addslashes($h1_description) . "', adservice_anchor='" . addslashes($adservice_anchor) . "', adservice_outgoing_link='" . addslashes($adservice_outgoing_link) . "', h2_title_1='" . addslashes($h2_title_1) . "', h2_description_1='" . addslashes($h2_description_1) . "', h2_title_2='" . addslashes($h2_title_2) . "', h2_description_2='" . addslashes($h2_description_2) . "', h2_title_3='" . addslashes($h2_title_3) . "', h2_description_3='" . addslashes($h2_description_3) . "', bottom_title='" . addslashes($bottom_title) . "', bottom_description='" . addslashes($bottom_description) . "', bottom_title_1='" . addslashes($bottom_title_1) . "', bottom_description_1='" . addslashes($bottom_description_1) . "', bottom_title_2='" . addslashes($bottom_title_2) . "', bottom_description_2='" . addslashes($bottom_description_2) . "', bottom_title_3='" . addslashes($bottom_title_3) . "', bottom_description_3='" . addslashes($bottom_description_3) . "'");
if ($sql) {
$message = 'Ad Service Added Successfully';
}
} else {
$sql = mysqli_query($connection, "UPDATE seo_adservices SET language='" . addslashes($language) . "', keyword='" . addslashes($keyword) . "', adservice='" . addslashes($adservice) . "', meta_keyword='" . addslashes($meta_keyword) . "', meta_title='" . addslashes($meta_title) . "', meta_description='" . addslashes($meta_description) . "', h1_title='" . addslashes($h1_title) . "', h1_description='" . addslashes($h1_description) . "', adservice_anchor='" . addslashes($adservice_anchor) . "', adservice_outgoing_link ='" . addslashes($adservice_outgoing_link) . "', h2_title_1='" . addslashes($h2_title_1) . "', h2_description_1='" . addslashes($h2_description_1) . "', h2_title_2='" . addslashes($h2_title_2) . "', h2_description_2='" . addslashes($h2_description_2) . "', h2_title_3='" . addslashes($h2_title_3) . "', h2_description_3='" . addslashes($h2_description_3) . "', bottom_title='" . addslashes($bottom_title) . "', bottom_description='" . addslashes($bottom_description) . "', bottom_title_1='" . addslashes($bottom_title_1) . "', bottom_description_1='" . addslashes($bottom_description_1) . "', bottom_title_2='" . addslashes($bottom_title_2) . "', bottom_description_2='" . addslashes($bottom_description_2) . "', bottom_title_3='" . addslashes($bottom_title_3) . "', bottom_description_3='" . addslashes($bottom_description_3) . "' WHERE id=$id");
if ($sql) {
$message = 'Ad Service Update Successfully';
}
}
}
$query = "SELECT * from seo_adservices 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 ">Ad Services</li>
<li class="breadcrumb-item">Edit Ad Service</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-body">
<?php include_once 'notification.php'; ?>
<form action="" method="post" id="add-user-form" enctype="multipart/form-data">
<input type="hidden" name="adservice_u_id" id="adservice_u_id" value="<?= $row["id"] ?>" />
<div class="form-group">
<label for="language">Select Language</label>
<select id="language" name="language" class="form-control" title="Select Language" required>
<?php foreach ($lang_admin as $key => $value) { ?>
<option value="<?php echo $key; ?>" <?php if (trim($row["language"]) == "" && $lang_site_main_lang == $key) { ?> selected="selected" <?php } elseif (trim($row["language"]) != "" && $row["language"] == $key) { ?> selected="selected" <?php } ?>><?php echo $value; ?></option>
<?php } //foreach($lang_admin as $key=>$value)
?>
</select>
</div>
<div class="form-group">
<label for="adservice">AdService</label>
<input type="text" name="adservice" id="adservice" class="form-control input-sm" title="AdService" placeholder="AdService" value="<?= $row["adservice"] ?>" required />
</div>
<div class="form-group">
<label for="keyword">Keyword</label>
<input type="text" name="keyword" id="keyword" class="form-control input-sm" title="Keyword" placeholder="Keyword" value="<?= $row["keyword"] ?>" required />
</div>
<div class="form-group">
<label for="meta_keyword">Meta Keyword</label>
<input type="text" name="meta_keyword" id="meta_keyword" class="form-control input-sm" title="Meta Keyword" placeholder="Meta Keyword" value="<?= $row["meta_keyword"] ?>" />
</div>
<div class="form-group">
<label for="meta_title">Meta Title</label>
<input type="text" name="meta_title" id="meta_title" class="form-control input-sm" title="Meta Title" placeholder="Meta Title" value="<?= $row["meta_title"] ?>" />
</div>
<div class="form-group">
<label for="meta_description">Meta Description</label>
<input type="text" name="meta_description" id="meta_description" class="form-control input-sm" title="Meta Description" placeholder="Meta Description" value="<?= $row["meta_description"] ?>" />
</div>
<div class="form-group">
<label for="h1_title">H1 Title</label>
<input type="text" name="h1_title" id="h1_title" class="form-control input-sm" title="H1 Title" placeholder="H1 Title" value="<?= $row["h1_title"] ?>" />
</div>
<div class="form-group">
<label for="h1_description">H1 Description</label>
<textarea class="form-control input_border_radius input-sm" id="h1_description" rows="7" name="h1_description" title="H1 Description" placeholder="H1 Description"><?php echo $row['h1_description']; ?></textarea>
</div>
<div class="form-group">
<label for="adservice_anchor">Adservice Anchor</label>
<input type="text" name="adservice_anchor" id="adservice_anchor" class="form-control input-sm" title="Adservice Anchor" placeholder="Adservice Anchor" value="<?= $row["adservice_anchor"] ?>" />
</div>
<div class="form-group">
<label for="adservice_outgoing_link">Adservice Outgoing Link</label>
<input type="text" name="adservice_outgoing_link" id="adservice_outgoing_link" class="form-control input-sm" title="Adservice Outgoing Link" placeholder="Adservice Outgoing Link" value="<?= $row["adservice_outgoing_link"] ?>" />
</div>
<div class="form-group">
<label for="h2_title_1">H2 Title1</label>
<input type="text" name="h2_title_1" id="h2_title_1" class="form-control input-sm" title="H2 Title1" placeholder="H2 Title1" value="<?= $row["h2_title_1"] ?>" />
</div>
<div class="form-group">
<label for="h2_description_1">H2 Description1</label>
<textarea class="form-control input_border_radius input-sm" id="h2_description_1" rows="7" name="h2_description_1" title="H2 Description1" placeholder="H2 Description1"><?php echo $row['h2_description_1']; ?></textarea>
</div>
<div class="form-group">
<label for="h2_title_2">H2 Title2</label>
<input type="text" name="h2_title_2" id="h2_title_2" class="form-control input-sm" title="H2 Title2" placeholder="H2 Title2" value="<?= $row["h2_title_2"] ?>" />
</div>
<div class="form-group">
<label for="h2_description_2">H2 Description2</label>
<textarea class="form-control input_border_radius input-sm" id="h2_description_2" rows="7" name="h2_description_2" title="H2 Description2" placeholder="H2 Description2"><?php echo $row['h2_description_2']; ?></textarea>
</div>
<div class="form-group">
<label for="h2_title_3">H2 Title3</label>
<input type="text" name="h2_title_3" id="h2_title_3" class="form-control input-sm" title="H2 Title3" placeholder="H2 Title3" value="<?= $row["h2_title_3"] ?>" />
</div>
<div class="form-group">
<label for="h2_description_3">H2 Description3</label>
<textarea class="form-control input_border_radius input-sm" id="h2_description_3" rows="7" name="h2_description_3" title="H2 Description3" placeholder="H2 Description3"><?php echo $row['h2_description_3']; ?></textarea>
</div>
<div class="form-group">
<label for="bottom_title">Bottom Title</label>
<input type="text" name="bottom_title" id="bottom_title" class="form-control input-sm" title="Bottom Title" placeholder="Bottom Title" value="<?= $row["bottom_title"] ?>" />
</div>
<div class="form-group">
<label for="bottom_description">Bottom Description</label>
<textarea class="form-control input_border_radius input-sm" id="bottom_description" rows="7" name="bottom_description" title="Bottom Description" placeholder="Bottom Description"><?php echo $row['bottom_description']; ?></textarea>
</div>
<div class="form-group">
<label for="bottom_title_1">Bottom Title1</label>
<input type="text" name="bottom_title_1" id="bottom_title_1" class="form-control input-sm" title="Bottom Title1" placeholder="Bottom Title1" value="<?= $row["bottom_title_1"] ?>" />
</div>
<div class="form-group">
<label for="bottom_description_1">Bottom Description1</label>
<textarea class="form-control input_border_radius input-sm" id="bottom_description_1" rows="7" name="bottom_description_1" title="Bottom Description1" placeholder="Bottom Description1"><?php echo $row['bottom_description_1']; ?></textarea>
</div>
<div class="form-group">
<label for="bottom_title_2">Bottom Title2</label>
<input type="text" name="bottom_title_2" id="bottom_title_2" class="form-control input-sm" title="Bottom Title2" placeholder="Bottom Title2" value="<?= $row["bottom_title_2"] ?>" />
</div>
<div class="form-group">
<label for="bottom_description_2">Bottom Description2</label>
<textarea class="form-control input_border_radius input-sm" id="bottom_description_2" rows="7" name="bottom_description_2" title="Bottom Description2" placeholder="Bottom Description2"><?php echo $row['bottom_description_2']; ?></textarea>
</div>
<div class="form-group">
<label for="bottom_title_3">Bottom Title3</label>
<input type="text" name="bottom_title_3" id="bottom_title_3" class="form-control input-sm" title="Bottom Title3" placeholder="Bottom Title3" value="<?= $row["bottom_title_3"] ?>" />
</div>
<div class="form-group">
<label for="bottom_description_3">Bottom Description3</label>
<textarea class="form-control input_border_radius input-sm" id="bottom_description_3" rows="7" name="bottom_description_3" title="Bottom Description3" placeholder="Bottom Description3"><?php echo $row['bottom_description_3']; ?></textarea>
</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-->
<script type="text/javascript">
$('#language').change(function() {
// $(this).val() will work here
//alert($(this).val());
//ajax start
$.ajax({
type: 'post',
data: {
slang: $(this).val(),
value: <?php echo $row['id']; ?>
},
dataType: "json",
url: 'service/get_seo_adservice_detail_lang',
success: function(data1) {
//document.getElementById("editSearch_form").reset();
if (data1.search_id) {
$("#adservice_u_id").val(data1.id);
$("#adservice").val(data1.adservice);
$("#keyword").val(data1.keyword);
$("#meta_keyword").val(data1.meta_keyword);
$("#meta_title").val(data1.meta_title);
$("#meta_description").val(data1.meta_description);
$("#h1_title").val(data1.h1_title);
$("#h1_description").val(data1.h1_description);
$("#adservice_anchor").val(data1.adservice_anchor);
$("#adservice_outgoing_link").val(data1.adservice_outgoing_link);
$("#h2_title_1").val(data1.h2_title_1);
$("#h2_description_1").val(data1.h2_description_1);
$("#h2_title_2").val(data1.h2_title_2);
$("#h2_description_2").val(data1.h2_description_2);
$("#h2_title_3").val(data1.h2_title_3);
$("#h2_description_3").val(data1.h2_description_3);
$("#bottom_title").val(data1.bottom_title);
$("#bottom_description").val(data1.bottom_description);
$("#bottom_title_1").val(data1.bottom_title_1);
$("#bottom_description_1").val(data1.bottom_description_1);
$("#bottom_title_2").val(data1.bottom_title_2);
$("#bottom_description_2").val(data1.bottom_description_2);
$("#bottom_title_3").val(data1.bottom_title_3);
$("#bottom_description_3").val(data1.bottom_description_3);
} else {
//$("#count").val(0);
//$("#link_count1").val(0);
$("#adservice_u_id").val("new");
$("#adservice").val(data1.adservice);
}
//window.location.reload();
}
});
//ajax ends
});
</script>
<?php include("footer.php"); ?>
<!-- Footer Ends-->