title: How to create login form using oracle database?
body: <p>Thanks in advance. 
  I'm having trouble creating login form with oracle database actually I have created successful connection but problem with login form connectivity</p>
  
  <pre><code>    $conn = oci_connect('hr', 'hr', 'localhost/XE', 'AL32UTF8');
      session_start();
  
      $myusername = isset($_POST['username']);
      $mypassword = isset($_POST['password']);
  
      $query = "SELECT * FROM VTP_admin WHERE username='".$myusername."' and password='".$mypassword."'  ";
      $vtpid = oci_parse($conn, $query);
  
      $result = oci_execute($vtpid);
  
      $count=oci_num_rows($vtpid);
      echo ($count);
  
      if($count==1){
          $_SESSION["username"];
          $_SESSION["password"];
  
          header("localhost/ERP/dashboard.php");
      }
      else{
          echo "Incorrect Username or Password";
      }
  </code></pre>