$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;