Server : ApacheSystem : 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/public_html/website_93b53270/admin/manage_faq/ |
Upload File : |
<?php
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');
// ini_set('display_errors',1);
// ini_set('display_startup_errors',1);
// error_reporting(E_ALL);
?>
<!-- [ 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> Edit FAQ </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['message'])){
echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
<i class="feather icon-thumbs-up text-success"></i> <strong class="text-dark">'.$_SESSION['message'].'</strong>
<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close">
</button>
</div>';
}
unset($_SESSION['message']);
?>
<?php if(isset($_SESSION['error'])){
echo '<div class="alert alert-danger alert-dismissible fade show" role="alert">
<i class="feather icon-alert-triangle text-danger"></i> <strong class="text-dark">'.$_SESSION['error'].'</strong>
<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close">
</button>
</div>';
}
unset($_SESSION['error']);
?>
<?php $fetch_row=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM `faq_tbl` WHERE status=1 AND id='".$_REQUEST['id']."'")); ?>
<form method="POST" enctype="multipart/form-data" autocomplete="off">
<div class="container">
<div class="row">
<div class="col-md-4">
<div class="form-group">
<label class="form-label" for="productname">Faq Title</label>
<input type="text" name="title" class="form-control" value="<?php if (!$id=''){ echo $fetch_row['title']; } ?>">
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label class="form-label" for="productname">Faq Title1</label>
<input type="text" name="title1" class="form-control" value="<?php if (!$id=''){ echo $fetch_row['title1']; } ?>">
</div>
</div>
<div class="col-md-2">
<div class="form-group">
<label class="form-label" for="status">Status</label>
<select class="form-select" name="status" id="status_id">
<option value="">Select status</option>
<option value="1" <?php if ($fetch_row['status']==1){ echo "selected";} ?>>Show</option>
<option value="0" <?php if ($fetch_row['status']==0){ echo "selected";} ?>>Hide</option>
</select>
</div>
</div>
<!-- Muliple FAQ wrap edit --->
<div class="col-md-2 mt-4">
<div class="form-group">
<a class="form-control bg-success fw-bold text-white text-center" id="myButton">Add FAQ</a>
</div>
</div>
<!-- Muliple FAQ start edit --->
<?php
$Atb001=mysqli_query($conn,"SELECT * FROM `faq_atb_tbl` WHERE faq_id='".$fetch_row['id']."'");
while($row002=mysqli_fetch_array($Atb001)){
?>
<div class="col-lg-12 input-element data-item">
<input type="hidden" name="id_editatb[]" class="form-control" required value="<?=$row002['id']?>" >
<div class="container">
<div class="row">
<div class="col-lg-12">
<label for="categories" class=" form-control-label">Heading</label>
<input type="text" name="name1[]" class="form-control" value="<?=$row002['name']?>" required>
</div>
<div class="col-lg-12 mt-3">
<label for="categories" class="form-control-label">Description</label>
<textarea name="content1[]" rows="5" class="form-control" placeholder="Type Here" required><?=$row002['content']?></textarea>
</div>
<div class="col-lg-2 my-3">
<label for="categories" class=" form-control-label"></label>
<button id="myButton" type="button" class="btn btn-sm btn-danger p-2 remove-input delete-btn" data-id="<?=$row002['id']?>">
Remove
</button>
</div>
</div>
</div>
</div>
<?php } ;?>
<!-- Muliple FAQ wrap edit --->
</div>
</div>
<div class="container">
<div class="row" id="input-container">
</div>
</div>
<div class="container">
<div class="row">
<div class="col-md-6">
<button name="edit" type="submit" class="btn btn-info">Update</button>
<button class="btn btn-secondary"><a class="text-white" href="show.php?page=faq">Back</a></button>
</div>
</div>
</div>
</form>
</div>
</div>
</div>
<!-- [ form-element ] end -->
</div>
<!-- [ Main Content ] end -->
</div>
</section>
<!-- Required Js -->
<?php include('../include/footer.php'); ?>
<script>
$(document).ready(function() {
$("#myButton").click(function() {
$.ajax({
url: "generate_input.php",
success: function(html) {
$("#input-container").append(html);
}
});
});
});
$(document).on("click", ".remove-input", function() {
$(this).closest(".input-element").remove();
});
</script>
<script>
$(document).ready(function() {
$(".delete-btn").click(function(e) {
e.preventDefault();
let itemid = $(this).data('id');
$.ajax({
method: 'POST',
url: "delete_faq.php",
data: {
id: itemid
},
success: function(response) {
console.log(response);
// Optional: remove row from table
$("#row_" + itemid).remove();
},
error: function() {
alert("Something went wrong!");
}
});
});
});
</script>
<?php
if(isset($_POST['edit'])){
$title=$_POST['title'];
$title=str_replace("'", "\'", $title);
$title1=$_POST['title1'];
$title1=str_replace("'", "\'", $title1);
$status=$_POST['status'];
$addQry=mysqli_query($conn,"UPDATE `faq_tbl` SET
`title`='$title',
`title1`='$title1',
`status`='$status' WHERE id='".$_REQUEST['id']."'");
// Handle updates to Heading & Content_attributes_tbl
if (isset($_POST['id_editatb']) && is_array($_POST['id_editatb'])) {
foreach ($_POST['id_editatb'] as $key => $id_editatb) {
if (!empty($_POST['name1'])) {
$headingedit = $_POST['name1'][$key];
$headingedit=str_replace("'", "\'", $headingedit);
mysqli_query($conn, "UPDATE `faq_atb_tbl` SET `name` = '$headingedit' WHERE id = '$id_editatb'");
}
if (!empty($_POST['content1'])) {
$contentedit = $_POST['content1'][$key];
$contentedit=str_replace("'", "\'", $contentedit);
mysqli_query($conn, "UPDATE `faq_atb_tbl` SET `content` = '$contentedit' WHERE id = '$id_editatb'");
}
}
}
$id=$_GET['id'];
// Handle adding new Heading & Content_attributes_tbl
if (isset($_POST['name']) && is_array($_POST['name'])) {
foreach ($_POST['name'] as $key => $name) {
// Assuming Heading & Content are aligned in the same order
$name = $_POST['name'][$key];
$name=str_replace("'", "\'", $name);
$content = $_POST['content'][$key];
$content=str_replace("'", "\'", $content);
// Accessing the specific name & Content for this iteration
mysqli_query($conn, "INSERT INTO `faq_atb_tbl` (`faq_id`, `name`, `content`) VALUES ('$id', '$name', '$content')");
}
}
echo "<script>window.location='show.php?page=faq';</script>";
$_SESSION['message']="FAQ Update successfully";
}
?>