<?php
include 'header.php';
?>

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

<form action="<?=$_SERVER['PHP_SELF']?>" method="post">
		StudentUsername: <input type="text" name="StudentUsername" /><br />
		New Student Password: <input type="password" name="StudentPassword" /><br/>
		Teacher Username: <input type="text" name="username" /><br />
		Teacher Password: <input type="password" name="TeacherPassword" /><br />

		<input type="submit" name="submit" value="Login" />
	</form>
<?php
	require_once("conn.php");
	$mysqli = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
	# check connection
	if ($mysqli->connect_errno) {
		echo "<p>MySQL error no {$mysqli->connect_errno} : {$mysqli->connect_error}</p>";
		exit();
	}

	$TeacherUsername = $_POST['username'];
	$TeacherPassword = $_POST['TeacherPassword'];
	$StudentUsername = $_POST['StudentUsername'];
	$StudentPassword = $_POST['PasswordUsername'];


	$sql = "SELECT * FROM `teacher` WHERE `Username` = '$username' AND `Password` = '$TeacherPassword' LIMIT 1";
	$result = $mysqli ->query($sql);
	if ($result->num_rows > 0 ) {
		$sql = "UPDATE `student` SET `Password` = '$StudentPassword' WHERE `student`.`Username` = '$StudentUsername'";
	}
		$result = $mysqli ->query($sql);
		if($result){
			Echo 'password changed';

		}