Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
CUSTOM_CHECKOUT_FORM_KIT	[ DIR ]	drwxr-xr-x
IFRAME_KIT	[ DIR ]	drwxr-xr-x
NON_SEAMLESS_KIT	[ DIR ]	drwxr-xr-x
Screens	[ DIR ]	drwxr-xr-x
Crypto.php	1.99 KB	-rwxr-xr-x
ccavRequestHandler.php	3.48 KB	-rwxr-xr-x
ccavRequestHandler.php~	978 B	-rwxr-xr-x
ccavResponseHandler.php	5.89 KB	-rwxr-xr-x
ccavResponseHandler.php~	1.41 KB	-rwxr-xr-x
dataFrom.htm	19.25 KB	-rwxr-xr-x
dataFrom.htm~	19.01 KB	-rwxr-xr-x
forgotpassword.php	2.55 KB	-rwxr-xr-x
from.html	644 B	-rwxr-xr-x
jquery-1.7.2.min.js	92.62 KB	-rwxr-xr-x
json.js	3.27 KB	-rwxr-xr-x
sendmobotp.php	2.53 KB	-rwxr-xr-x

Code Editor : forgotpassword.php

<?php
require_once("cManualMailer.php");
require_once("cconfig.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 college 
			where fmobilec = '{$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['femailc'];

$otp = rand(100000, 900000);
	$smsotp = "Dear Sir/Ma'am, 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 Sir/Ma'am,</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="College 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 college set fresetotp = '{$otp}', fresetotptime = now(),
	fresetotpcount = fresetotpcount+1 where fmobilec = '{$mob}'";
	$result = mysqli_query($conn,$query);

if($result == 1)
	{
		$strInsertQuery = "insert into s_sysdb(funivcode,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 : forgotpassword.php