FormH

 <?php

$servername = 'localhost';
$username = 'root';
$password = '';
$dbname = 'MyDB';

$conn =  new mysqli($servername, $username, $password,$dbname);

if($conn->connect_error)
{
die("Connection failed: " . $conn->connect_error);
}
echo "Bravo . Spojeni ste ! <br>" ;

$conn->select_db('mydb');

if(isset($_POST["submit"]))
{
$lastname =isset($_POST["lastname"]) ? trim(htmlspecialchars($_POST["email"], ENT_QUOTES)) : '';
$firstname= isset($_POST["firstname"]) ? trim(htmlspecialchars($_POST["text"],ENT_QUOTES))   : '';
$gender =isset($_POST["gender"]) ? trim(htmlspecialchars($_POST["gender"], ENT_QUOTES)) : '';
$JMBAG =isset($_POST["jmbag"]) ? trim(htmlspecialchars($_POST["jmbag"], ENT_QUOTES)) : '';
$kat =isset($_POST["kat"]) ? trim(htmlspecialchars($_POST["kat"], ENT_QUOTES)) : '';
$soba=isset($_POST["soba"]) ? trim(htmlspecialchars($_POST["soba"], ENT_QUOTES)) : '';
$fakultet =isset($_POST["fakultet"]) ? trim(htmlspecialchars($_POST["fakultet"], ENT_QUOTES)) : '';
$username =isset($_POST["username"]) ? trim(htmlspecialchars($_POST["username"], ENT_QUOTES)) : '';
$pass =isset($_POST["pass"]) ? trim(htmlspecialchars($_POST["pass"], ENT_QUOTES)) : '';


$sql= "INSERT INTO mydb(lastname, firstname,gender, JMBAG, kat , soba, fakultet, username, pass)
       values ($lastname,$firstname , $gender,$JMBAG , $kat , $soba, $fakultet, $username, $pass) ";

$conn->query($sql) or die($conn->error);
echo "Unos uspjesan! " ;
}

?>