Untitled

<head>
<!-- Optional theme -->
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/css/bootstrap.min.css" integrity="sha384-Vkoo8x4CGsO3+Hhxv8T/Q5PaXtkKtu6ug5TOeNV6gBiFeWPGFN9MuhOf23Q9Ifjh" crossorigin="anonymous"><link rel="stylesheet" href="style.css">
</head>
<body>
  <div class="container">
<form method="get">
<label>Wpisz nazwisko</label>
<input type="text" name="nazwisko" placeholder="nazwisko">
<button class="btn btn-primary" type="submit" value="szukaj">Szukaj</button>
</form>


<?php


 $Host='127.0.0.1';
 $DBase='oswiata';
 $FUser='root';
 $FPass='';


  function polacz( $host,$dbase,$user, $pass )
  {
    @$pol=mysqli_connect( $host, $user, $pass );
    if( !$pol )
    {

	echo 'Bład polaczenia z Serwerem Bazy Danych'.PHP_EOL;
	echo "Kod błędu: " . mysqli_connect_errno() . PHP_EOL;
    echo "Błąd: " . mysqli_connect_error() . PHP_EOL;
    exit;
    }
    else
    {
       mysqli_select_db( $pol, $dbase );
       if( mysql_errno() )
       {
			echo mysql_errno();
			echo mysql_error();
			exit;
		}
    }
     return $pol;
  }

  $idpol=polacz($Host, $DBase, $FUser, $FPass);


	if(isset($_GET['nazwisko'])){
		$wyniki=mysqli_query($idpol, "SELECT * FROM studenci WHERE nazwisko like '".$_GET['nazwisko']."'");

?>
<div class="table">
<table class="table">
  <thead class="thead-dark">
		<tr>
			<th>NR_STUD</th>
			<th>NAZWISKO</th>
			<th>DATA_UR</th>
			<th>PLEC</th>
			<th>NR_KIER</th>
		</tr>
  </thead>
    <tbody>
<?php
			if( $wyniki )
			{
				$color = 100;
				while($wiersz=mysqli_fetch_row($wyniki))
				{
					echo "<tr style='background-color: hsl($color, 100%, 70%)'>";

					echo "<td>$wiersz[0]</td>";
					echo "<td><a href='testPN.php?student=$wiersz[0]' class=\"text-dark\">$wiersz[1]</a></td>";
					echo "<td>$wiersz[2]</td>";
					echo "<td>$wiersz[3]</td>";
					echo "<td>$wiersz[4]</td>";
					echo "</tr>";
					$color +=  5;
				}
				echo "</tbody></table>";
			}
			else
				echo "Brak";
}


	if(isset($_GET['student'])){
		$wyniki=mysqli_query($idpol, "SELECT * FROM oceny WHERE NR_STUD=".$_GET['student']);
		?>
			<table class="table">
			<thead class="thead-dark">
				<tr>
					<th>NR_STUD</th>
					<th>NR_PRZEDM</th>
					<th>DATA_ZAL</th>
					<th>TERMIN</th>
					<th>ZAL_EGZ</th>
					<th>OCENA</th>
				</tr>
			</thead>
			<tbody>
	<?php		if( $wyniki )
			{
				$color = 100;
				while($wiersz=mysqli_fetch_row($wyniki))
				{
					echo "<tr style='background-color: hsl($color, 100%, 70%)'>";
					echo "<td>$wiersz[0]</td>";
					echo "<td>$wiersz[1]</td>";
					echo "<td>$wiersz[2]</td>";
					echo "<td>$wiersz[3]</td>";
					echo "<td>$wiersz[4]</td>";
					echo "<td>$wiersz[5]</td>";
					echo "</tr>";
					$color += 30;
				}
				echo "</tbody></table>";
			}
	}
		?>

</div>
</div>
<script src="https://code.jquery.com/jquery-3.4.1.slim.min.js" integrity="sha384-J6qa4849blE2+poT4WnyKhv5vZF5SrPo0iEjwBvKU7imGFAV0wwj1yYfoRSJoZ+n" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.0/dist/umd/popper.min.js" integrity="sha384-Q6E9RHvbIyZFJoft+2mJbHaEWldlvI9IOYy5n3zV9zzTtmI3UksdQRVvoxMfooAo" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/js/bootstrap.min.js" integrity="sha384-wfSDF2E50Y2D1uUdj0O3uMBJnjuUD4Ih7YwaYd1iqfktj0Uod8GCExl3Og8ifwB6" crossorigin="anonymous"></script>
</body>