Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
.vscode	[ DIR ]	drwxr-xr-x
Paytm	[ DIR ]	drwxr-xr-x
Reports	[ DIR ]	drwxr-xr-x
cronjobs	[ DIR ]	drwxr-xr-x
css	[ DIR ]	drwxr-xr-x
grvfiles	[ DIR ]	drwxr-xr-x
html_modules	[ DIR ]	drwxr-xr-x
html_modules_old	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
img	[ DIR ]	drwxr-xr-x
js	[ DIR ]	drwxr-xr-x
js_old	[ DIR ]	drwxr-xr-x
libs	[ DIR ]	drwxr-xr-x
photocopy	[ DIR ]	drwxr-xr-x
plugins	[ DIR ]	drwxr-xr-x
qparchive	[ DIR ]	drwxr-xr-x
razorpay	[ DIR ]	drwxr-xr-x
src	[ DIR ]	drwxr-xr-x
src_old	[ DIR ]	drwxr-xr-x
tcpdf	[ DIR ]	drwxr-xr-x
.DS_Store	21.9 KB	-rwxr-xr-x
MainPage.html	19.71 KB	-rwxr-xr-x
app.php	416 B	-rwxr-xr-x
cconfig.php	1.56 KB	-rwxr-xr-x
database.php	507 B	-rwxr-xr-x
forgot-password.html	5.51 KB	-rwxr-xr-x
forgot-password.php	2.52 KB	-rwxr-xr-x
forgotPassword.html	5.67 KB	-rwxr-xr-x
getstatesanduniv.php	469 B	-rwxr-xr-x
index.html	7.74 KB	-rwxr-xr-x
instruction.html	5.19 KB	-rwxr-xr-x
payment.php	4.58 KB	-rwxr-xr-x
pgResponse.php	10.48 KB	-rwxr-xr-x
registration.php	543 B	-rwxr-xr-x
resetpassword.php	1.04 KB	-rwxr-xr-x
sendMobEmailOTP.php	3.6 KB	-rwxr-xr-x
sign-up.html	11.73 KB	-rwxr-xr-x
signin.php	1.88 KB	-rwxr-xr-x
signup.php	1.23 KB	-rwxr-xr-x
upload_file.php	1.13 KB	-rwxr-xr-x
validateInfo.php	1.77 KB	-rwxr-xr-x
validateRegno.php	670 B	-rwxr-xr-x
verify.php	10.65 KB	-rwxr-xr-x

Code Editor : forgot-password.php

<?php
require_once("cManualMailer.php");
include ("database.php");
include("sendsmsapi.php");
include("sendGridMail.php");
error_reporting(E_ALL);
ini_set('display_errors', 'on');

//$regno = $_POST['regno'];
$mob = trim($_POST['mobile']);

$query = "SELECT * from masuser 
			where fmobileno = '{$mob}' and ifnull(factive,'') = 'T'";

$result = mysqli_query($conn,$query);
$count = mysqli_num_rows($result);
if($count >0)
{
	$row = mysqli_fetch_assoc($result);
	$email = $row['FEMAIL'];
	
	$otp = rand(100000, 900000);
	$smsotp = "Dear Student, Your mobile OTP for reseting password is $otp";
	$username = 'logisyhttp';
	$password = 'Logis986';
	$from = 'UNISOL';
	$to = $mob;
	$text = $smsotp;
	$category = '';

$smsresp = sendsmaapi($username,$password,$from,$to,$text,$category);

$message="<html>";
	$message.="<body>";
	$message.="<style>";		
	$message.=".mail_tbl td{text-align:left; padding:2px; font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif;}";	
	$message.="</style>";
	$message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'>Dear Student,</p></br>";
	$message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'>OTP for reseting your password is $otp<br/></p></br>";
			
	$message.="</br>";
	$message.="</body>";
	$message.="</html>";
	$subject="Student Portal : Forgot Password";

$resp = sendGridMail($email,$subject,$message);

$data = json_decode($resp, true);
	//$data = send_manual_mail($email,$subject,$message,$replay_to=null,$cc=null,'techsupport@logisys.net.in');

$query = "update masuser set fresetotp = '{$otp}', fresetotptime = now(),
	fresetotpcount = fresetotpcount+1 where fmobileno = '{$mob}'";
	$result = mysqli_query($conn,$query);

if($result == 1)
	{
		$strInsertQuery = "insert into smslog(funivcode, fregno,fmobileno, freasoncode, fguid, fenttype, fstatus,fackdate, facktime) values ('{$row['FUNIVCODE']}',
		'{$row['FUNIVCODE']}', '{$mob}', '0', '{$data['message']}', 'FP', 'T', DATE_FORMAT(NOW(),'%Y-%m-%d'), DATE_FORMAT(NOW(),'%T'))";
		
		$result1 = mysqli_query($conn,$strInsertQuery);
		
		$response['femail'] = $email;
		$response['status'] = 'success';
		$response['msg'] = 'OTP sent to your registered mobile: '.$mob.' and email :'.$email;
		echo json_encode($response);
	}
	else
	{
		$response['status'] = 'error';
		$response['msg'] = 'Something went wrong';
		echo json_encode($response);
	}

}
else
{
	$response['status'] = 'error';
	$response['msg'] = 'Try with registered mobile number';
	echo json_encode($response);
}

mysqli_close($conn);

${this.title}

Code Editor : forgot-password.php