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

<?php
ob_start();
require __DIR__ . DIRECTORY_SEPARATOR . "lib" . DIRECTORY_SEPARATOR . "config.php";
// HTML
require PATH_LIB . "page-top.php";
$tokenAuth = $row[ 'authtokenid' ];
require_once 'common.php';
$vaccancy = new CAIWEB();
if ( isset( $_POST[ 'btn-submit' ] ) ) {
  $jobTitle = trim( $_POST[ 'jobTitle' ] );
  $address = trim( $_POST[ 'address' ] );
  $salary = trim( $_POST[ 'salary' ] );
	 $jobStatus = trim( $_POST[ 'jobStatus' ] );
	 $jobType = trim( $_POST[ 'jobType' ] );
	$redirectionLink = trim( $_POST[ 'redirectionLink' ] );
	$status=2;
  if ( empty( $jobTitle ) ) {
    $errMSG = "Please enter job Title.";
  } else if ( empty( $address ) ) {
    $errMSG = "Please enter job Address";
  } else if ( empty( $salary ) ) {
    $errMSG = "Please enter Salary details";
  }
  if ( !isset( $errMSG ) ) {
	  $stmt = $vaccancy->runQuery("SELECT * FROM vacancy WHERE jobTitle=:jobTitle1 and jobType='$jobType'");
		$stmt->execute(array(":jobTitle1"=>$jobTitle));
		$rows = $stmt->fetch(PDO::FETCH_ASSOC);
	if($stmt->rowCount() > 0)
	{
		$errMSG = "You have already submitted.";    
	}
	else
	{
    if ( $vaccancy->vaccancyD( $jobTitle, $address, $salary,$jobStatus,$jobType,$redirectionLink,$status ) ) {
      $successMSG = "Vacancy details have been submitted successfuly..";

} else {
      $errMSG = "sorry , Query could not execute...";
    }
  }
  }
}
?>
<div id="layoutSidenav_content">
<main>
  <div class="container-fluid px-4 ">
    <h2 class="mt-4 mb-4">Vacancy</h2>
    <div class="row">
      <div class="col-xl-12">
        <div class="card mb-4">
          <div class="card-header"> Vacancy details Form </div>
          <div class="card-body">
            <form id="tutionFee" name="tutionFee" action="vaccancy.php?authToken=<?php echo $tokenAuth;?>" method="post">
              <div class="row">
                <div class="box-body">
                  <?php
                  if ( isset( $errMSG ) ) {
                    ?>
					<div class="alert alert-warning alert-dismissible fade show" role="alert">
  					<?php echo $errMSG; ?>
  					<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
					</div>
                  <?php
                  } else if ( isset( $successMSG ) ) {
                    ?>
					<div class="alert alert-success alert-dismissible fade show" role="alert">
  					<?php echo $successMSG; ?>
  					<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
					</div>
                  <?php
                  }

?>
                </div>
                <div class="mb-3 col-md-4">
                  <label for="exampleFormControlInput1" class="form-label">Job Title</label>
                  <input type="text" name="jobTitle" required  class="form-control">
                </div>
               <div class="mb-3 col-md-4">
                  <label for="address" class="form-label">Address</label>
                  <input type="text" name="address" required  class="form-control">
                </div>
				  <div class="mb-3 col-md-4">
                  <label for="salary" class="form-label">Salary</label>
                  <input type="text" name="salary" required  class="form-control">
                </div>
				    <div class="mb-3 col-md-4">
                <label for="exampleFormControlTextarea1" class="form-label">Select Job Status</label>
                <select class="form-select" name="jobStatus" aria-label="Default select example">
                    <option selected disabled value="">Select Job Status</option>
                    <option value="New">New</option>
                    <option value="Old">Old</option>
                  </select>
              </div>
				<div class="mb-3 col-md-4">
                <label for="exampleFormControlTextarea1" class="form-label">Select Job Type</label>
                <select class="form-select" name="jobType" aria-label="Default select example">
                    <option selected disabled value="">Select Job Type</option>
                    <option value="Open">Open</option>
                    <option value="Closed">Closed</option>
                  </select>
              </div>
				  <div class="mb-3 col-md-4">
                <label for="exampleFormControlTextarea1" class="form-label">Redirection Link</label>
                <input type="text" name="redirectionLink" required  class="form-control">
              </div>
              </div>
            
              <div class="mb-3">
                <input type="submit" class="btn btn-primary btn-sm" value="Submit" name="btn-submit">
              </div>
            </form>
          </div>
        </div>
      </div>
		<div class="card mb-4">
                            <div class="card-header">
                                <i class="fas fa-table me-1"></i>
                                Vacancy Details
                            </div>
                            <div class="card-body">
                                <table id="datatablesSimple">
                                    <thead>
                                        <tr>
                                            <th>Job Title</th>
                                            <th>Salary</th>
                                            <th>Job Status</th>
                                            <th>Job Type</th>
                                            <th>Post Date</th>
											<th>Status</th>
											<th>Action</th>
                                        </tr>
                                    </thead>
                                    <tfoot>
                                        <tr>
                                            <th>Job Title</th>
                                            <th>Salary</th>
                                            <th>Job Status</th>
                                            <th>Job Type</th>
                                            <th>Post Date</th>
											<th>Status</th>
											<th>Action</th>
                                        </tr>
                                    </tfoot>
                                    <tbody>
										<?php $result = $DB_con->prepare("SELECT * FROM vacancy order by makerstamp desc ");
												$result->execute();
												for($i=0; $row = $result->fetch(); $i++){ ?>
                                        <tr>
                                            <td><?php echo $row ['jobTitle']; ?></td>
                                            <td><?php echo $row ['salary']; ?></td>
                                            <td><?php echo $row ['jobStatus']; ?></td>
                                            <td><?php echo $row ['jobType']; ?></td>
                                            <td><?php echo $row ['makerstamp']; ?></td>
											<td><?php 
											$vID = $row ['vID'];											 
											$status = $row ['status']; 
											if($status =='2'){ ?>
												Active
												<?php } else { ?>
												Disable
												<?php } ?>
											</td>
											<td><a href="vacanciesEdit.php?vID=<?php echo $vID; ?>&authToken=<?php echo $tokenAuth;?>">Edit</a></td>
                                        </tr>
                                       <?php  } ?>
                                    </tbody>
                                </table>
                            </div>
                        </div>
    </div>
  </div>
</main>
<script type="text/javascript">
        window.onload = function () {
            //Reference the DropDownList.
            var ddlYears = document.getElementById("ddlYears");
            //Determine the Current Year.
            var currentYear = (new Date()).getFullYear();
            //Loop and add the Year values to DropDownList.
            for (var i = 2021; i <= 2030; i++) {
                var option = document.createElement("OPTION");
                option.innerHTML = i;
                option.value = i;
                ddlYears.appendChild(option);
            }
        };
    </script>
<?php ob_end_flush(); require PATH_LIB . "page-bottom.php"; ?>

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.