.

%PDF- %GIF98; %PNG; . Cyber Programmer
Server : Apache
System : Linux sh00666.bluehost.com 5.14.0-687.26.1.el9_8.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Jul 14 16:32:02 EDT 2026 x86_64
User : ndkhermy ( 1200)
PHP Version : 8.5.12
Disable Function : NONE
Directory : /home1/ndkhermy/www/website_93b53270/admin/mange_footer/
Upload File :
Current File : /home1/ndkhermy/www/website_93b53270/admin/mange_footer/add_edit.php
<?php 
error_reporting(0);
include("../function.php");
if($_SESSION['admin_id']==""){
header('location:../login.php');

}
$login_tbl=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM admin WHERE admin_id='".$_SESSION['admin_id']."'"));

// Sidebar strat
include('../include/sidebar.php');
// Sidebar wrap
$id=$_GET['id'];


?>

<!-- [ Main Content ] start -->
<section class="pcoded-main-container">
    <div class="pcoded-content">
        <!-- [ breadcrumb ] start -->
        <div class="page-header">
            <div class="page-block">
                <div class="row align-items-center">
                    <div class="col-md-12">
                        <div class="page-header-title">

 <div class="card-header d-flex justify-content-between">
<button class="btn btn-dark text-light fw-bold btn-sm btn-round has-ripple"><i class="feather icon-edit"></i>&nbsp; Add | Edit | Footer Columns / Rows </button>
</div>
                        </div>
                     
                    </div>
                </div>
            </div>
        </div>
        <!-- [ breadcrumb ] end -->
        <!-- [ Main Content ] start -->
        
<div class="row">

<div class="col-md-12">
<div class="card">
<!-- <div class="card-header d-flex justify-content-between">
</div> -->
<div class="card-body">
<?php if(isset($_SESSION['img_error'])){
echo '<div class="alert alert-danger alert-dismissible fade show" role="alert">
<i class="feather icon-alert-triangle text-danger"></i>&nbsp; &nbsp;<strong class="text-dark">'.$_SESSION['img_error'].'</strong> 
<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close">
</button>
</div>';
}
unset($_SESSION['img_error']); 
?> 
<?php 
$fetQuery=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM footer_rows_tbl WHERE id='$id'"));                        
?>
                      
<form method="post" action="" enctype="multipart/form-data" autocomplete="off">                       
<div class="row">

<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="status">Columns</label>
<select class="form-select" name="column_id" required>
<option value="">Please select Columns</option>
<?php $query = mysqli_query($conn, "SELECT * FROM `footer_columns_tbl` WHERE status = 1"); 
      while($mysqli_fet = mysqli_fetch_array($query)){
?>
<option value="<?=$mysqli_fet['id']?>" <?=($fetQuery['column_id']==$mysqli_fet['id'])?'selected':'';?>><?=$mysqli_fet['title']?></option>
<?php } ?>
</select>
</div>
</div>

<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="title">Row Name</label>
<input type="text" name="title"  class="form-control" value="<?php if($id!=''){echo $fetQuery['title'];} ?>" placeholder="Enter Row Name">
</div>
</div>

<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Link">Link</label>
<input type="url" name="link"  class="form-control" value="<?php if($id!=''){echo $fetQuery['link'];} ?>" placeholder="Enter Link">
</div>
</div>


<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="status">Status</label>
<select class="form-select" name="status" required>
<option value="">Please select status</option>
<option value="1" <?=($fetQuery['status']=='1')?'selected':'';?>>Show</option>
<option value="0" <?=($fetQuery['status']=='0')?'selected':'';?>>Hide</option>
</select>
</div>
</div>

</div>

<div class="row">
<div class="col-md-6">
<?php 
if(($id!='')){
    echo'<input type="submit" name="update" class="btn btn-success" value="Update">';
}else{
  echo'<input type="submit" name="add" class="btn btn-success" value="Add">';   
}
?>

<button  class="btn btn-dark"><a class="text-white" href="show.php?page=footer">Back</a></button>

</div>
</div>

                     
 </form>                      
                       
                       
</div>
</div>
</div>
            
<!-- [ form-element ] end -->
</div>
<!-- [ Main Content ] end -->
</div>
</section>



<?php include('../include/footer.php'); ?>


<!-- Insert data start --->
<?php
if(isset($_POST['add'])){

$column_id=$_POST['column_id'];
$title=str_replace("'", "\'", $_POST['title']);
$link=$_POST['link'];

$slug=create_url($title);
$status=$_POST['status'];

$addQry=mysqli_query($conn,
"INSERT `footer_rows_tbl` SET 
`column_id`='$column_id',
`title`='$title',
`link`='$link',
`slug`='$slug',  
`status`='$status'")or die(mysqli_error($conn));

// update slug code Start //
$ido = mysqli_insert_id($conn);
$slug1 = create_url($file_name).$ido;
mysqli_query($conn,"UPDATE `footer_rows_tbl` SET `slug`='$slug1' WHERE id='$ido'");
// update slug code End //

if($addQry){
echo "<script>window.location='show.php?page=footer';</script>";
$_SESSION['message']="Record Insertted successfully";
}


   }

?>
<!-- Insert data warp --->

<!-- Update data start --->
<?php
if(isset($_POST['update'])){

$column_id=$_POST['column_id'];
$title=str_replace("'", "\'", $_POST['title']);
$link=$_POST['link'];

$slug=create_url($title);
$status=$_POST['status'];

$editQry=mysqli_query($conn,"UPDATE `footer_rows_tbl` SET 
`column_id`='$column_id',
`title`='$title',
`link`='$link',
`slug`='$slug',  
`status`='$status' WHERE id='$id'")or die(mysqli_error($conn)); 
if($editQry){
echo "<script>window.location='show.php?page=footer';</script>";
$_SESSION['message']="Record Updated successfully";
}
}

?>
<!-- Update data warp --->
VaKeR 2022