Untitled

<?php
require_once("setting.php");
require_once("manage.php");
$con = mysqli_connect($host, $user, $pass);
mysqli_select_db($con, $db);

$sql = "SELECT * FROM EOI";
?>

<html>

<head>
<link href= "styles/style.css" type="text/css" rel="stylesheet"/>
  <link href= "styles/enhancements.css" type="text/css" rel="stylesheet"/>
</head>

<?php require_once("header.php");
	RenderHeader("Manage Applicants")
 ?>

 </br>
 </br>

<body>

<form name="search" method="post" action="manage.php">
<p><input type="text" name="searchbox" value=""/>
<input type="submit" name="search" value="Search EOI" class="button3"/>
<input type="submit" name="delete" value="Delete Entries" class="button3"/></p>
</form>

<?php

// $sql2 = "SELECT * FROM EOI";
// $sql2 = "DELETE * FROM EOI";

// if (isset($_POST['search'])) {
	// $search_term = $_POST["searchbox"];
	// $sql2 .= "WHERE JobNumber = '{$search_term}'";
	// $sql2 .= "OR FirstName = '{$search_term}'";
	// $sql2 .= "OR LastName = '{$search_term}'";
// }

// if (isset($_POST['delete'])) {
	// $search_term = $_POST["searchbox"];
	// $sql3 .= "WHERE JobNumber = '{$search_term}'";
// }

$myData = mysqli_query($con,$sql); ?>


<table border=1>
<tr>
<th>EOI Number</th>
<th>Job Number</th>
<th>First Name</th>
<th>Last Name</th>
<th>Date of Birth</th>
<th>Gender</th>
<th>Address</th>
<th>Suburb</th>
<th>State</th>
<th>Postcode</th>
<th>Email</th>
<th>Phone Number</th>
<th>S1</th>
<th>S2</th>
<th>S3</th>
<th>S4</th>
<th>S5</th>
<th>OtherS</th>
<th>Comments</th>
</tr>

<?php

$current = "INSERT INTO EOI(Status) VALUE 'Current'";
$final = "INSERT INTO EOI(Status) VALUE 'Final'";

while($record = mysqli_fetch_assoc($myData)) {
	"<tr>";
	echo "<td>".$record['EOINumber']."</td>";
	echo "<td>".$record['JobNumber']."</td>";
	echo "<td>".$record['GivenName']."</td>";
	echo "<td>".$record['LastName']."</td>";
	echo "<td>".
	"<select id="dropdownbutton" name="State">"
	."<option value='VIC'>".$record['Status'].
	"</option>"
	"<option value='NSW'>".$current.
	"</option>".
	"<option value='QLD'>".$final.
	"</option>".
	"</td>";
	echo "<td>".$record['DOB']."</td>";
	echo "<td>".$record['Gender']."</td>";
	echo "<td>".$record['Address']."</td>";
	echo "<td>".$record['Suburb']."</td>";
	echo "<td>".$record['State']."</td>";
	echo "<td>".$record['Postcode']."</td>";
	echo "<td>".$record['Email']."</td>";
	echo "<td>".$record['Number']."</td>";
	echo "<td>".$record['Self_Sufficient']."</td>";
	echo "<td>".$record['Team_Worker']."</td>";
	echo "<td>".$record['Hard_Worker']."</td>";
	echo "<td>".$record['Passionate']."</td>";
	echo "<td>".$record['Fast_Learner']."</td>";
	echo "<td>".$record['OtherSkills']."</td>";
	echo "<td>".$record['Comments']."</td>";
	echo "<td>"."</tr>";
} ?>

<?php echo "</table>";

mysqli_close($con);
?>


</body>
</br>
</br>
</br>
</br>
</br>
</br>
</br>
</br>
</br>
</br>


<?php require_once("footer.php"); ?>

</html>