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_country/ |
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']."'"));
include('../include/sidebar.php');
?>
<!-- [ Main Content ] start -->
<div 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-check-square"></i> Manage Countries </button>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- [ breadcrumb ] end -->
<!-- [ Main Content ] start -->
<div class="row">
<!-- [ col-md-12 ] start -->
<form method="post" action="">
<div class="col-md-12">
<div class="card">
<div class="card-header d-flex justify-content-between">
<h5>Manage Countries</h5>
<div>
<a href="add_edit.php?page=country" class="btn btn-info btn-sm btn-round has-ripple text-white"><i class="feather icon-plus"></i>Add</a>
<input class="btn btn-danger btn-sm btn-round has-ripple" type="submit" value="Delete" name='but_delete' onclick="return confirm('Are you sure to delete the record?');">
<input class="btn btn-success btn-sm btn-round has-ripple" type="submit" value="Active" name='but_active'>
<input class="btn btn-secondary btn-sm btn-round has-ripple" type="submit" value="Deactive" name='but_deactive'>
</div>
</div>
<div class="card-body">
<?php if(isset($_SESSION['message'])){
echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
<strong class="text-dark">'.$_SESSION['message'].' <i class="feather icon-thumbs-up text-success"></i></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-success alert-dismissible fade show" role="alert">
<strong class="text-dark">'.$_SESSION['error'].' <i class="feather icon-thumbs-up text-danger"></i></strong>
<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close">
</button>
</div>';
}
unset($_SESSION['error']);
?>
<?php if(isset($_SESSION['delete'])){
echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
<strong class="text-dark">'.$_SESSION['delete'].' <i class="feather icon-trash-2 text-danger"></i></strong>
<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close">
</button>
</div>';
}
unset($_SESSION['delete']);
?>
<div class="table-responsive">
<table id="report-table" class="table table-bordered table-striped mb-0">
<thead>
<tr>
<th><input type="checkbox" id="some1" data-check-pattern="[name='delete[]']" /></th>
<th>S.No</th>
<th>Country (Eng/Ar)</th>
<th><input type="checkbox" id="phonecode1" data-phonecode-pattern="[name='phonecode[]']" /> Phonecode</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$query = mysqli_query($conn, "SELECT * FROM countries ORDER BY id DESC");
$n = 1;
while ($fetch_row = mysqli_fetch_array($query)) { ?>
<tr>
<td><input type="checkbox" name="delete[]" value="<?= $fetch_row['id']; ?>"></td>
<td><?= $n++; ?></td>
<td><?= htmlspecialchars($fetch_row['name']); ?><br><?= htmlspecialchars($fetch_row['name_ar']); ?></td>
<td><input type="checkbox" class="phonecode-item" data-country="<?= $fetch_row['id']; ?>" <?= ($fetch_row['phonecode_show'] == 1) ? 'checked' : ''; ?>></td>
<td>
<?php if ($fetch_row['status'] == '1') { ?>
<a href="show.php?page=country&status_id=<?= $fetch_row['id']; ?>" class="btn btn-success btn-sm">
<i class="feather icon-eye"></i>
</a>
<?php } else { ?>
<a href="show.php?page=country&status_id=<?= $fetch_row['id']; ?>" class="btn btn-danger btn-sm">
<i class="feather icon-eye-off"></i>
</a>
<?php } ?>
<a href="add_edit.php?page=country&id=<?= $fetch_row['id']; ?>" class="btn btn-info btn-sm">
<i class="feather icon-edit"></i>
</a>
<a href="show.php?page=country&delete_id=<?= $fetch_row['id']; ?>"
onclick="return confirm('Are you sure you want to delete this record?');"
class="btn btn-danger btn-sm">
<i class="feather icon-trash-2"></i>
</a>
</td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</form>
<!-- col-md-12 end -->
</div>
<!-- [ Main Content ] end -->
</div>
</div>
<?php include('../include/footer.php'); ?>
<script>
(function($) {
'use strict';
$.fn.checkAll = function() {
return this.each(function() {
var mainCheckbox = $(this);
var selector = mainCheckbox.attr('data-phonecode-pattern');
mainCheckbox.on('change', function() {
$(selector).prop('checked', mainCheckbox.prop('checked')).trigger('change');
});
$(document).on('change', selector, function() {
var total = $(selector).length;
var checked = $(selector + ':checked').length;
mainCheckbox.prop('checked', total === checked);
});
});
};
$('#phonecode1').checkAll();
})(jQuery);
// ---------- AJAX Update on Check/Uncheck ----------
$(document).on("change", ".phonecode-item", function () {
var country_id = $(this).data("country");
var status = $(this).is(":checked") ? 1 : 0;
$.ajax({
url: "update_phonecode.php",
type: "POST",
data: {
id: country_id,
status: status
},
success: function(response) {
console.log("Updated Country ID: " + country_id + " => " + status);
}
});
});
</script>
<?php
if(!empty($_GET['status_id'])){
$id=$_GET['status_id'];
$stsQry=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM `countries` WHERE id ='$id'"));
if($stsQry['status']==0){
$updtQry=mysqli_query($conn,"UPDATE `countries` SET `status`='1' WHERE id='$id'")or die(mysqli_error($conn));
if($updtQry){
echo "<script>window.location='show.php?page=country';</script>";
$_SESSION['message']="Record Activated Successfully";
}
}
elseif($stsQry['status']==1){
$updtQry=mysqli_query($conn,"UPDATE `countries` SET `status`='0' WHERE id='$id'")or die(mysqli_error($conn));
if($updtQry){
echo "<script>window.location='show.php?page=country';</script>";
$_SESSION['error']="Record Inactivated Successfully";
}
}
}
?>
<?php
if(!empty($_GET['delete_id'])){
$id=$_GET['delete_id'];
$query=mysqli_query($conn,"SELECT * FROM countries WHERE id=".$_GET['delete_id']);
while($row=mysqli_fetch_array($query))
{
$image_name=$row['image1'];
unlink("../../images/Upload/category/".$row['image1']);
}
$dtQuery=mysqli_query($conn,"DELETE FROM `countries` WHERE id=".$_GET['delete_id']);
if($dtQuery){
echo "<script>window.location='show.php?page=country';</script>";
$_SESSION['delete']="Record Deleted Successfully";
}
}
?>
<?php
if(isset($_POST['but_delete'])){
if(isset($_POST['delete'])){
foreach($_POST['delete'] as $deleteid){
$query=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM countries WHERE id=".$deleteid));
unlink("../../images/Upload/category/".$query['image1']);
$deleteUser = "DELETE from slider_tbl WHERE id=".$deleteid;
mysqli_query($conn,$deleteUser);
}
echo "<script>window.location='show.php?page=country';</script>";
$_SESSION['delete']="All Record Deleted Successfully";
}
}
?>
<?php
if(isset($_POST['but_active'])){
if(isset($_POST['delete'])){
foreach($_POST['delete'] as $deleteid){
$deleteUser = "UPDATE `countries` SET `status`='1' WHERE id=".$deleteid;
mysqli_query($conn,$deleteUser);
echo "<script>window.location='show.php?page=country';</script>";
$_SESSION['message']="All Record Activated Successfully";
}
}
}
?>
<?php
if(isset($_POST['but_deactive'])){
if(isset($_POST['delete'])){
foreach($_POST['delete'] as $deleteid){
$deleteUser = "UPDATE `countries` SET `status`='0' WHERE id=".$deleteid;
mysqli_query($conn,$deleteUser);
}
echo "<script>window.location='show.php?page=country';</script>";
$_SESSION['error']="All Record Inactivated Successfully";
}
}
?>