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"){
$search_id = $_POST['search_u_id'];
$language = trim($_POST['language']);
$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']);
$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
$sql=mysqli_query($connection,"insert into search SET language='".addslashes($language)."', title='".addslashes($title)."', meta_title='".addslashes($meta_title)."', meta_description='".addslashes($meta_description)."', h1_title='".addslashes($h1_title)."', h1_description='".addslashes($h1_description)."', search_outgoing_link='".addslashes($search_outgoing_link)."', date_time='".date('Y-m-d H:i:s')."', count='".addslashes($count)."', link_count='".addslashes($link_count)."', is_result='".addslashes($is_result)."' , 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)."'");
$message = 'Search Added Successfully';
}else{
$sql=mysqli_query($connection,"UPDATE search SET language='".addslashes($language)."', title='".addslashes($title)."', meta_title='".addslashes($meta_title)."', meta_description='".addslashes($meta_description)."', h1_title='".addslashes($h1_title)."', h1_description='".addslashes($h1_description)."', search_outgoing_link='".addslashes($search_outgoing_link)."', count='".addslashes($count)."', link_count='".addslashes($link_count)."', is_result='".addslashes($is_result)."' , 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");
$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");?>
<!-- Header Ends-->
<!-- Content Start-->
<div class="content-header">
<div class="container-fluid">
<div class="row mb-2">
<div class="col-sm-6">
<h1 class="m-0 text-dark">Edit Search</h1>
</div>
<div class="col-sm-6">
<ol class="breadcrumb float-sm-right">
<li class="breadcrumb-item"><a href="<?php echo MAIN_URL?>/admin/index">Home</a></li>
<li class="breadcrumb-item active">Seo</li>
<li class="breadcrumb-item"><a href="<?php echo MAIN_URL?>/admin/seo_search">Search</a></li>
<li class="breadcrumb-item"><a href="<?php echo MAIN_URL?>/admin/seo_search_edit?id=<?php echo $row['search_id'];?>">Edit Search</a></li>
</ol>
</div>
</div>
</div>
</div>
<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" placeholder="Links" 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 & Title Information</h3></div>
<div class="card-body">
<div class="row">
<div class="col-sm-6">
<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 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 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>
<div class="col-sm-6">
<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 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 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>
</div>
</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 -->
</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['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_title").val(data1.meta_title);
$("#meta_description").val(data1.meta_description);
$("#h1_title").val(data1.h1_title);
$("#h1_description").val(data1.h1_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-->