File: /var/www/selfanalyse/school-admin/student-registration.php
<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
include('header.php');
include('sidebar.php');
include_once('../wp-config.php');
$allState = "SELECT state_id, state_name FROM wp_psy_states";
$allStateData = $wpdb->get_results($allState);
$allplans = "SELECT plan_id, plan_name FROM wp_psy_plans";
$allplansData = $wpdb->get_results($allplans);
?>
<div class="page-wrapper">
<div class="page-breadcrumb">
<div class="row">
<div class="col-12 align-self-center">
<h4 class="page-title text-truncate text-dark font-weight-medium mb-1">Student Registration</h4>
<div class="d-flex align-items-center">
<nav aria-label="breadcrumb">
<ol class="breadcrumb m-0 p-0">
<li class="breadcrumb-item"><a href="dashboard" class="text-muted">Home</a></li>
<li class="breadcrumb-item text-muted active" aria-current="page">Student Registration</li>
</ol>
</nav>
</div>
</div>
</div>
</div>
<div class="container-fluid">
<div class="row">
<?php
if (isset($_REQUEST['student-register'])) {
$firstname = $_REQUEST['firstname'];
$mobile = $_REQUEST['mobile'];
$email = $_REQUEST['email'];
$gender = $_REQUEST['gender'];
$dob = $_REQUEST['dob'];
$state = $_REQUEST['state'];
$city = $_REQUEST['city'];
$Type = $_REQUEST['type_id'];
$pwd = bin2hex(openssl_random_pseudo_bytes(4));
$USERID = $_SESSION['user_id'];
$curDateTime = date('Y-m-d H:i:s');
$exists = username_exists($mobile);
if ($exists) {
$errorMsg = "Username already exists";
} else {
$user_id = wp_create_user($mobile, $pwd, $mobile);
if (is_wp_error($user_id)) {
$errorMsg = $user_id->get_error_message();
} else {
$errorMsg ="User Created successfully";
$plans = $wpdb->get_row("SELECT plan_id,reference_id,plan_short_desc FROM wp_psy_plans where plan_id='$Type'");
$refID = $plans->reference_id;
$planSHort = $plans->plan_short_desc;
$planID = $plans->plan_id;
$TotalCount = $wpdb->get_var("SELECT count FROM wp_psy_bulk_plan WHERE school_id='$USERID' AND plan_id='$Type'");
$remainingPlan = $TotalCount - 1;
if($TotalCount != "" || $TotalCount != null){
$wpdb->query("UPDATE wp_psy_bulk_plan SET count='$remainingPlan' WHERE school_id='$USERID' AND plan_id='$Type'");
$wpdb->query("INSERT INTO wp_psy_bulk_plan_transactions SET school_id='$USERID',student_id='$user_id', plan_id='$Type', total_plan ='$TotalCount', remaining_plan='$remainingPlan', date='$curDateTime'");
}
$variableAry=explode(",",$refID);
$planeAry=explode(",",$planSHort);
$a =0;
foreach($variableAry as $variable)
{
$testTYpe = $planeAry[$a];
$wpdb->query("INSERT INTO wp_psy_subscription SET user_id='$USERID',exam_id='$variable', test_type='$testTYpe', status='1', active_status='1', active_date='$curDateTime', source='SP',source_id='1'");
$a++;
}
$wpdb->query("INSERT INTO wp_psy_users_details SET user_id='$user_id', first_name='$firstname', mobile_number='$mobile', email_address='$email', gender_id = '$gender', date_of_birth='$dob', state_id ='$state', city_id='$city'");
$wpdb->query("INSERT INTO wp_psy_school_student SET name='$firstname', mobile='$mobile', email='$email', dob='$dob', state_id='$state', city_id='$city', school_id='$USERID', date='$curDateTime'");
}
}
}
?>
<div class="col-12">
<div class="card">
<div class="card-body">
<h4 class="card-title">Student Registration</h4>
<?php if (isset($errorMsg)) {
echo $errorMsg;
} ?>
<form name="myForm" action="#" method="post" onsubmit="return validateForm()">
<div class="form-body">
<div class="form-group row">
<label class="col-md-2"> Name </label>
<div class="col-md-10">
<div class="row">
<div class="col-md-12">
<div class="form-group">
<input type="text" name="firstname" id="firstname" class="form-control" placeholder="Name" required="required">
</div>
</div>
</div>
</div>
</div>
<div class="form-group row">
<label class="col-md-2">Mobile No</label>
<div class="col-md-10">
<div class="row">
<div class="col-md-12">
<div class="form-group">
<input type="tel" name="mobile" id="mobile" class="form-control" placeholder="Mobile No." required="required">
</div>
</div>
</div>
</div>
</div>
<div class="form-group row">
<label class="col-md-2">Email ID</label>
<div class="col-md-10">
<div class="row">
<div class="col-md-12">
<div class="form-group">
<input type="email" name="email" id="email" class="form-control" placeholder="Email" required="required">
</div>
</div>
</div>
</div>
</div>
<div class="form-group row">
<label class="col-md-2">Gender</label>
<div class="col-md-10">
<div class="row">
<div class="col-md-12">
<select name="gender" class="custom-select"required>
<option value="">Select Gender</option>
<option value="1">Male</option>
<option value="">Female</option>
</select>
</div>
</div>
</div>
</div>
<div class="form-group row">
<label class="col-md-2">Date of Birth</label>
<div class="col-md-10">
<div class="row">
<div class="col-md-12">
<div class="form-group">
<input type="date" name="dob" id="dob" class="form-control" placeholder="last Name" required="required">
</div>
</div>
</div>
</div>
</div>
<div class="form-group row">
<label class="col-md-2">State</label>
<div class="col-md-10">
<div class="row">
<div class="col-md-12">
<select onchange="getState(this);" name="state" class="custom-select" required>
<option value="" name="state" >Select State</option>
<?php foreach ($allStateData as $state) {
?>
<option value="<?php echo $state->state_id; ?>">
<?php echo $state->state_name; ?></option>
<?php } ?>
</select>
</div>
</div>
</div>
</div>
<div class="form-group row">
<label class="col-md-2">City</label>
<div class="col-md-10">
<div class="row">
<div class="col-md-12" id="cityDIV">
<select id="citvselect" name="city" class="custom-select" required>
<option value="0">Select City</option>
</select>
</div>
</div>
</div>
</div>
<div class="form-group row">
<label class="col-md-2">Test Type</label>
<div class="col-md-10">
<div class="row">
<div class="col-md-12">
<select name="type_id" class="custom-select"required>
<option value="">Select Test Type</option>
<?php foreach ($allplansData as $plan) {
?>
<option value="<?php echo $plan->plan_id; ?>">
<?php echo $plan->plan_name; ?></option>
<?php } ?>
</select>
</div>
</div>
</div>
</div>
</div>
<div class="form-actions">
<div class="text-right">
<button type="submit" name="student-register" class="btn btn-info">Submit</button>
<button type="reset" class="btn btn-dark">Reset</button>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
<?php
include('footer.php');
?>
<script type="text/javascript">
function validateForm() {
var x = document.forms["myForm"]["fname"].value;
if (x == "") {
alert("Name must be filled out");
return false;
}
}
function getState(sel) {
$('#citvselect').hide();
$.ajax({
url: "backend/get_cities.php?state_id=" + sel.value,
cache: false,
success: function(html) {
$("#cityDIV").append(html);
}
});
}
</script>