Advertisement
Guest User

Untitled

a guest
Mar 24th, 2017
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. <?php
  2.  
  3. $user = "postgres";
  4. $password = "iapem";
  5. $dbname = "db_sistema_a";
  6. $port = "5432";
  7. $host = "localhost";
  8.  
  9. $cadenaConexion = "host=$host port=$port dbname=$dbname user=$user password=$password";
  10.  
  11. $conexion = pg_connect($cadenaConexion);
  12.  
  13. if(!($conexion)){
  14.  
  15. die('No pudo conectarse: ' .pg_last_error());
  16.  
  17. }
  18.  
  19.  
  20. $usuario = $_POST["usr"];//Traemos los datos del formulario
  21. $clave1 = $_POST["clave"];//Traemos los datos del formulario
  22.  
  23. $clave2 = md5($clave1);//Encriptamos la clave a md5
  24.  
  25. $query = "select * from usuarios WHERE ced='$usuario' and psswd_per='$clave2'";//Realizamos query
  26.  
  27. $result = pg_query($conexion, $query) or die("Error en la Consulta SQL");//Procesamos el query
  28.  
  29. $numReg= pg_num_rows($result);
  30.  
  31. echo $numReg . " rows returned";//Me dice si hay alguien en la base de datos
  32.  
  33. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement