$query = $this->conn->query($sql);
$result = $query->fetch_object();
return $result;
}
function forgot_insert_log($user_id, $code, $status, $log_time)
{
$sql = "INSERT INTO `tbl_user_log` (`user_id`, `code`, `status`, `log_time`) VALUES(?, ?, ?, ?)";
$stmt = $this->conn->prepare($sql);
if ($stmt === false) {
trigger_error('Database error: ' . $sql . ' Error: ' . $this->conn->errno . ' ' . $this->conn->error, E_USER_ERROR);
} else {
$stmt->bind_param("ssss", $user_id, $code, $status, $log_time);
$stmt->execute();
}
$stmt->close();
}
}
$_ajax = new AJAX_CLASS();
$email = filter_var($_POST['email'], FILTER_SANITIZE_EMAIL);
$count = $_ajax->count_email($email);
if ($count->rows > 0) {
$data = $_ajax->get_email($email);
$user_id = $data->user_id;
$code = strtolower(randomchr($length));
$status = 1;
$log_time = "NOW()";
$_ajax->forgot_insert_log($user_id, $code, $status, $log_time);
require_once '../../admin/emails/_forgot/_user_forgot.php';
} else {
}
}
$sql = "UPDATE `tbl_user_log` SET `code` = ?,\n\t\t \t\t\t\t\t\t\t\t\t `log_time` = ?\n\t WHERE `code` = '{$prev_code}' AND `user_id` = ?\n\t\t\t\t ";
$stmt = $this->conn->prepare($sql);
if ($stmt === false) {
trigger_error('Database error: ' . $sql . ' Error: ' . $this->conn->errno . ' ' . $this->conn->error, E_USER_ERROR);
} else {
$stmt->bind_param("ssss", $code, $log_time, $prev_code, $user_id);
$stmt->execute();
}
$stmt->close();
}
}
$_ajax = new AJAX_CLASS();
$user_email = filter_var($_POST['email'], FILTER_SANITIZE_EMAIL);
$count = $_ajax->count_email($user_email);
if ($count->rows > 0) {
$data = $_ajax->get_email($user_email);
$length = 25;
$user_id = $data->user_id;
$code = strtolower(randomchr($length));
$status = 1;
$log_time = date('Y-m-d H:i:s');
$_ajax->forgot_insert_log($user_id, $code, $status, $log_time);
require_once '../../../admin/emails/_forgot/_user_forgot.php';
$type = 'success';
$msg = 'Email has been sent to: ' . $user_email;
echo '<div class="alert alert-' . $type . '">';
echo $msg;
echo '</div>';
} else {
$type = 'danger';
$msg = 'Not found record for email: ' . $user_email;
