/ var / www / html / cai / caiold1 / admin / [ HOME SHELL ]

Name	Size	Permission	Action
assets	[ DIR ]	drwxr-x--x
css	[ DIR ]	drwxr-x--x
js	[ DIR ]	drwxr-x--x
lib	[ DIR ]	drwxr-x--x
uploadDoc	[ DIR ]	drwxr-x--x
changePassword.php	3.99 KB	-rwxr-x--x
class.admin.php	4.39 KB	-rwxr-x--x
common.php	5.6 KB	-rwxr-x--x
common_old07032022.php	5.4 KB	-rwxr-x--x
dashboard.php	8.35 KB	-rwxr-x--x
dashboard_old07032022.php	7.37 KB	-rwxr-x--x
dbconfig.php	1.22 KB	-rwxr-x--x
editImage.php	2.18 KB	-rwxr-x--x
fpass.php	3.07 KB	-rwxr-x--x
index.php	4 KB	-rwxr-x--x
logout.php	624 B	-rwxr-x--x
password.php	3.51 KB	-rwxr-x--x
projectDetails.php	9.7 KB	-rwxr-x--x
projectDetailsEdit.php	9.02 KB	-rwxr-x--x
projectDetailsEdit_old07032022...	8.63 KB	-rwxr-x--x
projectDetails_old07032022.php	9.16 KB	-rwxr-x--x
publicationEdit.php	9.6 KB	-rwxr-x--x
publicationEdit_old07032022.ph...	8.62 KB	-rwxr-x--x
register.php	5.57 KB	-rwxr-x--x
resetpass.php	5.26 KB	-rwxr-x--x
vacanciesEdit.php	9.19 KB	-rwxr-x--x
vaccancy.php	8.17 KB	-rwxr-x--x
verifyLink.php	10.13 KB	-rwxr-x--x

Code Editor : class.admin.php

<?php

require_once 'dbconfig.php';

class ADMIN
{

private $conn;
	
	public function __construct()
	{
		$database = new Database();
		$db = $database->dbConnection();
		$this->conn = $db;
    }
	
	public function runQuery($sql)
	{
		$stmt = $this->conn->prepare($sql);
		return $stmt;
	}
	
	public function lasdID()
	{
		$stmt = $this->conn->lastInsertId();
		return $stmt;
	}
	
	public function register($adName,$adEmail,$adMobile,$password,$tokenCode)
	{
		try
		{							
		$upassword =hash('sha256',$password);
			$stmt = $this->conn->prepare("INSERT INTO adminlogin(adName,adEmail,adMobile,adPassword,tokenCode) 
			                                             VALUES(:adName1, :adEmail1, :adMobile1,:upassword1, :tokenCode1)");
			$stmt->bindparam(":adName1",$adName);
			$stmt->bindparam(":adEmail1",$adEmail);
			$stmt->bindparam(":adMobile1",$adMobile);
			$stmt->bindparam(":upassword1",$upassword);
			$stmt->bindparam(":tokenCode1",$tokenCode);
			$stmt->execute();	
			return $stmt;
		}
		catch(PDOException $ex)
		{
			echo $ex->getMessage();
		}
	}
	
	
	
	public function adminLogin($email,$upass,$authtokenid)
	{
		try
		{
			$stmt = $this->conn->prepare("SELECT * FROM adminlogin WHERE adEmail=:email_id");
			$stmt->execute(array(":email_id"=>$email));
			$userRow=$stmt->fetch(PDO::FETCH_ASSOC);
			$adID = $userRow[ 'adID' ];
			if($stmt->rowCount() == 1)
			{
				if($userRow['userStatus']=="Y")
				{
					if($userRow['adPassword']==hash('sha256',$upass))
					{
						$stmt3 = $this->conn->prepare( "SELECT * FROM authsession WHERE studentID=:adID" );
						$stmt3->execute( array( ":adID" => $adID ) );
						$userRow3 = $stmt3->fetch( PDO::FETCH_ASSOC );
						$loginFlg = "Y";
						if ( $userRow3[ 'studentID' ] == "" && $userRow3[ 'authtokenid' ] == "" ) {

$stmt4 = $this->conn->prepare( 'INSERT INTO authsession (studentID,authtokenid,loginFlg) VALUES(:adID1, :authtokenid1, :loginFlg1)' );
							$stmt4->bindParam( ':adID1', $adID );
							$stmt4->bindParam( ':authtokenid1', $authtokenid );
							$stmt4->bindParam( ':loginFlg1', $loginFlg );
							if ( $stmt4->execute() ) {
						        $_SESSION['adminSession'] = $userRow['adID'];
								$_SESSION[ 'adID' ] = $userRow3[ 'studentID' ];
						        return true;
								} else {
								//$_SESSION['errMSG']=
								$errMSG = "error while inserting....";

}
					}
						else {

$sql = "UPDATE authsession SET authtokenid=:authtokenid, loginFlg=:loginFlg WHERE studentID=:adID";
							$query = $this->conn->prepare( $sql );
							$query->bindparam( ':adID', $adID );
							$query->bindparam( ':authtokenid', $authtokenid );
							$query->bindparam( ':loginFlg', $loginFlg );
							if ( $query->execute() )

{

$_SESSION['adminSession'] = $userRow['adID'];
								$_SESSION[ 'adID' ] = $userRow3[ 'studentID' ];
								return true;
							} else {
								//$_SESSION['errMSG']=
								$errMSG = "error while inserting....";

}

}
					}

else
					{
						header("Location: index.php?error");
						exit;
					}
				}
				else
				{
					header("Location: index.php?inactive");
					exit;
				}	
			}
			else
			{
				header("Location: index.php?error");
				exit;
			}		
		}
		catch(PDOException $ex)
		{
			echo $ex->getMessage();
		}
	}
	
	
	public function is_adlogged_in()
	{
		if(isset($_SESSION['adminSession']))
		{
			return true;
		}
	}
	
	public function redirect($url)
	{
		header("Location: $url");
	}
	
	public function adminLogout()
	{
		session_destroy();
		$_SESSION['adminSession'] = false;
		$_SESSION[ 'adID' ] = false;
	}
	
	function send_mail($email,$message,$subject)
	{						
		require_once('mailer/class.phpmailer.php');
		$mail = new PHPMailer();
		$mail->IsSMTP(); 
		$mail->SMTPDebug  = 0;                     
		$mail->SMTPAuth   = true;                  
		$mail->SMTPSecure = "ssl";                 
		$mail->Host       = "smtp.gmail.com";      
		$mail->Port       = 465;             
		$mail->AddAddress($email);
		$mail->Username="your_gmail_id_here@gmail.com";  
		$mail->Password="your_gmail_password_here";            
		$mail->SetFrom('your_gmail_id_here@gmail.com','Coding Cage');
		$mail->AddReplyTo("your_gmail_id_here@gmail.com","Coding Cage");
		$mail->Subject    = $subject;
		$mail->MsgHTML($message);
		$mail->Send();
	}	
}

Urban Research Lab

Urban Research Lab

The Urban Research Lab (URL) at IIIT-Delhi was established in 2020, during a time when the pandemic brought the complexities of urban life more visible than ever. What started as an initiative by faculty and students has grown into a collaborative space for critically exploring and reimagining the urban questions through research, dialogue, and interdisciplinary engagement.