/ var / www / html / intranetpage / iiitdinternaldocs / [ HOME SHELL ]

Name	Size	Permission	Action
css	[ DIR ]	drwxr-x--x
dist	[ DIR ]	drwxr-x--x
documents	[ DIR ]	drwxr-x--x
images	[ DIR ]	drwxr-x--x
js	[ DIR ]	drwxr-x--x
lib	[ DIR ]	drwxr-x--x
plugins	[ DIR ]	drwxr-x--x
DBController.php	739 B	-rwxr-x--x
categorylist.php	2.25 KB	-rwxr-x--x
common.php	2.94 KB	-rwxr-x--x
createCategory.php	3.45 KB	-rwxr-x--x
createOfficeorder.php	9.13 KB	-rwxr-x--x
dashboard.php	3.01 KB	-rwxr-x--x
dbconfig.php	1.25 KB	-rwxr-x--x
get_subcatg.php	500 B	-rwxr-x--x
index.php	3.54 KB	-rwxr-x--x
indexDashboard.php	9.81 KB	-rwxr-x--x
list.php	9.5 KB	-rwxr-x--x
list.php_07032021	10.86 KB	-rwxr-x--x
logout.php	377 B	-rwxr-x--x

Code Editor : common.php

<?php

require_once 'dbconfig.php';

class IIITDELHI
{

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 categoryup($categoryName)
	{
		try
		{							
			$stmt = $this->conn->prepare("INSERT INTO category(categoryName) 
			       VALUES(:categoryName1)");
			$stmt->bindparam(":categoryName1",$categoryName);
			$stmt->execute();	
			return $stmt;
			
		}
		catch(PDOException $ex)
		{
			echo $ex->getMessage();
		}
	}
	
	public function categorysub($categoryselected,$subCategoryName)
	{
		try
		{							
			$stmt = $this->conn->prepare("INSERT INTO subcategory(categoryID,subCategoryName) 
			       VALUES(:categoryselected1,:subCategoryName1)");
			$stmt->bindparam(":categoryselected1",$categoryselected);
			$stmt->bindparam(":subCategoryName1",$subCategoryName);
			$stmt->execute();	
			return $stmt;
			
		}
		catch(PDOException $ex)
		{
			echo $ex->getMessage();
		}
	}
	public function officeOrderup($subject,$category,$subCatg,$releaseDate,$fileUpload)
	{
		try
		{							
			$stmt = $this->conn->prepare("INSERT INTO officeorder(subject,category,subCatg,releaseDate,fileUpload) 
			       VALUES(:subject1,:category1,:subCatg1,:releaseDate1,:fileUpload1)");
			$stmt->bindparam(":subject1",$subject);
			$stmt->bindparam(":category1",$category);
			$stmt->bindparam(":subCatg1",$subCatg);
			$stmt->bindparam(":releaseDate1",$releaseDate);
			$stmt->bindparam(":fileUpload1",$fileUpload);
			$stmt->execute();	
			return $stmt;
			
		}
		catch(PDOException $ex)
		{
			echo $ex->getMessage();
		}
	}
	
	public function login( $userEmail, $upass ) {
		try {
			$stmt1 = $this->conn->prepare( "SELECT * FROM adminloginoffice WHERE userEmail=:email_id" );
			$stmt1->execute( array( ":email_id" => $userEmail ) );
			$userRow = $stmt1->fetch( PDO::FETCH_ASSOC );		
			if ( $stmt1->rowCount() == 1 ) {
				
				if ( $userRow[ 'userStatus' ] == "Y" ) {
					if ( $userRow[ 'userPassword' ] == hash( 'sha256', $upass ) ) {
							
					$_SESSION[ 'userSession' ] = $userRow[ 'userEmail' ];
						return true;
					} else {
						header( "Location: index.php?notAvail" );
						exit;
					}
					
				} else {
					header( "Location: index.php?notAvail" );
					exit;
				}
			} else {
				header( "Location: index.php?error" );
				exit;
			}
		} catch ( PDOException $ex ) {
			echo $ex->getMessage();
		}
	}
	
	public	function is_logged_in() {
		if ( isset( $_SESSION[ 'userSession' ] ) ) {
			return true;
		}
	}

public	function redirect( $url ) {
		header( "Location: $url" );
	}

public	function logout() {
		session_destroy();
		$_SESSION[ 'userSession' ] = false;
	}
}

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.