Untitled

<html>
<head>
<style>
#container{
	width:800px;
	margin-left:auto;
	margin-right:auto;
}
#top{
	background-color:yellow;
	padding:10px;
	height:150px;
}
#l{
	background-color:orange;
	float:left;
	padding:10px;
	width:380px;
	height:300px;
}
#r{
	background-color:purple;
	padding:10px;
	float:left;
	width:380px;
	height:300px;
}
#b{
	background-color:blue;
	padding:10px;
	height:150px;
}
</style>
</head>
<body>
<div id="container">
<div id="top">
<form action=test2.php method=POST>
Marka<input type=text name=marka><br>
Model<input type=text name=model><br>
Cena<input type=text name=cena><br>
<input type=submit value=wyslij>
</form>
<?php
	if(isset($_POST['marka'])){
	$marka=$_POST['marka'];
	$model=$_POST['model'];
	$cena=$_POST['cena'];
	$pol=mysqli_connect("localhost","root","","samochody");
	$z="insert into auta values('$marka','$model','$cena')";
	$w=mysqli_query($pol,$z);
	mysqli_close($pol);
	}
?>
</div>
<div id="l">
<?php
	$pol=mysqli_connect("localhost","root","","samochody");
	$z="select * from auta";
	$w=mysqli_query($pol,$z);
	$rekord=mysqli_fetch_assoc($w);
	while($rekord=mysqli_fetch_assoc($w)){
	echo $rekord['marka']." ".$rekord['model']." ".$rekord['cena']."<br>";
	}
	mysqli_close($pol);
?>
</div>
<div id="r">
<form action=test2.php method=POST>
Szukaj<input type=text name=szukaj><br>
<input type=submit value=znajdz>
</form>
<?php
	if (isset($_POST['szukaj'])){
	$s=$_POST['szukaj'];
	$pol=mysqli_connect("localhost","root","","samochody");
	$z="select count(marka) as a from auta where marka='$s'";
	$w=mysqli_query($pol,$z);
	$rekord=mysqli_fetch_assoc($w);
	echo "Jest ".$rekord['a']." takich wartości";
	mysqli_close($pol);
}
?>
</div>
<div id="b">
CHUJ
<?php
	$pol=mysqli_connect("localhost","root","","samochody");
	$z="select avg(cena) as a from auta";
	$w=mysqli_query($pol,$z);
	$a=mysqli_fetch_assoc($w)['a'];
	echo "Srednia cenowa to: ".$a;
	mysqli_close($pol);
?>
</div>
</div>
</body>
</html>