public function setThresholdPeriod($thresholdPeriod) { $this->thresholdPeriodYears = $thresholdPeriod; $s = new Sql(); global $databaseName; $connectValue = $s->connectToDatabase($databaseName); $row = $s->insertToConfig($connectValue, $thresholdPeriod); }
public function __construct($name) { $s = new Sql(); $connect = $s->connectToDatabase('recruit'); $jbID = $s->createJobPosition($connect, $name); $this->jpID = $jbID; $this->jobPositionName = $name; }
public function getStatus() { $s = new Sql(); $connect = $s->connectToDatabase('recruit'); $data = mysqli_query($connect, "SELECT sessionstatus.status FROM sessionstatus,recruitmentsession WHERE recruitmentsession.sessionStatusID=sessionstatus.sessionStatusID AND RSID='{$this->RSID}'"); $row = $data->fetch_row(); return $row[0]; }
public function __construct($name, $jb) { $s = new Sql(); $connectValue = $s->connectToDatabase($databaseName); $this->name = $name; $this->dateCreated = date("Y-m-d"); $this->jobPosition = $jb; $RSID = $s->setSessionQuery($connectValue, $name, $this->dateCreated, $jb); echo "RecruitmentSession works " . $RSID . ""; //$recSesID = $RSID; // Set session variables //$_SESSION["rSessionID"] = $RSID; }
}, function(data) { //alert(interviewname); } ); }); }); </script> <?php require_once "Sql.php"; require_once "GlobalVariables.php"; $s = new Sql(); $connect = $s->connectToDatabase($databaseName); global $db, $user, $pass; try { $dbh = new PDO($db, $user, $pass); $loadStatus = $dbh->prepare("SELECT sessionStatusID,status FROM sessionStatus"); if ($loadStatus->execute()) { $loadStatus->setFetchMode(PDO::FETCH_ASSOC); } } catch (Exception $error) { echo '<p>', $error->getMessage(), '</p>'; } ?> </head> <body>
txt += "<br>The path of the selected file: " + x.value; // If the browser does not support the files property, it will return the path of the selected file instead. } } } </script> <?php if (isset($_GET["id"])) { $sessionID = $_GET["id"]; } if (isset($_FILES['fileToUpload'])) { $file = $_FILES['fileToUpload']; $fileCount = count($file["name"]); //Used only for viewing purposes $text = ""; $s = new Sql(); $connectValue = $s->connectToDatabase($databaseName); for ($i = 0; $i < $fileCount; $i++) { $cv = $s->createNewCV($connectValue, $i); $candidate = null; //$sessionID = $_SESSION['rSessionID']; //if (isset($_COOKIE['rSessionID'])){ //$sessionID = $_COOKIE['rSessionID']; //} //echo $_GET["id"]; //$sessionID = $_GET["id"]; // $sessionID="RS055"; echo "<ul id=\"feedBack\" class=\"list-group\">"; if ($cv != null) { $candidate = $s->createNewCandidate($connectValue, $cv, $sessionID); echo "<li class=\"list-group-item list-group-item-success\">" . $file["name"][$i] . " upload is successful</li>"; } else {
function __construct() { $s = new Sql(); $this->connectValue = $s->connectToDatabase('recruit'); }