|
Server IP : 153.92.220.142 / Your IP : 216.73.216.128 Web Server : LiteSpeed System : Linux nl-srv-web513.main-hosting.eu 5.14.0-503.34.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Thu Mar 27 06:00:50 EDT 2025 x86_64 User : u444427800 ( 444427800) PHP Version : 8.1.32 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u444427800/domains/dronacharyasunayana.com/public_html/billing/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php include('header.php') ?>
<div class="breadcrumb-top">
<ol class="breadcrumb">
<li class="breadcrumb-item"><a href="dashboard.php">Dashboard</a></li>
<li class="breadcrumb-item active"><a href="#">Edit User</a></li>
<!---<li class="breadcrumb-item active">Accessories</li> -->
</ol>
</div>
<!--------------------------------Start main body section----------------------------------->
<div class="col-lg-12">
<div class="primary-panel">
<div class="heading">
<h2>Edit User</h2>
</div>
<?php
$id= $_REQUEST['sid'];
$sql="SELECT * FROM `user` JOIN `state_data` ON user.state = state_data.state_id JOIN city_data ON user.user_city_id = city_data.city_id WHERE `user_id`='$id' ";
$run=mysqli_query($db,$sql);
$data=mysqli_fetch_assoc($run);
$id=$data['user_id'];
$name=$data['name'];
$mobile=$data['mobile'];
$state=$data['state'];
$user_city_id=$data['user_city_id'];
$city_name=$data['city_name'];
$address=$data['address'];
$email=$data['email'];
$role=$data['role'];
$password=$data['password'];
$status=$data['user_status'];
?>
<form method="post" class="editForm" action="" enctype="multipart/form-data">
<div class="row">
<div class="col-lg-4 col-md-6">
<div class="form-group">
<label>User Name</label>
<input type="text" id="name" name="name" class="form-control" value="<?php echo $name ; ?>">
</div>
</div>
<div class="col-lg-4 col-md-6">
<div class="form-group">
<label>Role</label>
<select name="role" id="role" class="form-control" >
<option value="<?php echo $role ; ?>"><?php echo $role ; ?></option>
<option value="Admin">Admin</option>
<option value="User">User</option>
</select>
</div>
</div>
<div class="col-lg-4 col-md-6">
<div class="form-group">
<label>Mobile No. </label>
<input type="text" id="mobile" name="mobile" class="form-control" value="<?php echo $mobile ;?>" required="">
</div>
</div>
<div class="col-lg-4 col-md-6">
<div class="form-group">
<label>State</label>
<select name="state_id" id="StateID" class="form-control" required="">
<option value="">Select state</option>
<?php
$sql="SELECT * FROM `state_data` ";
$run=mysqli_query($db,$sql);
while($data=mysqli_fetch_assoc($run)){
$state_id=$data['state_id'];
$state_code=$data['state_code'];
$state_name=$data['state_name'];
?>
<option value="<?php echo $state_id ;?>" <?php if($state == $state_id) echo 'selected ="selected"' ?>><?php echo $state_name ;?> - <?php echo $state_code ;?></option>
<?php }?>
</select>
</div>
</div>
<div class="col-lg-4 col-md-6">
<div class="form-group">
<label>City</label>
<select name="city_id" id="cityID" class="form-control" required="">
<option value="<?php echo $user_city_id ;?>" ><?php echo $city_name ;?> </option>
</select>
</div>
</div>
<div class="col-lg-4 col-md-6">
<div class="form-group">
<label>User Email</label>
<input type="text" id="email" name="email" class="form-control" value="<?php echo $email ; ?>">
</div>
</div>
<div class="col-lg-4 col-md-6">
<div class="form-group">
<label>Password</label>
<input type="password" name="password" id="password" class="form-control" value="<?php echo $password ; ?>">
</div>
</div>
<div class="col-lg-4 col-md-6">
<div class="form-group">
<label>Status</label>
<select name="user_status" class="form-control">
<option value="<?php echo $status ; ?>"><?php if($status==1){ echo "Active" ; } else{ echo "Deactive" ; } ?></option>
<option value="1">Active</option>
<option value="0">Deactive</option>
</select>
</div>
</div>
<div class="col-lg-8 col-md-6">
<div class="form-group">
<label>Address</label>
<textarea name="address" class="form-control" ><?php echo $address ; ?></textarea>
</div>
</div>
<div class="col-lg-12">
<button type="submit" name="submit" class="btn btn-primary">Submit</button>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
<!----------------------------------End Main body Section----------------------------------->
</div>
</div>
<?php include('footer.php') ?>
<!----- search script code start here--------->
<script src="https://cdn.rawgit.com/rainabba/jquery-table2excel/1.1.0/dist/jquery.table2excel.min.js"></script>
<script>
$(document).ready(function(){
/* Search table */
$("#myInput").on("keyup", function() {
var value = $(this).val().toLowerCase();
$("#myTable tr").filter(function() {
$(this).toggle($(this).text().toLowerCase().indexOf(value) > -1)
});
});
/* Export table */
$('#export-table').click(function(){
$("#myTable").table2excel({
filename: "Users.xls"
});
})
});
</script>
<script src="https://cdn.jsdelivr.net/jquery.validation/1.16.0/jquery.validate.min.js"></script>
<script src="https://cdn.jsdelivr.net/jquery.validation/1.16.0/additional-methods.min.js"></script>
<script>
jQuery.validator.addMethod("emailfull", function(value, element) {
return this.optional(element) || /^([a-z\d!#$%&'*+\-\/=?^_`{|}~\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]+(\.[a-z\d!#$%&'*+\-\/=?^_`{|}~\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]+)*|"((([ \t]*\r\n)?[ \t]+)?([\x01-\x08\x0b\x0c\x0e-\x1f\x7f\x21\x23-\x5b\x5d-\x7e\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]|\\[\x01-\x09\x0b\x0c\x0d-\x7f\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]))*(([ \t]*\r\n)?[ \t]+)?")@(([a-z\d\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]|[a-z\d\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF][a-z\d\-._~\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]*[a-z\d\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])\.)+([a-z\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]|[a-z\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF][a-z\d\-._~\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]*[a-z\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])\.?$/i.test(value);
}, "Please enter valid email address!");
jQuery.validator.addMethod("lettersonly", function(value, element) {
return this.optional(element) || /^[a-z\s]+$/i.test(value);
}, "Only alphabetical characters");
$(".editForm").validate({
rules: {
name: {
required: true,
lettersonly: true
},
role: {
required: true,
lettersonly: true
},
email: {
required: true,
emailfull: true
},
mobile: {
required: true,
number: true,
minlength: 10,
maxlength: 10
},
password: {
required: true,
},
status: {
required: true,
}
},
});
$(document).ready(function(){
$("#StateID").change(function(){
var stateID = $(this).val();
$("#cityID option").remove();
if(stateID != '0')
{
$.ajax({
type: 'GET',
url: 'getCity.php',
data: {state_id:stateID},
success: function(data){
/* var jsonData1 = JSON.parse(data);
for (var i = 0; i < jsonData1.length; i++) {
appenddata1 += "<option value = '" + jsonData1[i].id + " '>" + jsonData1[i].state_name + " </option>";
}*/
$("#cityID").append(data);
}
});
}
});
});
</script>
<!----------- search script code end here----->
<?php
if(isset($_POST['submit'])){
$name= $_POST['name'];
$mobile= $_POST['mobile'];
$state_id= $_POST['state_id'];
$city_id= $_POST['city_id'];
$address= $_POST['address'];
$role= $_POST['role'];
$email= $_POST['email'];
$password= $_POST['password'];
$status= $_POST['user_status'];
$admin_query="UPDATE `user` SET `name`='$name', `mobile`='$mobile', `state`='$state_id', `user_city_id`='$city_id', `address`='$address', `role`='$role',`email`='$email', `password`='$password',`user_status`='$status' WHERE `user_id`='$id' ";
$run= mysqli_query($db,$admin_query);
echo "<script> window.open('user.php','_self')</script>";
}
?>