Viewing file:  luckysignup_action.php (2.22 KB) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
require("connection.php");
include 'functions.php';
session_start();
if ($_REQUEST["otp"]) {
$get_otp = $_REQUEST["otp"];
$user_id = $_SESSION['ul_id'];
$update = "update user_details set status='1',phone_verified='1' where otp='$get_otp' AND user_id='$user_id'";
$result1 = $con->query($update);
if ($result1) {
$_SESSION['luckyotp'] = 1;
$get_details = "SELECT user_id, name, otp FROM user_details WHERE otp='" . $get_otp . "' AND user_id='$user_id'";
$get_details1 = mysqli_query($con, $get_details) or die("database error:" . mysqli_error($con));
$count_otp = $get_details1->num_rows;
if ($count_otp > 0) {
while ($row = $get_details1->fetch_assoc()) {
$_SESSION['user_id'] = $row['user_id'];
$_SESSION['user_name'] = $row['name'];
echo 1;
}
}
} else {
echo 0;
}
} else {
$name = $_POST["name"];
$email = $_POST["email"];
$phone = $_POST["phone"];
$message = $_POST["message"];
$_SESSION['luckypopup'] = 1;
// generate OTP
$otp = rand(100000, 999999);
$check = "SELECT email, phone,status FROM user_details WHERE email='" . $email . "' or phone='".$phone."'";
$check = mysqli_query($con, $check) or die("database error:" . mysqli_error($con));
$count = $check->num_rows;
if ($count == 0) {
$query = "insert into user_details(`name`,`email`,`phone`,`otp`,`message`,`request_status`)
values('$name','$email','$phone','$otp','$message','3')";
$result = $con->query($query);
$count = $con->affected_rows;
if ($count > 0) {
$userid=$con->insert_id;
$messagephone='Dear '.$name.', You have successfully registered with Srishti Campus. Please use OTP '.$otp.' to login to your Srishti Campus account. This OTP can be used only once. Please DO NOT disclose it to anyone.';
send_otp_sms($phone,$messagephone,'signup');
$_SESSION['ul_id'] = $userid;
$_SESSION['luckyotp'] = 0;
echo 1;
}
else {
echo 2;
}
} else {
echo 0;
}
}
?>
|