<?php
$con = mysqli_connect("sql.grun94.nazwa.pl", "grun94_Cnistudent9", "Cnistudent9", "grun94_Cnistudent9");


?>

<form action="" method="post">

imie<input type="text" name="first_na">
nazwisko<input type="text" name="last_na">
wiek <input type="text" name="age">
<select name="gender">
	<option value="M">M</option>
	<option value="F">F</option>
	</select>
<input type="submit" name="send"/>
</form>


<?php

if($_POST)
{
	$name=$_POST['first_na'];
	$lastn=$_POST['last_na'];
	$age=$_POST['age'];
	$gender=$_POST['gender'];
	//var_dump($_POST);
	$sql="INSERT INTO user_sch(firstname,lastname,gender,age) VALUES ('$name','$lastn','$gender','$age')";

	mysqli_query($con,$sql);
?>

<table border="1">

<tr>

	<th>imie</th>
	<th>nazwisko</th>
	<th>wiek</th>
	<th>plec</th>
</tr>
<?php
$sql="SELECT * from user_sch";
$result=mysqli_query($con,$sql);
  while($row = mysqli_fetch_assoc($result))
  {
   echo '<tr>';
        echo '<td>'.$row['firstname'].'</td>';
             echo "<td>{$row['lastname']}</td>";
                 echo "<td>{$row['age']}</td>";
                echo "<td>{$row['gender']}</td>";

        echo "</tr>";

  }

?>


</table>
<?php
}
?>