nmilosev/primer.php

## primer.php
<?php
$servername = "localhost";
$username = "root";
$password = "PROMENITI!";
$dbname = "test";

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

if ($_POST["id"] !== null) {
	$personid = $_POST["id"];
	$firstname = $_POST["name"];
	$lastname = $_POST["lastname"];

	$stmt = $conn->prepare("insert into Persons(personid, firstname, lastname) values (?, ?, ?);");
	$stmt->bind_param("iss", $personid, $firstname, $lastname);
	$stmt->execute();
}

$sql = "SELECT personid, firstname, lastname FROM Persons";
$result = $conn->query($sql);

$conn->close();
?>

<!doctype html>
<html lang="en">
  <head>
    <!-- Required meta tags -->
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

    <!-- Bootstrap CSS -->
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">

    <title>Imenik</title>
  </head>
  <body>


	<div class="container" style="margin-top: 10%;">
		<h1>Aplikacija</h1>
		<form action="index.php" method="post">
			Id: <input type="text" name="id"><br>
			First name: <input type="text" name="name"><br>
			Last name: <input type="text" name="lastname"><br>
			<input type="submit" class="btn btn-success">
		</form>
		<hr>
		<table class="table">
		<thead>
			<th>#</th>
			<th>First Name</th>
			<th>Last Name</th>
		</thead>
		<?php
		    while($row = $result->fetch_assoc()) {
			echo("<tr>");
			echo("<td>" . $row["personid"] . "</td>");
			echo("<td>" . $row["firstname"] . "</td>");
			echo("<td>" . $row["lastname"] . "</td>");
			echo("</tr>");
		    }
		?>
		</table>
	</div>


    <!-- Optional JavaScript -->
    <!-- jQuery first, then Popper.js, then Bootstrap JS -->
    <script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q" crossorigin="anonymous"></script>
    <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl" crossorigin="anonymous"></script>
</body>
</html>
	<?php
	$servername = "localhost";
	$username = "root";
	$password = "PROMENITI!";
	$dbname = "test";

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

	if ($_POST["id"] !== null) {
	$personid = $_POST["id"];
	$firstname = $_POST["name"];
	$lastname = $_POST["lastname"];

	$stmt = $conn->prepare("insert into Persons(personid, firstname, lastname) values (?, ?, ?);");
	$stmt->bind_param("iss", $personid, $firstname, $lastname);
	$stmt->execute();
	}

	$sql = "SELECT personid, firstname, lastname FROM Persons";
	$result = $conn->query($sql);

	$conn->close();
	?>

	<!doctype html>
	<html lang="en">
	<head>
	<!-- Required meta tags -->
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

	<!-- Bootstrap CSS -->
	<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">

	<title>Imenik</title>
	</head>
	<body>


	<div class="container" style="margin-top: 10%;">
	<h1>Aplikacija</h1>
	<form action="index.php" method="post">
	Id: <input type="text" name="id"><br>
	First name: <input type="text" name="name"><br>
	Last name: <input type="text" name="lastname"><br>
	<input type="submit" class="btn btn-success">
	</form>
	<hr>
	<table class="table">
	<thead>
	<th>#</th>
	<th>First Name</th>
	<th>Last Name</th>
	</thead>
	<?php
	while($row = $result->fetch_assoc()) {
	echo("<tr>");
	echo("<td>" . $row["personid"] . "</td>");
	echo("<td>" . $row["firstname"] . "</td>");
	echo("<td>" . $row["lastname"] . "</td>");
	echo("</tr>");
	}
	?>
	</table>
	</div>


	<!-- Optional JavaScript -->
	<!-- jQuery first, then Popper.js, then Bootstrap JS -->
	<script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q" crossorigin="anonymous"></script>
	<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl" crossorigin="anonymous"></script>
	</body>
	</html>