<?php
$servername = "localhost";
$username = "root";
$password = "";
$db = "kapcms";

// Create connection
$connection = new mysqli($servername, $username, $password, $db);

// Check connection
if ($connection->connect_error) {
    die("Connection failed: " . $connection->connect_error);
}
echo "Connected successfully";
?>

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

<label for=""><h4>Insert number</h4></label>
<div>
    <input name="search_number" type="number">
<button name="submit" type="submit" value="Find">Submit</button>
<hr>
</div>

<table>
    <thead>
        <tr>
            <th>ID</th>
            <th>Name</th>
            <th>LName</th>
            <th>Number</th>
            <th>Street</th>

        </tr>
    </thead>

    <tbody>

    </tbody>


    <?php

if(isset($_POST['search_number'])) {

$number = $_POST['search_number'];

mysqli_set_charset($connection, "utf8");

$query = "SELECT * FROM b_spisak WHERE jmbg = '$number' LIMIT 1";
$search_number_query = mysqli_query($connection, $query);

if(!$search_number_query) {

    die("Query Failed" . mysqli_error($connection));

}

if(mysqli_num_rows($search_number_query) > 0) {

    while($row = mysqli_fetch_assoc($search_number_query)) {

            $b_id = $row['id'];
            $b_name = $row['ime'];
            $b_lname = $row['prezime'];
            $b_number = $row['jmbg'];
            $b_street = $row['ulica'];

            echo "<tr>";
            echo "<td>{$b_id}</td>";
            echo "<td>{$b_name}</td>";
            echo "<td>{$b_lname}</td>";
            echo "<td>{$b_number}</td>";
            echo "<td>{$b_street}</td>";

        }

    } else {

        echo "Number does not exist!";

    }

}
    ?>

    </table>
    <button type="submit" name="add" formaction="add.php" >Add</button>
    <hr>

</form>

<?php
$servername = "localhost";
$username = "root";
$password = "";
$db = "kapcms";

// Create connection
$connection = new mysqli($servername, $username, $password, $db);

// Check connection
if ($connection->connect_error) {
    die("Connection failed: " . $connection->connect_error);
}
echo "Connected successfully";
?>

<?php

if(isset($_POST['add'])) {

    $b_id = $_POST['id'];

    $b_name = $_POST['ime'];
    $b_lname = $_POST['prezime'];
    $b_number = $_POST['jmbg'];
    $b_street = $_POST['ulica'];


    $query = mysqli_query($connection, "set names utf8");
    $query = "SELECT * FROM b_spisak WHERE id = '$b_id'";
    $add_query = mysqli_query($connection, $query);

    if(!$add_query) {

        die("QueryFailed" . mysqli_error($connection));

    }

    while($row = mysqli_fetch_assoc($add_query)) {

        $id_b = $row['id'];
        $name_b = $row['ime'];
        $lname_b = $row['prezime'];
        $number_b = $row['jmbg'];
        $street_b = $row['ulica'];

    }

}

?>

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

    <div>
        <div>
            <input type="text" name="name" placeholder="Name" value="<?php echo $name_b; ?>">
        </div>
    </div>

    <div>
        <div>
            <input type="text" name="lname" placeholder="LName">
        </div>
    </div>

    <div>
        <div>
            <input type="text" id="exampleInputName2" name="jmbg" placeholder="JMBG">
        </div>
    </div>
    <div>
        <div>
            <input type="text" name="name" placeholder="Name" value="<?php echo $name_b; ?>">
        </div>
    </div>


    <button type="submit" name="submit2">Add</button>

</form>