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_93b53270/admin/manage_user/ |
Upload File : |
<?php
// error_reporting(0);
include("../function.php");
if($_SESSION['admin_id']==""){
header('location:../login.php');
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
}
$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> Add | Edit | Users </button>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- [ breadcrumb ] end -->
<!-- [ Main Content ] start -->
<style type="text/css">
.multiselect {
/* width: 256px;*/
margin-top: 5px;
margin-left: 9px;
margin-bottom: 18px;
}
.selectBox {
position: relative;
}
.selectBox select {
width: 100%;
padding: 10px;
/*font-weight: bold;*/
}
.overSelect {
position: absolute;
left: 0;
right: 0;
top: 0;
bottom: 0;
}
#checkboxes {
display: none;
border: 1px #dadada solid;
max-height: 150px; /* Set maximum height for the checkboxes */
overflow-y: auto;
}
#checkboxes label {
display: block;
}
#checkboxes label:hover {
background-color: #f2cbd9;
}
#coupon_checkboxes {
display: none;
border: 1px #dadada solid;
max-height: 150px; /* Set maximum height for the checkboxes */
overflow-y: auto;
}
#coupon_checkboxes label {
display: block;
}
#coupon_checkboxes label:hover {
background-color: #f2cbd9;
}
#coupons_search {
width: 100%;
box-sizing: border-box;
padding: 8px;
margin-bottom: 10px;
border: 1px solid #ccc;
}
</style>
<!-- Include Select2 CSS and JS -->
<link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-beta.1/dist/css/select2.min.css" rel="stylesheet" />
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-beta.1/dist/js/select2.min.js"></script>
<style>
.select2-container .select2-selection--single{ height:40px !important; }
.select2-container--default .select2-selection--single .select2-selection__rendered{ line-height:40px !important; }
.select2-container--default .select2-selection--single .select2-selection__arrow{ height:40px !important; }
.select2-container--default .select2-selection--single{ border:none; background:#f6f5f5 !important; }
.select2.select2-container.select2-container--default.select2-container--above.select2-container--focus{ width: 100px !important; }
</style>
<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['otp_message'])){
echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
<strong class="text-dark">'.$_SESSION['otp_message'].'</strong>
<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close">
</button>
</div>';
}
unset($_SESSION['otp_message']);
?>
<?php
$fetQuery=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM user_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="Name">Name</label>
<input type="text" name="name" class="form-control" value="<?php if($id!=''){echo $fetQuery['name'];} ?>">
</div>
</div>
<!-- <div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Name">Name Arabic</label>
<input type="text" name="name_ar" class="form-control" value="<?php if($id!=''){echo $fetQuery['name_ar'];} ?>">
</div>
</div> -->
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Email">Email</label>
<input type="email" name="email" class="form-control" value="<?php if($id!=''){echo $fetQuery['email'];} ?>">
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label class="form-label">Mobile Number</label>
<div class="flex-country d-flex pro">
<div>
<select class="form-control select2" name="phonecode" required style="width:90px;">
<?php $mycont = mysqli_query($conn, "SELECT * FROM `countries`");
while ($fet_cont = mysqli_fetch_array($mycont)) { ?>
<option value="<?=$fet_cont['id']?>" <?=($fet_cont['id']==$fetQuery['phonecode'])?'selected':''?>>+<?=$fet_cont['phonecode']?></option>
<?php } ?>
</select>
</div>
<div>
<input type="number" name="phone" value="<?=$fetQuery['mobile_number']?>" placeholder="Mobile Number" class="form-control mb-3">
</div>
</div>
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label class="form-label" for="DOB">Date Of Birth</label>
<input type="date" name="DOB" class="form-control" value="<?php if($id!=''){echo $fetQuery['DOB'];} ?>">
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label class="form-label" for="Password">Password</label>
<input type="text" name="password" class="form-control" value="<?php if($id!=''){echo $fetQuery['password'];} ?>">
</div>
</div>
<!-- Coupons start --->
<div class="col-md-4">
<div class="multiselect">
<label class="form-label" for="Coupons">Coupons</label>
<div class="selectBox" onclick="showcouponCheckboxes()">
<select id="coupon_select">
<option>Select Coupons</option>
</select>
<div class="overSelect"></div>
</div>
<div id="coupon_checkboxes" style="display: none;">
<input type="text" id="coupons_search" onkeyup="filtercoupon()" placeholder="Search Coupons ...">
<!-- Select All Checkbox -->
<label for="coupon_select_all" style="font-size: 15px; padding: 10px;">
<input type="checkbox" id="coupon_select_all" class="mx-2" onchange="toggleSelectAllCoupons(this)">Select All
</label>
<?php
$brandQuery = mysqli_query($conn, "SELECT * FROM coupon_tbl WHERE status=1");
while ($row = mysqli_fetch_array($brandQuery)) {
$coupon_ids = explode(',', $fetQuery['coupon_id']);
$checked = in_array($row['id'], $coupon_ids) ? "checked" : "";
?>
<label for="coupon<?= $row['id'] ?>" style="font-size: 15px; padding: 10px;">
<input type="checkbox" id="coupon<?= $row['id'] ?>" value="<?= $row['id'] ?>" data-coupon_id="<?= $row['id'] ?>" class="mx-2 coupon_item" name="coupon_id[]" onchange="updatecouponSelectBox();" <?= $checked ?> /><?= $row['coupon'] ?>
</label>
<?php } ?>
</div>
</div>
</div>
<!-- Coupons ends --->
<div class="col-md-4">
<div class="form-group">
<label class="form-label" for="Image">Image</label>
<input type="file" name="image1" class="form-control">
</div>
<?php
if (!empty($id)) {
$userImage = 'user_icon.png';
$imageFolder = '../../images/Upload/user/';
$imageName = $fetQuery['image1'] ?? '';
if (!empty($imageName) && file_exists($imageFolder . $imageName)) {
$userImage = $imageName;
}
$imagePath =$imageFolder . $userImage;
?>
<img src="<?= $imagePath ?>" style="width: 120px; height: 100px;">
<?php } ?>
</div>
<div class="col-md-4">
<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=users">Back</a></button>
</div>
</div>
</form>
</div>
</div>
</div>
<!-- [ form-element ] end -->
</div>
<!-- [ Main Content ] end -->
</div>
</section>
<?php include('../include/footer.php'); ?>
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-beta.1/dist/js/select2.min.js"></script>
<script>
$(document).ready(function() {
$('.select2').select2();
});
</script>
<script>
function updatecouponSelectBox() {
var checkboxes = document.querySelectorAll('input[name="coupon_id[]"]:checked');
var selectBox = document.getElementById("coupon_select");
if (checkboxes.length > 0) {
selectBox.options[0].text = checkboxes.length + " selected";
} else {
selectBox.options[0].text = "Select Coupons";
}
// Update "Select All" checkbox state dynamically
var allCheckboxes = document.querySelectorAll('input[name="coupon_id[]"]');
var selectAll = document.getElementById("coupon_select_all");
selectAll.checked = (checkboxes.length === allCheckboxes.length);
}
document.addEventListener("DOMContentLoaded", function() {
updatecouponSelectBox();
});
var brand_expanded = false;
function showcouponCheckboxes() {
var checkboxes = document.getElementById("coupon_checkboxes");
checkboxes.style.display = brand_expanded ? "none" : "block";
brand_expanded = !brand_expanded;
}
function filterBrand() {
var input = document.getElementById("coupons_search");
var filter = input.value.toLowerCase();
var labels = document.getElementById("coupon_checkboxes").getElementsByTagName("label");
for (var i = 0; i < labels.length; i++) {
var text = labels[i].textContent || labels[i].innerText;
labels[i].style.display = text.toLowerCase().indexOf(filter) > -1 ? "" : "none";
}
}
// ✅ FIXED FUNCTION — handles Select All toggle
function toggleSelectAllCoupons(selectAllCheckbox) {
var checkboxes = document.querySelectorAll('input[name="coupon_id[]"]');
checkboxes.forEach(function(checkbox) {
checkbox.checked = selectAllCheckbox.checked;
});
updatecouponSelectBox();
// 🔥 Trigger change event so AJAX runs too
$(".coupon_item").trigger("change");
}
</script>
<!-- Insert data start --->
<?php
if(isset($_POST['add'])){
$name=$_POST['name'];
$name=str_replace("'", "\'", $name);
// $name_ar=$_POST['name_ar'];
// $name_ar=str_replace("'", "\'", $name_ar);
$coupon_ids = isset($_POST['coupon_id']) ? implode(",", $_POST['coupon_id']) : '';
$phonecode=$_POST['phonecode'];
$phone=$_POST['phone'];
$email=$_POST['email'];
$DOB=$_POST['DOB'];
$password=$_POST['password'];
$password=str_replace("'", "\'", $password);
$slug=create_url($name);
$status=$_POST['status'];
$file_name = $_FILES['image1']['name'];
$file_tmp = $_FILES['image1']['tmp_name'];
$file_ext = strtolower(end(explode('.',$file_name)));
$random_number = rand(111111111, 999999999);
$new_file_name = $random_number . '.' . $file_ext;
$file_path = "../../images/Upload/users/" . $new_file_name;
move_uploaded_file($file_tmp, $file_path);
$addQry=mysqli_query($conn,"INSERT `user_tbl` SET
`name`='$name',
-- `name_ar`='$name_ar',
`coupon_id`='$coupon_ids',
`phonecode`='$phonecode',
`mobile_number`='$phone',
`email`='$email',
`DOB`='$DOB',
`password`='$password',
`image1`='$new_file_name',
`slug`='$slug',
`type`='User',
`status`='$status'")or die(mysqli_error($conn));
$ido=mysqli_insert_id($conn);
$slug1=$slug.$ido;
mysqli_query($conn,"UPDATE `user_tbl` SET `slug`='$slug1' WHERE id='$ido'");
if($addQry){
echo "<script>window.location='show.php?page=users';</script>";
$_SESSION['message']="Record Added successfully";
}
}
?>
<!-- Insert data warp --->
<!-- Update data start --->
<?php
if(isset($_POST['update'])){
$name=$_POST['name'];
$name=str_replace("'", "\'", $name);
// $name_ar=$_POST['name_ar'];
// $name_ar=str_replace("'", "\'", $name_ar);
$coupon_ids = isset($_POST['coupon_id']) ? implode(",", $_POST['coupon_id']) : '';
$phonecode=$_POST['phonecode'];
$phone=$_POST['phone'];
$email=$_POST['email'];
$DOB=$_POST['DOB'];
$password=$_POST['password'];
$password=str_replace("'", "\'", $password);
$slug=create_url($name).$id;
$status=$_POST['status'];
$file_name = $_FILES['image1']['name'];
$file_tmp = $_FILES['image1']['tmp_name'];
$file_ext = strtolower(end(explode('.',$file_name)));
if(!empty($file_name)){
$random_number = rand(111111111, 999999999);
$new_file_name = $random_number . '.' . $file_ext;
$file_path = "../../images/Upload/users/" . $new_file_name;
$dl=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM `user_tbl` WHERE id='$id'"));
if($dl)
{
unlink('../../images/Upload/users/'.$dl['image1']);
}
move_uploaded_file($file_tmp, $file_path);
mysqli_query($conn,"UPDATE `user_tbl` SET `image1`='$new_file_name' WHERE id='$id'");
}
$editQry=mysqli_query($conn,"UPDATE `user_tbl` SET
`name`='$name',
-- `name_ar`='$name_ar',
`coupon_id`='$coupon_ids',
`phonecode`='$phonecode',
`mobile_number`='$phone',
`email`='$email',
`DOB`='$DOB',
`password`='$password',
`slug`='$slug',
`type`='User',
`status`='$status' WHERE id='$id'")or die(mysqli_error($conn));
if($editQry){
echo "<script>window.location='show.php?page=users';</script>";
$_SESSION['message']="Record Updated successfully";
}
}
?>
<!-- Update data warp --->