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 search WHERE search_id='" . $_GET['id'] . "'";
$result = mysqli_query($connection, $query);
$row = mysqli_fetch_assoc($result);
if (!empty($row["search_id"])) {
} else {
header("Location:seo_search");
}
} else {
header("Location:seo_search");
}
if (!empty($_POST["Process"]) && trim($_POST["Process"]) == "EditNow") {
$seo_content = test_input(@$_POST['seo_content']);
$search_id = @$_POST['search_u_id'];
$language = trim(@$_POST['language']);
$meta_keyword = test_input(@$_POST['meta_keyword']);
$title = test_input(@$_POST['title']);
$meta_title = test_input(@$_POST['meta_title']);
$meta_description = test_input(@$_POST['meta_description']);
$h1_title = test_input(@$_POST['h1_title']);
$description = test_input(@$_POST['description']);
$h1_description = test_input(@$_POST['h1_description']);
$search_outgoing_link = test_input(@$_POST['search_outgoing_link']);
$count = test_input(@$_POST['count']);
$link_count = test_input(@$_POST['link_count']);
/*$is_result = test_input(@$_POST['is_result']);*/
$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']);
$h2_title_4 = test_input(@$_POST['h2_title_4']);
$h2_description_4 = test_input(@$_POST['h2_description_4']);
if ($search_id == "new") {
#this is new lang and insert into db
$query = "insert into search SET meta_keyword='" . addslashes($meta_keyword) . "', description='" . addslashes($description) . "', meta_description='" . addslashes($meta_description) . "', seo_content='" . addslashes($seo_content) . "', language='" . addslashes($language) . "', title='" . addslashes($title) . "', meta_title='" . addslashes($meta_title) . "', h1_title='" . addslashes($h1_title) . "', search_outgoing_link='" . addslashes($search_outgoing_link) . "', date_time='" . date('Y-m-d H:i:s') . "', count='" . addslashes($count) . "', link_count='" . addslashes($link_count) . "', 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) . "', h2_title_4='" . addslashes($h2_title_4) . "', h2_description_4='" . addslashes($h2_description_4) . "'";
$sql = mysqli_query($connection, $query);
$message = 'Search Added Successfully';
} else {
$query = "UPDATE search SET meta_keyword='" . addslashes($meta_keyword) . "', description='" . addslashes($description) . "', meta_description='" . addslashes($meta_description) . "', seo_content='" . addslashes($seo_content) . "', language='" . addslashes($language) . "', title='" . addslashes($title) . "', meta_title='" . addslashes($meta_title) . "', h1_title='" . addslashes($h1_title) . "', search_outgoing_link='" . addslashes($search_outgoing_link) . "', count='" . addslashes($count) . "', link_count='" . addslashes($link_count) . "', 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) . "', h2_title_4='" . addslashes($h2_title_4) . "', h2_description_4='" . addslashes($h2_description_4) . "' WHERE search_id=$search_id";
$sql = mysqli_query($connection, $query);
$message = 'Search Updated Successfully';
}
#Reload updated content
$query = "SELECT * from search WHERE search_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 ">Search</li>
<li class="breadcrumb-item">Edit Search</li>
</ol>
</div>
</nav>
<!-- Header Ends-->
<!-- Content Start-->
<section class="content">
<div class="container-fluid">
<div class="row">
<div class="col-12">
<form action="" method="post" id="add-user-form" enctype="multipart/form-data" role="form">
<div class="card">
<div class="card-header">
<h3 class="card-title">General Information</h3>
</div>
<!-- /.card-header -->
<div class="card-body">
<!-- Flash Message -->
<?php if ($message) : ?><div class="alert alert-info" role="alert"><?php echo $message; ?></div><?php endif; ?>
<!-- Flash Message -->
<!-- Error Message -->
<?php if (!empty($error)) : ?><div class="alert alert-info" role="alert" style="color:#FF0000;"><?php echo $error; ?></div><?php endif; ?>
<!-- Error Message -->
<div class="row">
<div class="col-sm-6">
<div class="form-group">
<label for="usrname">Select Language</label>
<select id="language" name="language" class="form-control input_border_radius input-sm" 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="country">SEO Link</label>
<input type="text" class="form-control" id="search_outgoing_link" name="search_outgoing_link" placeholder="SEO Link" value="<?php if (!empty($row["search_outgoing_link"])) {
echo $row["search_outgoing_link"];
} ?>">
</div>
</div>
<div class="col-sm-6">
<div class="form-group">
<label for="title">Keyword </label>
<input type="text" class="form-control" id="title" name="title" placeholder="Enter Keyword" value="<?php if (!empty($row["title"])) {
echo $row["title"];
} ?>">
</div>
<div class="row">
<div class="col-6">
<div class="form-group">
<label for="country">Count</label>
<input type="text" class="form-control" id="count" name="count" placeholder="Count" value="<?php echo $row["count"]; ?>">
</div>
</div>
<div class="col-6">
<div class="form-group">
<label for="country">Links </label>
<input type="text" name="link_count" id="link_count1" class="form-control input-sm" title="Links " placeholder="Link Count" value="<?= $row["link_count"] ?>" />
</div>
</div>
<!--<div class="col-4">
<div class="form-group">
<label for="country">Is Result</label>
<input type="text" class="form-control" id="is_result" name="is_result" placeholder="Is Result" value="<?php echo $row["is_result"]; ?>">
</div>
</div>-->
</div>
</div>
</div>
</div>
<!-- /.card-body -->
</div>
<!-- /.card -->
<div class="card">
<div class="card-header">
<h3 class="card-title">Meta Information</h3>
</div>
<div class="card-body">
<div class="form-group">
<label for="meta_keyword">Meta Keyword</label>
<input type="text" class="form-control" id="meta_keyword" name="meta_keyword" placeholder="Meta Keyword" value="<?php if (!empty($row["meta_keyword"])) {
echo $row["meta_keyword"];
} ?>">
</div>
<div class="form-group">
<label for="meta_title">Meta Title</label>
<input type="text" class="form-control" id="meta_title" name="meta_title" placeholder="Meta Title" value="<?php if (!empty($row["meta_title"])) {
echo $row["meta_title"];
} ?>">
</div>
<div class="form-group">
<label for="country">Meta Description</label>
<textarea class="form-control input_border_radius input-sm" id="meta_description" rows="4" name="meta_description" title="Meta Description" placeholder="Meta Description"><?php echo $row['meta_description']; ?></textarea>
</div>
</div>
</div>
<div class="card">
<div class="card-header">
<h3 class="card-title">H1 Title & Description</h3>
</div>
<div class="card-body">
<div class="form-group">
<label for="h1_title">H1 Title</label>
<input type="text" class="form-control" id="h1_title" name="h1_title" placeholder="H1 Title" value="<?php if (!empty($row["h1_title"])) {
echo $row["h1_title"];
} ?>">
</div>
<div class="form-group">
<label for="description">Description</label>
<textarea class="form-control input_border_radius input-sm" id="description" rows="4" name="description" title="Description" placeholder="Meta Description"><?php echo $row['description']; ?></textarea>
</div>
</div>
</div>
<!-- /.card -->
<div class="card">
<div class="card-header">
<h3 class="card-title">SEO Content</h3>
</div>
<div class="card-body">
<textarea name="seo_content"><?php echo $row['seo_content']; ?></textarea>
</div>
<div class="form-group" style="margin-left:25px">
<button type="submit" class="btn btn-primary">Edit</button>
<input type="hidden" name="search_u_id" id="search_u_id" value="<?php echo $row['search_id']; ?>" />
<input type="hidden" name="Process" id="Process" value="EditNow" />
</div>
</div>
<?php /* ?>
<div class="card">
<div class="card-header"><h3 class="card-title">H1 Information</h3></div>
<div class="card-body">
<div class="form-group">
<label for="h1_title">H1 Title</label>
<input type="text" class="form-control" id="h1_title" name="h1_title" placeholder="H1 Title" value="<?php if(!empty($row["h1_title"])){ echo $row["h1_title"];}?>">
</div>
<div class="form-group">
<label for="country">H1 Description</label>
<textarea class="form-control input_border_radius input-sm" id="h1_description" rows="4" name="h1_description" title="H1 Description" placeholder="H1 Description"><?php echo $row['h1_description']; ?></textarea>
</div>
<div class="form-group">
<label for="country">H2 Title1</label>
<input type="text" class="form-control" id="h2_title_1" name="h2_title_1" placeholder="H2 Title1" value="<?php if(!empty($row["h2_title_1"])){ echo $row["h2_title_1"];}?>">
</div>
<div class="form-group">
<label for="country">H2 Description1</label>
<textarea class="form-control input_border_radius input-sm" id="h2_description_1" rows="4" name="h2_description_1" title="H2 Description1" placeholder="H2 Description1"><?php echo $row['h2_description_1']; ?></textarea>
</div>
<div class="form-group">
<label for="country">H2 Title2</label>
<input type="text" class="form-control" id="h2_title_2" name="h2_title_2" placeholder="H2 Title2" value="<?php if(!empty($row["h2_title_2"])){ echo $row["h2_title_2"];}?>">
</div>
<div class="form-group">
<label for="country">H2 Description2</label>
<textarea class="form-control input_border_radius input-sm" id="h2_description_2" rows="4" name="h2_description_2" title="H2 Description2" placeholder="H2 Description2"><?php echo $row['h2_description_2']; ?></textarea>
</div>
<div class="form-group">
<label for="country">H2 Title3</label>
<input type="text" class="form-control" id="h2_title_3" name="h2_title_3" placeholder="H2 Title3" value="<?php if(!empty($row["h2_title_3"])){ echo $row["h2_title_3"];}?>">
</div>
<div class="form-group">
<label for="country">H2 Description3</label>
<textarea class="form-control input_border_radius input-sm" id="h2_description_3" rows="4" name="h2_description_3" title="H2 Description3" placeholder="H2 Description3"><?php echo $row['h2_description_3']; ?></textarea>
</div>
<div class="form-group">
<label for="country">H2 Title4</label>
<input type="text" class="form-control" id="h2_title_4" name="h2_title_4" placeholder="H2 Title4" value="<?php if(!empty($row["h2_title_4"])){ echo $row["h2_title_4"];}?>">
</div>
<div class="form-group">
<label for="country">H2 Description4</label>
<textarea class="form-control input_border_radius input-sm" id="h2_description_4" rows="4" name="h2_description_4" title="H2 Description4" placeholder="H2 Description4"><?php echo $row['h2_description_4']; ?></textarea>
</div>
<button type="submit" class="btn btn-primary">Edit</button>
<input type="hidden" name="search_u_id" id="search_u_id" value="<?php echo $row['search_id']; ?>" />
<input type="hidden" name="Process" id="Process" value="EditNow" />
</div>
</div>
<!-- /.card -->
<?php */ ?>
</div>
</div>
<!-- /.row (main row) -->
</div><!-- /.container-fluid -->
</section>
<!-- Content Ends-->
<!-- Footer Start-->
<script>
CKEDITOR.replace('seo_content',{
versionCheck: false
});
</script>
<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['search_id']; ?>
},
dataType: "json",
url: 'service/get_seo_search_detail_lang',
success: function(data1) {
//document.getElementById("editSearch_form").reset();
if (data1.search_id) {
$("#search_u_id").val(data1.search_id);
$("#title").val(data1.title);
$("#meta_keyword").val(data1.meta_keyword);
$("#meta_title").val(data1.meta_title);
$("#meta_description").val(data1.meta_description);
CKEDITOR.instances.seo_content.setData(data1.seo_content);
$("#h1_title").val(data1.h1_title);
$("#description").val(data1.description);
$("#search_outgoing_link").val(data1.search_outgoing_link);
$("#count").val(data1.count);
$("#link_count1").val(data1.link_count);
$("#is_result").val(data1.is_result);
$("#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);
$("#h2_title_4").val(data1.h2_title_4);
$("#h2_description_4").val(data1.h2_description_4);
} else {
//$("#count").val(0);
//$("#link_count1").val(0);
$("#search_u_id").val("new");
}
//window.location.reload();
}
});
//ajax ends
});
</script>
<?php include("footer.php"); ?>
<!-- Footer Ends-->