tinklai_lab3

<!DOCTYPE html>
<html>
	<head>
		<link rel="stylesheet"
		href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css">
		<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
		<script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/js/bootstrap.min.js"></script>
	</head>

	<body>
		<?php
			$servername = "localhost";
			$username = "root";
			$password = "";
			$dbname = "tinklai_lab2";

			// Create connection
			$conn = new mysqli($servername, $username, $password, $dbname);
			// Check connection
			if ($conn->connect_error)
			{
				die("Connection failed: " . $conn->connect_error);
			}

			if(!empty($_POST['ok']))
			{
				$date = date('Y/m/d H:i:s');
				$ip = $_SERVER['REMOTE_ADDR'];
				$epastas = $_POST['epastas'];
				$zinute = $_POST['zinute'];
				$vardas = $_POST['vardas'];

				$query = "INSERT INTO `sauliusstankevicius` (vardas, data, ip, epastas, zinute)
					VALUES ('$vardas', '$date', '$ip', '$epastas', '$zinute')";

				if ($conn->query($query) === TRUE)
				{
					echo "New record created successfully";
				}
				else
				{
					echo "Error: " . $query . "<br>" . $conn->error;
				}
			}

			$conn->close();
		?>

		<div class="container">
			<form method='post'>
				<div class="form-group col-lg-12">
					<label for="vardas" class="control-label">Vardas:</label>
					<input name='vardas' id='vardas' type='text' class="form-control input-sm" required="true">
				</div>
				<div class="form-group col-lg-12">
					<label for="epastas" class="control-label">e-pastas:</label>
					<input name='epastas' id="epastas" type='email' class="form-control input-sm" required="false">
				</div>
				<div class="form-group col-lg-12">
					<label for="zinute" class="control-label">tekstas:</label>
					<textarea name='zinute' class="form-control input-sm" required="false"></textarea>
				</div>
				<div class="form-group">
					<input type='submit' name='ok' value='siusti' class="btn btn-default">
				</div>
			</form>
		</div>
	</body>
</html>