Untitled

<!DOCTYPE html>
<html lang=PL >
<head>
<meta charset=utf-8>
<title>Zmiana danych w bazie</title>
</head>
<body>
<h2>Zmiana danych w bazie</h2>
<a href=index.php>Index</a></br>
<style> td { border: 1px solid black };</style>

<form action="" method="POST">
<div>
<input type="submit" name="p" value="Aktualizuj" />
<input type="submit" name="m" value="Usuń" />
</div>
</form>

<?php
	$p=mysqli_connect("localhost","root", "","test1");
	if(!$p) echo "Nie działa.";


	if(isset($_POST['p'])){
	$sql="UPDATE tklienci set plec='k' where imie like '%a'";
	mysqli_query($p,$sql);
	$sql="UPDATE tklienci set plec='m' where imie not like '%a'";
	mysqli_query($p,$sql);
	}
	if(isset($_POST['m'])){
	$sql="UPDATE tklienci set plec='' where plec like 'k'";
	mysqli_query($p,$sql);
	$sql="UPDATE tklienci set plec='' where plec like 'm'";
	mysqli_query($p,$sql);
	}

	$sql="SELECT * from tklienci ORDER BY nazwisko";

	echo "<table>";
	echo "<tr>";
	echo "<td>Id</td><td>Imie</td><td>Nazwisko</td><td>Płeć</td>";
	echo "</tr>";
	$wnk=mysqli_query($p,$sql);
	$w=mysqli_num_rows($wnk);
	while($wers=mysqli_fetch_row($wnk)){
	echo "<tr>";
	echo "<td>$wers[0]</td><td>$wers[1]</td><td>$wers[2]</td><td>$wers[10]</td><br>";
	echo "</tr>";
	}

	echo "</table>";


mysqli_close($p);
?>
</body>
</html>