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_nationalities WHERE id='" . $_GET['id'] . "'";
$result = mysqli_query($connection, $query);
$row = mysqli_fetch_assoc($result);
if (!empty($row["id"])) {
} else {
header("Location:seo_nationality");
}
} else {
header("Location:seo_nationality");
}
if (!empty($_POST["Process"]) && trim($_POST["Process"]) == "EditNow") {
$id = $_POST['nationality_u_id'];
$language = trim($_POST['language']);
$nationality = trim($_POST['nationality']);
$keyword = test_input($_POST['keyword']);
$world_region = test_input($_POST['world_region']);
$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']);
$nationality_anchor = test_input($_POST['nationality_anchor']);
$nationality_outgoing_link = test_input($_POST['nationality_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_nationalities SET language='" . addslashes($language) . "', keyword='" . addslashes($keyword) . "', nationality='" . addslashes($nationality) . "', world_region='" . addslashes($world_region) . "', 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) . "', nationality_anchor='" . addslashes($nationality_anchor) . "', nationality_outgoing_link='" . addslashes($nationality_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 = 'Nationality Added Successfully';
}
} else {
$sql = mysqli_query($connection, "UPDATE seo_nationalities SET language='" . addslashes($language) . "', keyword='" . addslashes($keyword) . "', nationality='" . addslashes($nationality) . "', world_region='" . addslashes($world_region) . "', 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) . "', nationality_anchor='" . addslashes($nationality_anchor) . "', nationality_outgoing_link ='" . addslashes($nationality_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 = 'Nationality Update Successfully';
}
}
$query = "SELECT * from seo_nationalities 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 ">Nationalities</li>
<li class="breadcrumb-item">Edit Nationality</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="nationality_u_id" id="nationality_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="nationality">Nationality</label>
<input type="text" name="nationality" id="nationality" class="form-control input-sm" title="Nationality" placeholder="Nationality" value="<?= $row["nationality"] ?>" />
</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"] ?>" />
</div>
<div class="form-group">
<label for="world_region">World Region</label>
<input type="text" name="world_region" id="world_region" class="form-control input-sm" title="World Region" placeholder="World Region" value="<?= $row["world_region"] ?>" />
</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="h1_title">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="usrname">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="nationality_anchor">Nationality Anchor</label>
<input type="text" name="nationality_anchor" id="nationality_anchor" class="form-control input-sm" title="Nationality Anchor" placeholder="Nationality Anchor" value="<?= $row["nationality_anchor"] ?>" />
</div>
<div class="form-group">
<label for="nationality_outgoing_link">Nationality Outgoing Link</label>
<input type="text" name="nationality_outgoing_link" id="nationality_outgoing_link" class="form-control input-sm" title="Nationality Outgoing Link" placeholder="Nationality Outgoing Link" value="<?= $row["nationality_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="usrname">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-->
<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_nationality_detail_lang',
success: function(data1) {
//document.getElementById("editSearch_form").reset();
if (data1.search_id) {
$("#nationality_u_id").val(data1.id);
$("#nationality").val(data1.nationality);
$("#keyword").val(data1.keyword);
$("#world_region").val(data1.world_region);
$("#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);
$("#nationality_anchor").val(data1.nationality_anchor);
$("#nationality_outgoing_link").val(data1.nationality_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);
$("#nationality_u_id").val("new");
$("#nationality").val(data1.nationality);
}
//window.location.reload();
}
});
});
</script>
<!-- Footer Start-->
<?php include("footer.php"); ?>
<!-- Footer Ends-->