Untitled

<html>
<title>Report Academic Dishonesty</title>
<center>
<img src="KSUlogo.png" alt="KSU Logo" style="width:600px;height:150px;">
<h1> Academic Dishonesty Reporting Form </h1>

<?php
	//Validate that the Banner ID entered exists in the database, 498672563 for testing;

	$banner = $_POST['BannerID'];

	$username = 'root';
	$password = '123';
	$database = 'banner';

	$conn = mysqli_connect('localhost',$username,$password,$database);

	$SQL = "SELECT * FROM instructor WHERE Instructor_Banner_ID = $banner";

	$recordset = mysqli_query($conn, $SQL);
	if ($recordset == false) {
	echo "ID not known";
	die();
	};

	$SQL = "SELECT * FROM course WHERE Instructor_Banner_ID = $banner";
	$recordset = mysqli_query($conn, $SQL);
	echo "Please select a course. <br> <br> ";
	while ($record=mysqli_fetch_array($recordset,MYSQLI_ASSOC)) {
	$title = $record['Course_Name'];
	$CID = $record['Course_ID'];
	echo "<a href = 'roster.php?CID=$CID'>$title - $CID</a> <br>";
	};
?>
<br>
<button onclick="history.go(-1);">Back </button>
</center>
</html>