Process
unknown
php
a month ago
7.4 kB
1
Indexable
Never
<style>
:root {
--backgroud_light_color: #e6dcce;
--main_dark_color: #474143;
--main_shadow_color: #6B798C;
--seccond_light_color: #384D68;
--font_heading: 'IBM Plex Mono', monospace;
--font_content: 'IBM Plex Mono', monospace;
--font_higlight: 'Qwitcher Grypen', cursive;
}
.outer-wrapper {
border: .15rem solid var(--main_dark_color);
}
.table-wrapper {
margin: 2rem;
overflow-y: auto;
overflow-x: auto;
height: max-content;
border: .15rem solid var(--main_dark_color);
}
#m_table {
border: .15rem solid var(--main_dark_color);
min-width: 80vw;
border-spacing: 0px;
border-collapse: collapse;
text-align: center;
font-family: var(--font_content);
}
#m_table tr th,
#m_table tr td {
border: .15rem solid var(--main_dark_color);
padding: 15px;
}
#m_table tr th {
position: sticky;
top: 0px;
background-color: var(--main_shadow_color);
color: var(--backgroud_light_color);
font-size: 1.15rem;
}
#m_table tr td {
padding: .25rem;
border: .15rem solid var(--main_dark_color);
font-size: .85rem;
}
#m_table tr td .btn {
background-color: var(--main_shadow_color);
}
.mycss1 {
margin-top: 10rem;
text-align: center;
font-family: var(--font_content);
font-size: 25px;
color: #474143;
}
.mycss2 {
font-family: var(--font_content);
font-size: 25px;
color: #FF0000;
}
.goback-button {
background-color: #474143;
color: #eedfc7;
border: 3px solid #eedfc7;
margin: 4px 2px;
padding: 12px 24px;
border-radius: 8px;
text-align: center;
display: inline-block;
font-family: var(--font_content);
font-size: 15px;
cursor: pointer;
}
.goback-button:hover {
background-color: #7c7a7a;
text-shadow: #7c5802;
transform: scale(1.05);
}
* {
margin: 0;
padding: 0;
background-color: #e6dcce;
}
</style>
<?php
include('settings.php');
//Insert name//
$Firstname = $_POST['Firstname'];
$Lastname = $_POST['Lastname'];
$Dob = $_POST['Dob'];
$Gender = $_POST['Gender'];
$Email = $_POST['Email'];
$Phone = $_POST['Phone'];
$Address = $_POST['Address'];
$Suburb = $_POST['Suburb'];
$State = $_POST['State'];
$Postcode = $_POST['Postcode'];
$Job_prefer = $_POST['Job_prefer'];
$Job_reference_number = $_POST['Job_reference_number'];
$Programming_language = $_POST['Programming_Language'];
$Skills = $_POST['Skills'];
$Status = "Pending";
//
//
// Convert arrays to strings//
if (is_array($_POST['Programming_Language']) && !empty($_POST['Programming_Language'])) {
$Programming_language = implode(",", $_POST['Programming_Language']);
} else {
$Programming_language = "";
}
if (is_array($_POST['Skills']) && !empty($_POST['Skills'])) {
$Skills = implode(",", $_POST['Skills']);
} else {
$Skills = "";
}
//connection//
$con = mysqli_connect($host, $user, $pwd, $sql_db);
if (isset($_REQUEST['submit'])) {
$Programming_language = implode(", ", $_REQUEST['Programming_Language']);
$insert_query = mysqli_query($con, "insert into ApplyForm_Assignment2 set Programming_Language=$Programming_language");
}
if (mysqli_connect_errno()) {
echo "$con->connect_error";
die("Connection Failed : " . mysqli_connect_error());
}
$sql = "INSERT INTO ApplyForm_Assignment2(Firstname, Lastname, Dob, Gender, Email, Phone, Address, Suburb, State, Postcode, Job_prefer, Job_reference_number, Programming_Language, Skills, Status) values(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?)";
$result = mysqli_query($con, $sql);
$stmt = mysqli_stmt_init($con);
if (!mysqli_stmt_prepare($stmt, $sql)) {
die(mysqli_error($con));
}
mysqli_stmt_bind_param($stmt, "sssssssssssssss", $Firstname, $Lastname, $Dob, $Gender, $Email, $Phone, $Address, $Suburb, $State, $Postcode, $Job_prefer, $Job_reference_number, $Programming_language, $Skills, $Status);
mysqli_stmt_execute($stmt);
// Generate a ID
$query = "SELECT * FROM ApplyForm_Assignment2 ORDER BY ID ASC";
$result = mysqli_query($con, $query);
if (!$result) {
echo "Query failed: " . mysqli_error($con);
} else {
// Initialize $id before the while loop
$id = null;
// Fetch the data
while ($row = mysqli_fetch_assoc($result)) {
$id = $row["ID"];
}
// Close the database connection
//Print out the message
if ($id !== null) {
echo "<p class='mycss1'>Sending successfully<br>Your Application ID is: $id</p>";
echo "<form class=\"outter-wrapper\" action=\"status_update.php\" method=\"post\">";
echo "<div class=\"outter-wrapper\">";
echo "<div class=\"table-wrapper\">";
echo "<table id=\"m_table\">\n";
echo "<tr>\n"
. "<th scope=\"col\">Application ID</th>\n"
. "<th scope=\"col\">Status</th>\n"
. "<th scope=\"col\">Job Position</th>\n"
. "<th scope=\"col\">Job Reference No.</th>\n"
. "<th scope=\"col\">Firstname</th>\n"
. "<th scope=\"col\">Lastname</th>\n"
. "<th scope=\"col\">Gender</th>\n"
. "<th scope=\"col\">DOB</th>\n"
. "<th scope=\"col\">Programming Language</th>\n"
. "<th scope=\"col\">Skills</th>\n"
. "<th scope=\"col\">Email</th>\n"
. "<th scope=\"col\">Phone</th>\n"
. "<th scope=\"col\">Address</th>\n"
. "<th scope=\"col\">Suburb</th>\n"
. "<th scope=\"col\">State</th>\n"
. "<th scope=\"col\">Postcode</th>\n"
. "<tr>\n";
// while ($row = mysqli_fetch_assoc($result)) {
echo "<tr>\n";
echo "<td>", $id, "</td>";
// echo "<td>", $row["Status"], "</td>";
// if (!$row["Status"]) {
echo "<td>Pending</td>";
// } else {
// echo "<td>", $row["Status"], "</td>";
// }
echo "<td>", $Job_prefer, "</td>";
echo "<td>", $Job_reference_number, "</td>";
echo "<td>", $Firstname, "</td>";
echo "<td>", $Lastname, "</td>";
echo "<td>", $Gender, "</td>";
echo "<td>", $Dob, "</td>";
echo "<td>", $Programming_language, "</td>";
echo "<td>", $Skills, "</td>";
echo "<td>", $Email, "</td>";
echo "<td>", $Phone, "</td>";
echo "<td>", $Address, "</td>";
echo "<td>", $Suburb, "</td>";
echo "<td>", $State, "</td>";
echo "<td>", $Postcode, "</td>";
}
echo "</table>\n";
echo "</div>\n";
echo "</div>\n";
echo "</div>\n";
mysqli_free_result($result);
}
mysqli_close($con);
$url = htmlspecialchars($_SERVER['HTTP_REFERER']);
echo "<a href='$url' class='goback-button'>Go Back</a>";
echo "<p class='mycss2'>Notice: After receive the Application ID, please wait until there is a email send to you to let you know you are hire or not</p>";
?>