Untitled

<html>
	<header>
	<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" integrity="sha384-1q8mTJOASx8j1Au+a5WDVnPi2lkFfwwEAa8hDDdjZlpLegxhjVME1fgjWPGmkzs7" crossorigin="anonymous">
	<header>
	<body>
		<?php
			$servername = "localhost";
			$username = "root";
			$password = "";
			$dbname = "andriussumskas";
			$table = "duomenys";

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

			$sql = "SELECT vardas, epastas, data, ip, zinute FROM $table";
			$results = $conn->query($sql);

			if ($results->num_rows > 0){
				while($row = $results->fetch_assoc()){
					echo "
					<div class='row' style='background:lightgrey'>
						<div class= col-md-1> " .$row["vardas"]. "</div>
						<div class= col-md-1>" .$row["epastas"]. "</div>
						<div class= col-md-2>
							<div>" .$row["data"]. "</div>
							<div>(" .$row["ip"]. ")</div>
						</div>
						<div class= col-md-2>" .$row["zinute"]. "</div>
					</div>";
				}
			} else {
				echo "nera duomenu";
			}

			if(isset($_POST['submit'])){
				$ip = $_SERVER['REMOTE_ADDR'];
				$vardas = $_POST['name'];
				$epastas = $_POST['email'];
				$zinute = $_POST['tekstas'];
				$data = date("Y-m-d H:i:s");

				$sql = "INSERT INTO $table (ip, data, vardas, epastas, zinute)
				VALUES ('$ip', '$data', '$vardas', '$epastas', '$zinute')";

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

				$conn->close();
			}
		?>
		<br>
		<form method="post">
				<fieldset class="form-group">
					<label>Vardas: </label>
					<input type="text" class="form-control" name= "name" maxlength="50" required="true">
				</fieldset>
				<fieldset class="form-group">
					<label>E-pastas:</label>
					<input type="email" class="form-control"  name= "email" required="true">
				</fieldset>
				<fieldset class="form-group">
					<label>Tekstas:</label>
					<textarea type="text" class="form-control" name= "tekstas" required="true"> </textarea>
				</fieldset>
				<br>
				<button type="submit" name="submit" class="btn btn-default">siusti</button><br>
		</form>
	</body>
</html>