<?php
session_start();
require 'connection.php';
$conn = new createConnection();
$conn->connectToDatabase();
$conn->selectDatabase();
$employerId = 2;
//This is the directory where images will be saved
$target = "images/logos/";
$target = $target . basename($_FILES['companyLogo']['name']);
$pic = $_FILES['companyLogo']['name'];
$sql = "UPDATE employer_agent_company SET FirstName = '{$_POST['fname']}', LastName = '{$_POST['lname']}', Address = '{$_POST['address']}', Company_Agent_Logo = '{$pic}', MobilePhone = '{$_POST['mobPhone']}', WorkPhone = '{$_POST['workPhone']}', EmailForApplication = '{$_POST['email']}', Company_Agent_URL = '{$_POST['companyUrl']}', EMPLOYER_TYPE_ID = '{$_POST['empType']}', AGENT_COMPANY_NAME = '{$_POST['agentComName']}' WHERE EMPLOYER_ID = {$employerId}";
var_dump($sql);
$res = $conn->queryDatabase($sql);
if ($res === TRUE) {
echo "Congratulation on successfully updated profile.";
} else {
echo "Could Not update your profile, please try again.";
}
//Writes the photo to the server
if (move_uploaded_file($_FILES['companyLogo']['tmp_name'], $target)) {
//Tells you if its all ok
echo "The file " . basename($_FILES['companyLogo']['name']) . " has been uploaded, and your information has been added to the directory";
} else {
//Gives and error if its not
echo "Sorry, there was a problem uploading your file.";
}
$conn->closeConnection();
<?php
if (!empty($_GET['message'])) {
$message = $_GET['message'];
echo $message;
}
?>
<table border="2px">
<tr><th>Job Title</th><th>Job Description</th><th>Work Type</th><th>Location</th><th>Category</th><th>Date of Advertisement</th><th>End date of advertisement</th><th>Experience Level</th><th>Edit Job Option</th></tr>
<?php
$conn = new createConnection();
$conn->connectToDatabase();
$conn->selectDatabase();
$employerId = 2;
$sql = "SELECT * from job where EMPLOYER_ID = {$employerId}";
var_dump($sql);
$res = $conn->queryDatabase($sql);
if ($res) {
$num_rows = mysqli_num_rows($res);
for ($i = 0; $i < $num_rows; $i++) {
$row = mysqli_fetch_array($res);
$jobId = $row['JobID'];
$jobTitle = $row['JobTitle'];
$jobDesc = $row['JobDescription'];
$workType = $row['WorkTypeID'];
$district = $row['DistrictID'];
$subCategory = $row['SubCategoryID'];
$dateAdStart = $row['DateOfAdvertisement'];
$dateAdEnd = $row['EndDateOfAdvertisement'];
$experience = $row['ExperienceLevel'];
$res1 = $conn->queryDatabase("SELECT WorkType from work_type where WorkTypeID = {$workType}");
$workRow = $res1->fetch_assoc();
</p></td></tr>
<tr><td><p><label for="companyUrl">Company/Agent URL:</label></td>
<td><input name="companyUrl" type="text" id="companyUrl" class="grayField" value="<?php
echo $companyUrl;
?>
" /></p></td></tr>
<tr><td><p><label for="empType"> <span id="astrick">*</span> Employer Type:</label></td>
<td><?php
$conn1 = new createConnection();
// created a new object
$conn1->connectToDatabase();
$conn1->selectDatabase();
$result = $conn1->queryDatabase("select EMPLOYER_TYPEID, EMPLOYER_TYPE_DESCRIPTION from employer_type");
printf("Select returned %d rows.\n", $result->num_rows);
?>
<select id="empType" name="empType" class="grayField" value="<?php
echo $employerType;
?>
" >
<option value="">Select employer type</option>
<?php
// echo "$result->EMPLOYER_TYPEID";
//echo "$result->EMPLOYER_TYPE_DESCRIPTION";
while ($row = $result->fetch_assoc()) {
unset($EMPLOYER_TYPEID, $EMPLOYER_TYPE_DESCRIPTION);
$id = $row['EMPLOYER_TYPEID'];
$desc = $row['EMPLOYER_TYPE_DESCRIPTION'];
echo '<option value="' . $id . '" name="' . $id . '">' . $desc . '</option>';
}
$conn1->closeConnection();
?>
</select>
<select id="district" name="district">
<option value="">Please select district</option>
</select></p></td></tr>
<tr><td><p><label for="category"> <span id="astrick">*</span> Which Category:</label></td>
<td><?php
$conn1 = new createConnection();
// created a new object
$conn1->connectToDatabase();
$conn1->selectDatabase();
$result = $conn1->queryDatabase("select CategoryID, CategoryName from job_category");
// printf("Select returned %d rows.\n", $result->num_rows);
?>
<select id="category" name="category" <?php
if (isset($missing)) {
echo 'value="' . htmlentities($_POST['category']) . '"';
}
?>
>
<option value="">Select Category</option>
<?php
while ($row = $result->fetch_assoc()) {
unset($CategoryID, $CategoryName);
$id = $row['CategoryID'];
$desc = $row['CategoryName'];
echo '<option value="' . $row['CategoryID'] . '" name="' . $row['CategoryID'] . '">' . $row['CategoryName'] . '</option>';
echo $seeker_email;
?>
">
<input type="submit" value="SEND" name="submit" />
</form>
<br /><br />
<?php
$conn = new createConnection();
$conn->connectToDatabase();
$conn->selectDatabase();
$sql = "SELECT SeekerID from seeker_appliedjobs where JobID = {$JodID}";
var_dump($sql);
$result = $conn->queryDatabase($sql);
$num = mysql_numrows($result);
$seeker_idx = 1;
if ($num) {
echo "<table>";
echo "<tr>";
echo "<th>Index</th>";
echo "<td>Name</td>";
echo "<td>Email</td>";
echo "<td>View Detail</td>";
echo "<td>View Resume</td>";
echo "<td>Conact</td>";
echo "</tr>";
while ($row = mysql_fetch_assoc($result)) {
$SeekerID = $row["SeekerID"];
$condition = "SeekerID = {$SeekerID} AND ( ";
