%PDF- %GIF98; %PNG;
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/www/website_6031bb72/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');
// Sidebar wrap
// ini_set('display_errors',1);
// ini_set('display_startup_errors',1);
// error_reporting(E_ALL);
$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> Add 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 $Query_fetch=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM faq_atb_tbl WHERE id='$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="serv_id">Services</label>
<select class="form-select" name="serv_id" required id="serv_id">
<option value="">Please select Service</option>
<?php
$catQry = mysqli_query($conn, "SELECT * FROM services_tbl WHERE status=1 ORDER BY id ASC");
while ($row = mysqli_fetch_array($catQry)) {
?>
<option value="<?= $row['id'] ?>" <?= ($row['id'] == $Query_fetch['serv_id']) ? 'selected' : ''; ?>><?= $row['title'] ?></option>
<?php }; ?>
</select>
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label class="form-label" for="title">Faq Title</label>
<input type="text" name="title" class="form-control" value="<?= (!empty($id))?$Query_fetch['title']:'' ?>">
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label class="form-label" for="title_ar">Faq Title Arabic</label>
<input type="text" name="title_ar" class="form-control" value="<?= (!empty($id))?$Query_fetch['title_ar']:'' ?>">
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="content">Faq Content</label>
<textarea rows="5" name="content" class="form-control"><?= (!empty($id))?$Query_fetch['content']:'' ?></textarea>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="content_ar">Faq Content Arabic</label>
<textarea rows="5" name="content_ar" class="form-control"><?= (!empty($id))?$Query_fetch['content_ar']:'' ?></textarea>
</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" id="status_id">
<option value="1" <?= (!empty($id) && $Query_fetch['status'] == 1) ? 'selected' : '' ?>>Show</option>
<option value="0" <?= (!empty($id) && $Query_fetch['status'] == 0) ? 'selected' : '' ?>>Hide</option>
</select>
</div>
</div>
<!-- <div class="col-md-2">
<div class="form-group">
<input type="button" value="Add More" id="myButton" class="btn btn-sm btn-info" style="margin-top: 30px; padding: 8px;">
</div>
</div> -->
</div>
</div>
<!-- <div class="container">
<div class="row" id="input-container">
</div>
</div> -->
<div class="container">
<div class="row">
<div class="col-md-6">
<?php if(!empty($id)){ ?>
<button name="update" type="submit" class="btn btn-info">Update</button>
<?php }else{ ?>
<button name="add" type="submit" class="btn btn-info">Submit</button>
<?php } ?>
<a class="btn btn-secondary text-white" href="show.php?page=faq">Back</a>
</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>
<?php
if(isset($_POST['add'])){
$serv_id = $_POST['serv_id'];
$title = str_replace("'", "\'", $_POST['title']);
$title_ar = str_replace("'", "\'", $_POST['title_ar']);
$content = str_replace("'", "\'", $_POST['content']);
$content_ar = str_replace("'", "\'", $_POST['content_ar']);
$status = $_POST['status'];
$addQry=mysqli_query($conn,"INSERT `faq_atb_tbl` SET
`serv_id`='$serv_id',
`title`='$title',
`title_ar`='$title_ar',
`content`='$content',
`content_ar`='$content_ar',
`status`='$status'")or die(mysqli_error($conn));
// $faq_id=mysqli_insert_id($conn);
// 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 ('$faq_id', '$name', '$content')");
// }
// }
echo "<script>window.location='show.php?page=faq';</script>";
$_SESSION['message']="FAQ Insertted successfully";
}
if(isset($_POST['update'])){
$serv_id = $_POST['serv_id'];
$title = str_replace("'", "\'", $_POST['title']);
$title_ar = str_replace("'", "\'", $_POST['title_ar']);
$content = str_replace("'", "\'", $_POST['content']);
$content_ar = str_replace("'", "\'", $_POST['content_ar']);
$status = $_POST['status'];
$addQry=mysqli_query($conn,"UPDATE `faq_atb_tbl` SET
`serv_id`='$serv_id',
`title`='$title',
`title_ar`='$title_ar',
`content`='$content',
`content_ar`='$content_ar',
`status`='$status'")or die(mysqli_error($conn));
// $faq_id=mysqli_insert_id($conn);
// 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 ('$faq_id', '$name', '$content')");
// }
// }
echo "<script>window.location='show.php?page=faq';</script>";
$_SESSION['message']="FAQ Update successfully";
}
?>