/ 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 : common.php

<?php

require_once 'dbconfig.php';

class CAIWEB
{

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 publicB($ddlYears,$typeC,$areaType,$contentmsg,$status)
	{
		try
		{							
			$stmt = $this->conn->prepare("INSERT INTO publicationstbl(ddlYears,typeC,areaType,contentmsg,status) 
			       VALUES(:ddlYears1,:typeC1,:areaType1,:contentmsg1,:status1)");
			$stmt->bindparam(":ddlYears1",$ddlYears);
			$stmt->bindparam(":typeC1",$typeC);
			$stmt->bindparam(":areaType1",$areaType);
			$stmt->bindparam(":contentmsg1",$contentmsg);
			$stmt->bindparam(":status1",$status);
			$stmt->execute();	
			return $stmt;		
		}
		catch(PDOException $ex)
		{
			echo $ex->getMessage();
		}
	}
	public function vaccancyD( $jobTitle, $address, $salary,$jobStatus,$jobType,$redirectionLink,$status )
	{
		try
		{							
			
			$stmt = $this->conn->prepare("INSERT INTO vacancy(jobTitle,address,salary,jobStatus,jobType,redirectionLink,status) 
			       VALUES(:jobTitle1,:address1,:salary1,:jobStatus1,:jobType1,:redirectionLink1,:status1)");
			$stmt->bindparam(":jobTitle1",$jobTitle);
			$stmt->bindparam(":address1",$address);
			$stmt->bindparam(":salary1",$salary);
			$stmt->bindparam(":jobStatus1",$jobStatus);
			$stmt->bindparam(":jobType1",$jobType);
			$stmt->bindparam(":redirectionLink1",$redirectionLink);
			$stmt->bindparam(":status1",$status);
			$stmt->execute();	
			return $stmt;		
		}
		catch(PDOException $ex)
		{
			echo $ex->getMessage();
		}
	}
	public function projectD( $projectTitle, $startDate,$endDate, $description,$fundingAgency,$piDetails,$pImg,$status,$projectStatus ) 
	{
		try
		{							
			
			$stmt = $this->conn->prepare("INSERT INTO projectdetails(projectTitle,startDate,endDate,description,fundingAgency,piDetails,pImg,status,projectStatus) 
			       VALUES(:projectTitle1,:startDate1,:endDate1,:description1,:fundingAgency1,:piDetails1,:pImg1,:status1,:projectStatus1)");
			$stmt->bindparam(":projectTitle1",$projectTitle);
			$stmt->bindparam(":startDate1",$startDate);
			$stmt->bindparam(":endDate1",$endDate);
			$stmt->bindparam(":description1",$description);
			$stmt->bindparam(":fundingAgency1",$fundingAgency);
			$stmt->bindparam(":piDetails1",$piDetails);
			$stmt->bindparam(":pImg1",$pImg);
			$stmt->bindparam(":status1",$status);
			$stmt->bindparam(":projectStatus1",$projectStatus);
			$stmt->execute();	
			return $stmt;		
		}
		catch(PDOException $ex)
		{
			echo $ex->getMessage();
		}
	}
	public function vaccancyUP( $vID, $jobTitle, $address, $salary,$jobStatus,$jobType,$redirectionLink,$status) {
    try {
      $stmt = $this->conn->prepare( "UPDATE vacancy SET jobTitle=:jobTitle,address=:address,salary=:salary,jobStatus=:jobStatus,jobType=:jobType,redirectionLink=:redirectionLink,status=:status WHERE vID=:vID" );
      $stmt->bindparam( ":vID", $vID );
      $stmt->bindparam( ":jobTitle", $jobTitle );
      $stmt->bindparam( ":address", $address );
	  $stmt->bindparam( ":salary", $salary );
	  $stmt->bindparam( ":jobStatus", $jobStatus );
	  $stmt->bindparam( ":jobType", $jobType );
	  $stmt->bindparam( ":redirectionLink", $redirectionLink );
	  $stmt->bindparam( ":status", $status );
      $stmt->execute();
      return $stmt;

} catch ( PDOException $ex ) {
      echo $ex->getMessage();
    }
  }
		public function publicBUP( $id, $ddlYears, $typeC,$areaType, $contentmsg,$status ) {
    try {
      $stmt = $this->conn->prepare( "UPDATE publicationstbl SET ddlYears=:ddlYears, typeC=:typeC, areaType=:areaType, contentmsg=:contentmsg, status=:status WHERE id=:id" );
      $stmt->bindparam( ":id", $id );
      $stmt->bindparam( ":ddlYears", $ddlYears );
      $stmt->bindparam( ":typeC", $typeC );
		$stmt->bindparam( ":areaType", $areaType );
	  $stmt->bindparam( ":contentmsg", $contentmsg );
	  $stmt->bindparam( ":status", $status );
      $stmt->execute();
      return $stmt;
    } catch ( PDOException $ex ) {
      echo $ex->getMessage();
    }
  }
	public function projectUPD($pID, $projectTitle, $startDate,$endDate, $description,$fundingAgency,$piDetails,$status,$projectStatus ) {
    try {
      $stmt = $this->conn->prepare( "UPDATE projectdetails SET projectTitle=:projectTitle, startDate=:startDate, endDate=:endDate,description=:description,fundingAgency=:fundingAgency,piDetails=:piDetails, status=:status,projectStatus=:projectStatus WHERE pID=:pID" );
      $stmt->bindparam( ":pID", $pID );
      $stmt->bindparam( ":projectTitle", $projectTitle );
      $stmt->bindparam( ":startDate", $startDate );
	  $stmt->bindparam( ":endDate", $endDate );
	  $stmt->bindparam( ":description", $description );
	  $stmt->bindparam( ":fundingAgency", $fundingAgency );
	  $stmt->bindparam( ":piDetails", $piDetails );
	  $stmt->bindparam( ":status", $status );
	  $stmt->bindparam( ":projectStatus", $projectStatus );
      $stmt->execute();
      return $stmt;
    } catch ( PDOException $ex ) {
      echo $ex->getMessage();
    }   
  } 
	public function updateImg($pID, $pImg) {
    try {
      $stmt = $this->conn->prepare( "UPDATE projectdetails SET pImg=:pImg WHERE pID=:pID" );
      $stmt->bindparam( ":pID", $pID );
      $stmt->bindparam( ":pImg", $pImg );
      $stmt->execute();
      return $stmt;

} catch ( PDOException $ex ) {
      echo $ex->getMessage();
    }
  }
}

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.