File: /var/www/selfanalyse/counselor/edit-user-data.php
<?php
include_once('header.php');
include_once('../wp-config.php');
global $current_user;
get_currentuserinfo();
$adminId = $current_user->ID; // print session USER_ID
$curDateTime = date('Y-m-d H:i:s'); // add 5 hrs 30 min in
$PSY_USERS = $wpdb->prefix . PSY_USERS;
$PSY_STATES = $wpdb->prefix . PSY_STATES;
$PSY_USERS_DETAILS = $wpdb->prefix . PSY_USERS_DETAILS;
$uId = $_REQUEST['uId'];
//create user
if (isset($_REQUEST['update_user'])) {
$usersp_firstname = $_REQUEST['usersp_firstname'];
$usersp_lastname = $_REQUEST['usersp_lastname'];
$usersp_email = $_REQUEST['usersp_email'];
$usersp_phone = $_REQUEST['usersp_phone'];
$user_gender = $_REQUEST['user_gender'];
$user_dob = $_REQUEST['user_dob'];
if ($_REQUEST['user_dob']) {
$dobQuery = ",date_of_birth='".date('Y-m-d',strtotime($user_dob))."'";
} else {
$dobQuery = '';
}
if ($uId != '' && $uId != 0) {
$updateUser = "UPDATE $PSY_USERS_DETAILS set first_name='$usersp_firstname',last_name='$usersp_lastname',email_address='$usersp_email',mobile_number='$usersp_phone',gender_id='$user_gender' $dobQuery WHERE user_id='$uId'";
if ($wpdb->query($updateUser)) {
$msg = '<div class="alert alert-success alert-dismissible" role="alert">User updated successfully<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button></div>';
} else {
$msg = '<div class="alert alert-danger alert-dismissible" role="alert">User not updated<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button></div>';
}
}
}
/****
*
* fetch user details
*/
$getUserData = $wpdb->get_row("SELECT u.first_name,u.last_name,u.email_address,u.mobile_number,u.gender_id,u.date_of_birth,u.state_id,u.city_id FROM $PSY_USERS_DETAILS as u LEFT JOIN $PSY_STATES as s on s.state_id=u.state_id where u.user_id='$uId'");
?>
<div class="page-inner">
<div class="page-title">
<div class="col-md-4">
<h3> Edit User</h3>
<div class="page-breadcrumb">
<ol class="breadcrumb">
<li><a href="dashboard">Home</a></li>
<li class="active">Edit User Data</li>
</ol>
</div>
</div>
<div class="col-md-8">
<div class="navbar-right">
<ul class="navul">
<!--<li><a href="apt-class">Class List</a></li>-->
</ul>
</div>
</div>
</div>
<div id="main-wrapper">
<div class="row">
<div class="col-md-12">
<div class="panel panel-primary">
<div class="panel-heading clearfix">
<h4 class="panel-title">Edit User</h4>
</div>
</div>
</div>
<div class="col-md-12">
<div class="panel">
<div class="panel-body">
<span id="alert1" style="display: block;"><?php if (isset($msg)) {
echo $msg;
} ?></span>
<form id="frmaddQues" method="post" action="" onsubmit="return validateForm();">
<div class="form-group" style="float:left; width:100%;">
<label for="input-Default" class="col-sm-3 control-label">FirstName:</label>
<div class="col-sm-5">
<input type="text" name="usersp_firstname" id="usersp_firstname" class="form-control" placeholder="enter first name.." value="<?php echo $getUserData->first_name ?>" id="cat_name">
</div>
</div>
<div class="form-group" style="float:left; width:100%;">
<label for="input-Default" class="col-sm-3 control-label">LastName:</label>
<div class="col-sm-5">
<input type="text" name="usersp_lastname" id="usersp_lastname" class="form-control" placeholder="enter last name.." value="<?php echo $getUserData->last_name ?>" id="cat_name">
</div>
</div>
<div class="form-group" style="float:left; width:100%;">
<label for="input-Default" class="col-sm-3 control-label">Email:</label>
<div class="col-sm-5">
<input type="email" name="usersp_email" id="usersp_email" class="form-control" placeholder="enter email" value="<?php echo $getUserData->email_address; ?>">
</div>
</div>
<div class="form-group" style="float:left; width:100%;">
<label for="input-Default" class="col-sm-3 control-label">Phone:</label>
<div class="col-sm-5">
<input type="tel" name="usersp_phone" id="usersp_phone" class="form-control" placeholder="enter mobile" value="<?php echo $getUserData->mobile_number; ?>">
</div>
</div>
<div class="form-group" style="float:left; width:100%;">
<label for="input-Default" class="col-sm-3 control-label">Gender:</label>
<div class="col-sm-5">
<select name="user_gender" class="form-control">
<option value="Male" <?php echo $getUserData->gender_id == 'Male' ? 'selected' : '' ?>>Male</option>
<option value="Female" <?php echo $getUserData->gender_id == 'Female' ? 'selected' : '' ?>>Female</option>
</select>
</div>
</div>
<div class="form-group" style="float:left; width:100%;">
<label for="input-Default" class="col-sm-3 control-label">DOB:</label>
<div class="col-sm-5">
<input type="text" class="form-control" onfocus="(this.type='date')" name="user_dob" placeholder="Your date of birth" id="user_dob" value="<?php echo $getUserData->date_of_birth == '' ? '' : date('Y/m/d', strtotime($getUserData->date_of_birth)); ?>" required>
<span class="error">Date Format : year/month/date</span>
</div>
</div>
<div class="form-group" style="float:left; width:100%;">
<label for="input-Default" class="col-sm-3 control-label"> </label>
<div class="col-sm-5">
<button type="submit" name="update_user" class="btn btn-primary btn-rounded">Update</button>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
<!-- Main Wrapper -->
<div class="page-footer">
<p class="no-s">shinemetrics.com</p>
</div>
</div>
<script>
//validate email
function validateEmail($email) {
var emailReg = /^([\w-\.]+@([\w-]+\.)+[\w-]{2,4})?$/;
if (!emailReg.test($email)) {
return false;
} else {
return true;
}
}
//validate mobile number
function validateMobile($mobile) {
var mobilePat = /^\d{10}$/;
if (!mobilePat.test($mobile)) {
return false;
} else {
return true;
}
}
function validateForm() {
if (jQuery('#usersp_email').val() == '') {
jQuery("#alert1").html('<div class="alert alert-danger alert-dismissible" role="alert">Email is required*<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button></div>');
return false;
}
if (!validateEmail(jQuery('#usersp_email').val())) {
jQuery("#alert1").html('<div class="alert alert-danger alert-dismissible" role="alert">Email is not valid*<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button></div>');
return false;
}
if (jQuery('#usersp_phone').val() == '') {
jQuery("#alert1").html('<div class="alert alert-danger alert-dismissible" role="alert">Mobile number is required*<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button></div>');
return false;
}
if (!validateMobile(jQuery('#usersp_phone').val())) {
jQuery("#alert1").html('<div class="alert alert-danger alert-dismissible" role="alert">Mobile number is not valid*<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button></div>');
return false;
}
return true;
}
</script>
<?php
include_once('footer.php');
?>