<?php
/* Set oracle user login and password info */
$dbuser = "*MY USERNAME*";
$dbpass = "*MY PASSWORD*";
$dbname = "SSID";
$db = oci_connect($dbuser, $dbpass, $dbname);

if (!$db)  {
    echo "An error occurred connecting to the database";
    exit;
}

$user = $_POST['user'];
$pass = $_POST['pass'];

$sql_login = "SELECT Username FROM users WHERE Username='%".$user."%'";

$login_stmt = oci_parse($db, $sql_login);

if(!$login_stmt)
{
    echo "An error occurred in parsing the sql string.n";
    exit;
}

oci_execute($login_stmt);

while(oci_fetch_array($login_stmt))
{
    $password = oci_result($login_stmt,"Password");
}

if ($password == "")
{
    echo 'Password = blank';
}

if ($pass == $password)
{
    echo 'Logged In';
}
else
{
    echo 'Login Failed';
}


?>

while(oci_fetch_array($login_stmt))
{
    $password = oci_result($login_stmt,"Password");
}

<form name="register" method="post" action="inc/login.php">
                <div class="form_row">
                <label class="contact"><strong>Username:</strong></label>
                <input type="text" name="user" class="contact_input" />
                </div>


                <div class="form_row">
                <label class="contact"><strong>Password:</strong></label>
                <input type="password" name="pass" class="contact_input" />
                </div>

                <div class="form_row">
                    <div class="terms">
                    <input type="checkbox" name="terms" />
                    Remember me
                    </div>
                </div>


                <div class="form_row">
                <input type="submit" class="register" value="login" />
                </div>
</form>

$sql_login = "SELECT Username FROM users WHERE Username like '%".$user."%'";

$password = oci_result($login_stmt,"PASSWORD");