Untitled



<?php //die (print_r ($_POST));

$servername = "localhost";
$username = "root";
$password = "";
$dbname = "kontaktai";

if (isset($_POST['submit']))
{
	$conn = mysqli_connect($servername, $username, $password, $dbname);
	if (!$conn)
		die("Connection failed");
	echo "Paspaudei mygtuka saugoti!";
	$vardas = trim($_POST["Vardas"]);
	$pavarde = trim($_POST["Pavarde"]);
	if (isset($_POST["Lytis"])){
		$lytis = $_POST["Lytis"];
	}
	else {
		$lytis = '';
	}
	$miestas = $_POST["Miestas"];
	if(isset($_POST["Hobiaim"])){
	$hs = $_POST["Hobiaim"];
	}
	else {
		$hs = '';
	}
	if(isset($_POST["Hobiais"])){
	$hm = $_POST["Hobiais"];}
	else {
		$hm = '';
	}
	if(isset($_POST["Hobiaif"])){
	$hf = $_POST["Hobiaif"];}
	else {
		$hf = '';
	}

	$apie = $_POST["Apie"];


	if (($vardas == '') || ($lytis == '') || ($pavarde == '')){
		echo "Truksta duomenu!";
	}
	else{
		if (strlen($vardas) < 3 || strlen($pavarde) < 3){
			echo "Per trumpas vardas ir/arba pavarde";
		}
		else {
		$sql = "INSERT INTO `zmogus`
		(`vardas`, `pavarde`, `lytis`, `miestas`, `hm`, `hs`, `hf`, `apie`)
		VALUES ('".$vardas."', '".$pavarde."', '".$lytis."', '".$miestas."', '".$hm."', '".$hs."', '".$hf."', '".$apie."');";
		if (mysqli_query($conn, $sql))

			{echo "Valio bus olaus";}
		}
	}


	mysqli_close($conn);
}


?>
<html>
<body style="background-color:#cce6ff">

<form action="forma.php" method="post">

Vardas:
<input type="text" name="Vardas" value="<?php echo (isset($_POST["Vardas"])? $_POST["Vardas"] : "");?>"><br>
Pavarde:
<input type="text" name="Pavarde" value="<?php echo (isset($_POST["Pavarde"])? $_POST["Pavarde"] : "");?>"><br>
Lytis:<br>
<input type="radio" name="Lytis" value="Vyras"
<?php if (isset($_POST["Lytis"]) && ($_POST["Lytis"]=="Vyras"))  echo "checked";?>
>Vyras<br>
<input type="radio" name="Lytis" value="Moteris"
<?php if (isset($_POST["Lytis"]) && ($_POST["Lytis"]=="Moteris")) echo "checked";?>
>Moteris<br>

Miestas:
<select name="Miestas">
<?php
$miestai = array ("vln" => "Vilnius", "kns" => "Kaunas", "klp" => "Klaipėda", "sia" => "Šiauliai", "pnv" => "Panevezys");
foreach ($miestai as $index => $value){
	if (isset($_POST["Miestas"]) && ($_POST["Miestas"] == $index)) {
		$selected = 'selected';
	}
	else {
		$selected = '';
	}
	echo "<option value='" . $index . "' " . $selected . ">" . $value . "</option>";
}


?>
</select name="pasrinkimas" ><br>
Hobiai:<br>
<input type="checkbox" name="Hobiaim" value="Muzika"
<?php if (isset($_POST["Hobiai"]) && array_key_exists('m', $_POST["Hobiai"])) echo "checked";?>
>Muzika<br>
<input type="checkbox" name="Hobiais" value="Sportas"
<?php if (isset($_POST["Hobiai2"]) && array_key_exists('s', $_POST["Hobiai2"])) echo "checked";?>
>Sportas<br>
<input type="checkbox" name="Hobiaif" value="Filmai"
<?php if (isset($_POST["Hobiai"]) && array_key_exists('f', $_POST["Hobiai"])) echo "checked";?>
>Filmai<br>
Apie save:<br>
<textarea rows="3" cols="40" name="Apie" ><?php echo (isset($_POST["Apie"])? $_POST["Apie"] : "");?></textarea><br>
<input type="submit" value="Priimti" name="submit"><br>
</form>

</body>
</html>


<html>

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "kontaktai";

$conn = mysqli_connect($servername, $username, $password, $dbname);
	if (!$conn)
		die("Connection failed");
	$sql = "SELECT id, vardas, pavarde, lytis,miestas,hm,hs,hf,apie FROM `zmogus`";
$result = mysqli_query($conn, $sql);


mysqli_close($conn);
?>

<body style="background-color:#cce6ff">

<a href="forma.php">Sukurti nauja irasa</a>
<br></br>

<table border ="1px", style="width:100%">
  <tr>
    <th>Vardas</th>
    <th>Pavarde</th>
	<th>Lytis</th>
	<th>Miestas</th>
	<th>Hm</th>
	<th>Hs</th>
	<th>Hf</th>
	<th>Apie</th>
	</tr>
	<?php

if (mysqli_num_rows($result) > 0) {

    while($row = mysqli_fetch_assoc($result)) {
        echo   "<tr><td>". $row["vardas"]. "</td>";
		echo"<td>".$row["pavarde"]."</td>";
			if ($row["lytis"]== "V")
			echo "<td> vyras</td> ";
			else if ($row["lytis"]=="M"){
			echo "<td>moteris</td> ";}
			else echo "<td>kita</td> ";

				if ($row["miestas"]== "vln")
			echo "<td> vilnius</td> ";
			else if ($row["miestas"]=="klp"){
			echo "<td>klaipeda</td> ";}
		else if ($row["miestas"]=="kns"){
			echo "<td>Kaunas</td> ";}
		else if ($row["miestas"]=="sia"){
			echo "<td>siauliai</td> ";}
		else if ($row["miestas"]=="pnz"){
			echo "<td>panevezys</td> ";}
		//else echo "<td>kita</td> ";
		echo"<td>" . $row["hm"]."</td>";
		echo"<td> " . $row["hs"]."</td>";
		echo"<td> " . $row["hf"]." </td>";
		echo"<td>" . $row["apie"]."</td></tr>";
    }
} else {
    echo "0 results";
}
	?>

	</table>


</body>
</html>