title: Login is not working php oracle
body: <p>when I try to log in, it just does not work, the code should enter the if and write a message "Adelante!" but it does not work (enter the else) I searched the error for a long time but I can not find it. I made sure that the data is good, and try with more tables from the Schema DB but nothing works either ... No error or anything indicates the console either</p>
  
  <p>Here is the code</p>
  
  <p><strong>Page 1:</strong></p>
  
  <pre><code>&lt;!DOCTYPE html&gt;
  &lt;html&gt;
  &lt;head&gt;
      &lt;title&gt;Sistema de login&lt;/title&gt;
      &lt;style type="text/css"&gt;
  
          h1{
              text-align: center;
          }
  
          table{
              width: 25%;
              background-color: #FFC;
              border: 2px dotted #F00;
              margin: auto; 
          }
  
          .izq{
              text-align: right;
          }
          .der{
              text-align: left;
          }
          td{
              text-align: center;
              padding: 10px;
          }
  
      &lt;/style&gt;
  &lt;/head&gt;
  &lt;body&gt;
  &lt;h1&gt; INRODUCE TUS DATOS&lt;/h1&gt;
  
  &lt;form action = "59sistema_login2.php" method="post"&gt; 
  &lt;table&gt;
      &lt;tr&gt;&lt;td class="izq"&gt;Login:&lt;/td&gt;&lt;td class="der"&gt;&lt;input type="text" name="login"&gt;&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td class="izq"&gt;Password:&lt;/td&gt;&lt;td class ="der"&gt;&lt;input type="password" name="password"&gt;&lt;/td&gt;&lt;/tr&gt;
      &lt;tr&gt;&lt;td colspan="2"&gt;&lt;input type="submit" name="enviar" value="LOGIN"&gt;&lt;/td&gt;&lt;/tr&gt; 
  &lt;table&gt;
  
  &lt;/body&gt;
  &lt;/html&gt;
  </code></pre>
  
  <p><strong>Page 2: (59sistema_login2.php)</strong></p>
  
  <pre><code> &lt;!DOCTYPE html&gt;
  &lt;html&gt;
  &lt;head&gt;
      &lt;title&gt;&lt;/title&gt;
  &lt;/head&gt;
  &lt;body&gt;
  &lt;?php
      try
      {
          $base = new PDO('oci:dbname=localhost', 'hr','hr');
          $base-&gt;setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
          $sql= "SELECT * FROM DEPARTMENTS WHERE DEPARTMENT_ID=:login AND MANAGER_ID=:password";
          $resultado = $base-&gt;prepare($sql);
          $login = htmlentities(addslashes($_POST["login"])); 
          $password = htmlentities(addslashes($_POST["password"]));
          $resultado-&gt;bindValue(":login", $login); 
          $resultado-&gt;bindValue(":password", $password);
  
          $resultado-&gt;execute();
  
          $numero_registro=$resultado-&gt;rowCount(); 
  
          echo "valor: $numero_registro&lt;br&gt;&lt;br&gt;";
          echo "$login con $password";
  
          if($numero_registro!=0) //el usuario existe
          {
              echo "&lt;h2&gt;Adelante!!&lt;/h2&gt;";
  
          }
          else 
          {
              header("location:59sistema_login.php"); //redirigo a la pag login
          }
      }
      catch(Exception $e)
      {
          die("Error: " .$e-&gt;getMessage());
      }
  
  
  ?&gt;
  &lt;/body&gt;
  &lt;/html&gt;
  </code></pre>
  
  <hr>
  
  <p><strong>UPDATE</strong></p>
  
  <p>I create a new file and tried putting this and I print the CONNECTION OK, that means that the connection would be fine (?)</p>
  
  <pre><code>&lt;?php
      try
      { 
           $base = new PDO('oci:dbname=localhost', 'hr','hr'); 
          echo "Conexión OK!";
      } 
      catch (Exception $e) 
      {
          die('Error: ' .$e-&gt;GetMessage());
      }
  
      finally
      {
          $base = null; //vacio la memoria
      }
  ?&gt;
  </code></pre>
  
  <hr>
  
  <p><strong>UPDATE 2</strong></p>
  
  <p>I executed this line of code to see if the drivers are installed correctly.</p>
  
  <pre><code>&lt;?php foreach(PDO::getAvailableDrivers() as $driver)
      echo $driver, '\n';
  ?&gt;
  </code></pre>
  
  <p>It shows: mysql\noci\nsqlite\n</p>