Advertisement
Guest User

Untitled

a guest
Oct 22nd, 2016
143
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.03 KB | None | 0 0
  1. function loguearDocente($user, $pass)
  2. {
  3. global $conexion;
  4. //$user = mysqli_real_escape_string($conexion, $_POST['user']);
  5. //$pass = mysqli_real_escape_string($conexion, $_POST['pass']);
  6.  
  7. $sql = "SELECT * FROM users_profesores WHERE (User='".$user."' OR EMail='$user') AND Passwd='".$pass."'";
  8. $resultado=mysqli_query($conexion, $sql); //error
  9. $fila=mysqli_fetch_array($resultado,MYSQLI_ASSOC); //error
  10. $conta = mysqli_num_rows($resultado); // error
  11.  
  12. if ( $pass == $fila["Passwd"] ) {
  13. //if ( $pass == $fila ["Passwd"] )
  14. $sql2 = "SELECT User FROM users_profesores WHERE (User='".$user."' OR EMail='$user') AND Passwd='".$pass."'";
  15. $result = mysqli_query($conexion, $sql2);
  16. $num_row = mysqli_num_rows($result);
  17.  
  18. if ($num_row == "1") {
  19. $data = mysqli_fetch_array($result); // Obtiene una fila de resultados como un array asociativo, numérico, o ambos
  20. session_start();
  21. $_SESSION["user"] = $data["User"];
  22. echo "1";
  23. } else { //fin if num_row
  24. echo "no se encuentra registro";
  25. }
  26. } else { //fin if pass = passDB
  27. echo "passwds no coinciden";
  28. }
  29.  
  30. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement