Untitled

<?php
session_start();
?>
<!DOCTYPE html>
<html>
  <head>
  <meta charset="UTF-8">
  <title> BO chce spac </title>
  </head>
  <body>
  <?php
  $servername="localhost";
  $username="root";
  $password="";
  $dbname="ksiegarnia";

  $conn=mysqli_connect($servername,$username,$password,$dbname);

  $sql = "select * from ksiazki;";

  $wynik = mysqli_query($conn,$sql);

  if($wynik)
	  if(mysqli_num_rows($wynik)>0)
	  {
		  echo "<table border=1>";
		  echo "<form action='index.php' method='POST'>";
		  while($row=mysqli_fetch_assoc($wynik))
		  {
			  echo "<tr><td>".$row['isbn']."</td><td>".$row['autor']."</td><td>".$row['tytul']."</td><td>".$row['cena']."</td><td>".$row['stan']."</td><td><input type='checkbox' name='ksiazki[]' value='".$row['isbn']."'></td><td><input type='number' name='ilosc[".$row['isbn']."]'></td><tr>";

		  }
		  echo "</table>";
		  echo "<input type='submit' value='BO TAK'>";
		  echo "</form>";
	  }

  $dane=Array();
if(!empty($_POST['ksiazki']))
	{
		foreach($_POST['ksiazki'] as $ksiazka)
		{
		echo $ksiazka." ".$_POST['ilosc'][$ksiazka]."<br>";
		$dane[$ksiazka]=$_POST['ilosc'][$ksiazka];
		}
		echo "<BR>";
	}

	foreach($dane as $klucz=>$wartosc)
	{
	$sql ="Select *	FROM ksiazki where isbn='".$klucz."';";
	echo "xx";
	  $wynikk = mysqli_query($conn,$sql);
		if($wynikk)
		if(mysqli_num_rows($wynikk)>0)
		{
		  while($row=mysqli_fetch_assoc($wynikk))
		  {
			  if($row['stan']>=$wartosc)
				  $row['stan']=$row['stan']-$wartosc;
			  echo $row['stan']."<br>";
			  $sqlone="Update ksiazki set stan='".$row['stan']."' where isbn='".$klucz."';";

			  $wynikone=mysqli_query($conn,$sqlone);

		  }
		}
	}

  ?>
  </body>
  </html>