Viewing file:  add_new_student_action.php (1.42 KB) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
require 'connection.php';
$student_name=$_POST['student_name'];
$student_email=$_POST['student_email'];
$mobile_num=$_POST['mobile_num'];
$dob=$_POST['dob'];
$course_id=$_POST['course'];
$address=$_POST['address'];
// $query1 = "select * from course_details order by id desc";
$query1 = "select * from course_details where id='$course_id'";
$result1 = $con->query($query1);
while ($row1 = $result1->fetch_assoc()) {
$course= $row1["name"];
}
$sql = "INSERT INTO `user_details`(`email`, `phone`, `name`,`request_status`,`phone_verified`,`email_verified`,`status`)
VALUES ('$student_email','$mobile_num','$student_name','0','1','1','1')";
$result=$con->query($sql);
$count=$con->affected_rows;
$last_id = $con->insert_id;
$sql_new = "INSERT INTO `student_reg`( `name`, `dob`, `permanent_address1`, `email`,`mobile`,`user_id`,)
VALUES ('$student_name','$dob','$address','$student_email','$student_email','$mobile_num','$last_id')";
$result_new=$con->query($sql_new);
$count_new=$con->affected_rows;
$last_id_new = $con->insert_id;
if ($count>0) {
echo json_encode(array("statusCode"=>$last_id));
}
else {
echo json_encode(array("statusCode"=>0));
}
?>
|