<?php

    $dbHost = 'localhost';
    $dbUser = 'videobim_una';
    $dbPass = 'qqqqqq123';
    $dbName = 'videobim_una';

    $db = mysql_connect ($dbHost, $dbUser, $dbPass);

    if ($db)
    {
        $dbConn = mysql_select_db ($dbName, $db);
    }

    //get ID iz adrese
    if (isset($_GET['i']))
    {
    $i = $_GET['i'];

    $query = "SELECT * FROM users WHERE id_user = $i";
    $result = mysql_query ($query);

    while ($col = mysql_fetch_assoc ($result))
    {
        $firstName = $col['first_name'];
        $lastName = $col['last_name'];
        $userName = $col['username'];
        $pass = $col['password'];
    }
    }
?>

<form name="user" id="user" method="post" action="">
    <label for="first_name"><strong>First name:</strong></label>
    <br />
    <input type="text" name="first_name" id="first_name" value="<?php echo $firstName; ?>"/>

    <br />  <br />
    <label for="last_name"><strong>Last name:</strong></label>
    <br />
    <input type="text" id="last_name" name="last_name" value="<?php echo $lastName; ?>"/>

    <br /><br />
    <label for="username"><strong>Username:</strong></label>
    <br />
    <input type="text" id="username" name="username" value="<?php echo $userName; ?>"/>

    <br /><br />
    <label for="pass"><strong>Password:</strong></label>
    <br />
    <input type="password" name="pass" id="pass" value="<?php echo $pass; ?>"/>

    <input type="hidden" name="id" id="id" value="<?php echo $i;?>" />

    <input type="submit" name="submit" id="submit" value="Send This!" />
</form>

<?php
    //upis ili izmena u bazi
    if (isset($_POST['submit']))
    {
        $first_name = $_POST['first_name'];
        $last_name = $_POST['last_name'];
        $username = $_POST['username'];
        $pass = $_POST['pass'];

        var_dump ($first_name);

        //korisnicki ID
        $id = $_POST['id'];


        //UPDATE
        if (!empty($id))
        {
            $query = "UPDATE users SET first_name = '$first_name', last_name = '$last_name', username = '$username', password = '$pass' WHERE id_user = $id";
            $result = mysql_query ($query) or die ('Error: ' .mysql_error());

            if ($result)
            {
                die ('Update je izvrsen');
            }
        }

        else {

        //INSERT
        if (empty($username) OR empty($pass))
        {
            echo 'Popunite sva polja';
            exit;
        }

        if (strlen($pass) < 4)
        {
            die ('Sifra nije dovoljno dugacka');
        }

        $query = "INSERT INTO users (first_name, last_name, username, password) VALUES ('$first_name', '$last_name', '$username', '$pass')";
        $result = mysql_query ($query);

        if ($result)
        echo 'Query je izvrsen!';
        }
    }

?>


<?php
    //ispis iz baze
    echo '------------------------------------<br />';

    $query = "SELECT * FROM users ORDER BY id_user ASC";
    $result = mysql_query ($query);

    while ($row = mysql_fetch_assoc ($result))
    {
        $firstName = $row['first_name'];
        $lastName = $row['last_name'];
        $userName = $row['username'];
        $pass = $row['password'];

        echo $firstName . ' ' .$lastName . ' ' .$userName . ' ' . $pass;
        echo '<br />';
    }
?>