Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
assets	[ DIR ]	drwxr-xr-x
css	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
img	[ DIR ]	drwxr-xr-x
js	[ DIR ]	drwxr-xr-x
libs	[ DIR ]	drwxr-xr-x
plugins	[ DIR ]	drwxr-xr-x
src	[ DIR ]	drwxr-xr-x
tcpdf	[ DIR ]	drwxr-xr-x
upload	[ DIR ]	drwxrwxrwx
MainPage.html	36.29 KB	-rwxr-xr-x
MainPage_dev.html	36.76 KB	-rwxr-xr-x
admission_sms_push.php	2.3 KB	-rwxr-xr-x
app.php	416 B	-rwxr-xr-x
cconfig.php	1.45 KB	-rwxr-xr-x
cronjob_sendsms.php	2.5 KB	-rwxr-xr-x
database.php	396 B	-rwxr-xr-x
direct-signin.php	886 B	-rw-rw-r--
forgot-password.php	2.19 KB	-rwxr-xr-x
forgotPassword.html	4.84 KB	-rwxr-xr-x
index.html	5.01 KB	-rwxr-xr-x
index_1.html	130 B	-rwxr-xr-x
instruction.html	9.53 KB	-rwxr-xr-x
instruction_10092018.html	8.37 KB	-rwxr-xr-x
instruction_24092018.html	9.08 KB	-rwxr-xr-x
instruction_regn.html	4.45 KB	-rwxr-xr-x
login.php	294 B	-rwxr-xr-x
resetpassword.php	697 B	-rwxr-xr-x
sendGridMail.php	1.28 KB	-rwxr-xr-x
sendMobEmailOTP.php	1.4 KB	-rwxr-xr-x
sendsmsapi.php	760 B	-rwxr-xr-x
sign-up.html	7.29 KB	-rwxr-xr-x
signin.php	973 B	-rwxr-xr-x
signup.php	1.22 KB	-rwxr-xr-x
support.html	4.76 KB	-rwxr-xr-x
upload.php	415 B	-rwxr-xr-x
upload1.php	423 B	-rwxr-xr-x
upload_file.php	523 B	-rwxr-xr-x
validateRegno.php	2.35 KB	-rwxr-xr-x

Code Editor : validateRegno.php

<?php
include ("database.php");
include("sendsmsapi.php");
error_reporting(E_ALL);
ini_set('display_errors', 'on');
$mobile = trim($_POST['mobile']);

$query = "SELECT fname, ifnull(femail,'') as femail
from collstud where fmobileno = '{$mobile}' and factive = 'T'";

$result = mysqli_query($conn,$query);
$count = mysqli_num_rows($result);

if($count == 0)
{
	$query = "SELECT fname, ifnull(femail,'') as femail, fdegree, fcollcode
	from collstud where fmobileno = '{$mobile}'";

$result = mysqli_query($conn,$query);
	$count = mysqli_num_rows($result);
	if($count > 0)
	{	
		$studdetl = mysqli_fetch_assoc($result);
		
		$degquery = "select * from degree where fdegree = '{$studdetl['fdegree']}'";
		$result = mysqli_query($conn,$degquery);
		$count = mysqli_num_rows($result);
		
		if($count == 0)
		{
			$row["status"] = 'invalid';
			$row["msg"] = "Error in degree define ({$studdetl['fdegree']}), Contact Help Desk.";
			echo json_encode($row);
			die();
		}

$degquery = "select * from college where fcollcode = '{$studdetl['fcollcode']}'";
		$result = mysqli_query($conn,$degquery);
		$count = mysqli_num_rows($result);
		
		if($count == 0)
		{
			$row["status"] = 'invalid';
			$row["msg"] = "College information not exist ({$studdetl['fcollcode']}), Contact Help Desk.";
			echo json_encode($row);
			die();
		}

$row['result'] = $studdetl;

$row['status'] = 'success';
		date_default_timezone_set('Asia/Kolkata');
		$time =  date("h:i A");
		$motpaswrd = rand(1000, 9000); //strtoupper(substr(sha1(rand()), 0, 4));
		$smsotp = "Dear Student, Your mobile OTP for Registration is {$motpaswrd} sent at {$time}";

$username = 'logisyhttp';
		$password = 'Logis986';
		$from = 'UNISOL';
		$to = $mobile;
		$text = $smsotp;
		$category = '';

$smsresp = sendsmaapi($username,$password,$from,$to,$text,$category);
		//var_dump($smsresp);
		$row["sms"] = $smsresp;
		//var_dump($row);
		$query = "update collstud set fmobileotp = '{$motpaswrd}', fmobotptime = now(),
				fotpcounter = fotpcounter+1 
				where fmobileno = '{$mobile}'";
		$result = mysqli_query($conn,$query);
		
		echo json_encode($row);
	}
	else
	{
		$row["status"] = 'invalid';
		$row["msg"] = "This Mobile No. is not submitted by college to university. Contact college";
		echo json_encode($row);
	}
}
else
{
	$row["status"] = 'invalid';
	$row["msg"] = 'You have already registered, Please Login';
	echo json_encode($row);
}
?>

${this.title}

Code Editor : validateRegno.php