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_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(0);
}
$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'];
?>
<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;
}
.search_select {
width: 100%;
padding: 8px 4px;
}
#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;
}
.select2-selection{
border: 1px solid #ced4da !important;
padding-bottom: 41px !important;
}
</style>
<!-- Update data warp --->
<!-- 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>
<!-- [ 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 -->
<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 `new_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">
<label class="form-label" for="phone">Phone</label><br>
<div class="form-group d-flex">
<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['phonecode'] ?>" <?= ($fet_cont['phonecode'] == $fetQuery['phonecode']) ? 'selected' : '' ?>>+<?= $fet_cont['phonecode'] ?></option>
<?php } ?>
</select>
<input type="number" name="phone" placeholder="Mobile Number" value="<?php if ($id != '') {
echo $fetQuery['phone'];
} ?>" class="form-control mb-3">
</div>
</div>
<div class="col-md-6">
<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> -->
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Image">Image</label>
<input type="file" name="image1" class="form-control">
</div>
<?php if ($id != '') {
if (!empty($fetQuery['image1'])) {
$profile_img1 = $fetQuery['image1'];
} else {
$profile_img1 = 'user_profile.jpg';
} ?>
<img src="<?= $base_url ?>images/Upload/users/<?= $profile_img1 ?>" style="width: 120px; height: 100px; margin:6px;">
<?php } ?>
</div>
<div class="col-md-12">
<div class="form-group">
<label class="form-label" for="Address">Address</label>
<textarea name="address" class="form-control" rows="4"><?php if ($id != '') { echo $fetQuery['address']; } ?></textarea>
</div>
</div>
<!-- Coupons start --->
<div class="col-md-6">
<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">
<input type="text" class="search_select" id="coupon_search" onkeyup="filtercoupon()" placeholder="Search Coupons ...">
<?php
$dealQuery = mysqli_query($conn, "SELECT * FROM coupon_tbl WHERE status=1");
while ($row = mysqli_fetch_array($dealQuery)) {
if (in_array($row['id'], explode(',', $fetQuery['coupon']))) {
$checked = "checked";
} else {
$checked = "";
}
?>
<label for="coupon<?= $row['id'] ?>" style="font-size: 15px; padding: 10px;">
<input type="checkbox" id="coupon<?= $row['id'] ?>" value="<?= $row['id'] ?>" class="mx-2" name="coupon_id[]" onchange="updatecouponSelectBox();" <?= $checked ?> /><?= $row['coupon'] ?>
</label>
<?php } ?>
</div>
</div>
</div>
<!-- Coupons ends --->
<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=users">Back</a>
</div>
</div>
</form>
</div>
</div>
</div>
<!-- [ form-element ] end -->
</div>
<!-- [ Main Content ] end -->
</div>
</section>
<?php include('../include/footer.php'); ?>
<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";
}
}
// Initial call to update the select box text based on the pre-checked checkboxes
document.addEventListener("DOMContentLoaded", function() {
updatecouponSelectBox();
});
var deal_expanded = false;
function showcouponCheckboxes() {
var checkboxes = document.getElementById("coupon_checkboxes");
var checkboxItems = checkboxes.getElementsByTagName("input");
if (!deal_expanded) {
if (checkboxItems.length > 0) {
checkboxes.style.display = "block";
deal_expanded = true;
}
} else {
checkboxes.style.display = "none";
deal_expanded = false;
}
}
function filtercoupon() {
var input = document.getElementById("coupon_search");
var filter = input.value.toLowerCase();
var checkboxes = document.getElementById("coupon_checkboxes");
var labels = checkboxes.getElementsByTagName("label");
for (var i = 0; i < labels.length; i++) {
var label = labels[i];
var text = label.textContent || label.innerText;
if (text.toLowerCase().indexOf(filter) > -1) {
label.style.display = "";
} else {
label.style.display = "none";
}
}
}
</script>
<!-- Insert data start --->
<?php
if (isset($_POST['add'])) {
$name = $_POST['name'];
$name = str_replace("'", "\'", $name);
if (!empty($_POST['coupon_id']) && count(array_keys($_POST['coupon_id'])) > 0) {
$coupon_ids = implode(",", $_POST['coupon_id']);
} else {
$coupon_ids = '';
}
$phonecode=$_POST['phonecode'];
$phone = $_POST['phone'];
// $email=$_POST['email'];
$DOB = $_POST['DOB'];
// $password=$_POST['password'];
// $password=str_replace("'", "\'", $password);
$slug = create_url($name);
$registration_date = date('Y-m-d H:i:s');
$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 `new_user_tbl` SET
`name`='$name',
`coupon`='$coupon_ids',
`phonecode`='$phonecode',
`phone`='$phone',
-- `email`='$email',
`DOB`='$DOB',
-- `password`='$password',
`image1`='$new_file_name',
`registration_date`='$registration_date',
`slug`='$slug',
`status`='$status'") or die(mysqli_error($conn));
$ido = mysqli_insert_id($conn);
$slug1 = $slug . $ido;
mysqli_query($conn, "UPDATE `new_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 = str_replace("'", "\'", $_POST['name']);
if (!empty($_POST['coupon_id']) && count(array_keys($_POST['coupon_id'])) > 0) {
$coupon_ids = implode(",", $_POST['coupon_id']);
} else {
$coupon_ids = '';
}
$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 `new_user_tbl` WHERE id='$id'"));
if ($dl) {
unlink('../../images/Upload/users/' . $dl['image1']);
}
move_uploaded_file($file_tmp, $file_path);
mysqli_query($conn, "UPDATE `new_user_tbl` SET `image1`='$new_file_name' WHERE id='$id'");
}
$editQry = mysqli_query($conn, "UPDATE `new_user_tbl` SET
`name`='$name',
`coupon`='$coupon_ids',
`phonecode`='$phonecode',
`phone`='$phone',
-- `email`='$email',
`DOB`='$DOB',
-- `password`='$password',
`slug`='$slug',
`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";
}
}
?>
<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>