$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 {
}
}
