login

<?php

$user = "SYSTEM";
$pass = "12345678";
$host = "localhost/ORCL";

$ID = $_POST['ID'];
$PASSWORD = $_POST['PASSWORD'];

$conn = oci_connect($user, $pass, $host);
$sql = oci_parse($conn, "SELECT * FROM LOGIN WHERE ID='$ID' AND PASSWORD='$PASSWORD'");

//$sql = oci_parse($conn, "SELECT * FROM LOGIN WHERE rownum <100");

oci_execute($sql);

$rows = array();
while($r = oci_fetch_assoc($sql)) {
$rows[] = $r;
}

if(isset($r)){
//displaying success
echo "success";
}else{
//displaying failure
echo "failure";
}
$locations =(json_encode($rows));
echo $locations;
?>