Guest User

Untitled

a guest
Jun 7th, 2018
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.39 KB | None | 0 0
  1. string password_hash ( string $password , integer $algo [, array $options ] )
  2.  
  3. $check = mysql_query("SELECT `id` FROM `database`.`user`
  4. WHERE `password` = '".$password."'") or die(mysql_error());
  5.  
  6. $insert = mysql_query("INSERT INTO `database`.`user`(`username`,`password`,`email`)
  7. VALUES ('".$username."','".$password."','".$email."')") or die(mysql_error());
  8.  
  9. $update = mysql_query("UPDATE `database`.`user` SET `password` = '".$newpassword."'
  10. WHERE `password` = '".$oldpassword."'") or die(mysql_error());
  11.  
  12. $username = mysql_real_escape_string($_POST['username']);
  13. $password = mysql_real_escape_string($_POST['password']);
  14. $email = mysql_real_escape_string($_POST['email']);
  15.  
  16. $mysqli = new mysqli( 'enderecodoservidor', 'usuario', 'senha', 'basededados' );
  17.  
  18. $usuario = $_POST['usuario'];
  19. $hash = password_hash( $_POST['senha'], PASSWORD_DEFAULT );
  20.  
  21. $query = 'INSERT INTO usuarios ( nome, hash) VALUES ( ?, ? )';
  22. $stmt = $mysqli->prepare( $query );
  23. $stmt->bind_param("ss", $usuario, $hash );
  24. $stmt->execute();
  25.  
  26. $mysqli = new mysqli( 'enderecodoservidor', 'usuario', 'senha', 'basededados' );
  27.  
  28. $usuario = $_session['usuario']; // ou idusuario, depende como voce mantem o login
  29. $hash = password_hash( $_POST['novaSenha'], PASSWORD_DEFAULT );
  30.  
  31. $query = 'UPDATE usuarios SET hash= ? WHERE nome = ? '; // ou WHERE id = ?
  32. $stmt = $mysqli->prepare( $query );
  33. $stmt->bind_param("ss", $hash , $usuario ); // ou ("si", $hash, $idUsuario)
  34. $stmt->execute();
  35.  
  36. $mysqli = new mysqli( 'enderecodoservidor', 'usuario', 'senha', 'basededados' );
  37.  
  38. $usuario = $_POST['usuario'];
  39. $idUsuario = 0;
  40.  
  41. $query = 'SELECT id, hash FROM usuarios WHERE nome = ?';
  42. $stmt = $mysqli->prepare( $query );
  43. $stmt->bind_param("ss", $usuario );
  44. $stmt->execute();
  45.  
  46. $stmt->bind_result( $idUsuario, $hash );
  47. $stmt->fetch();
  48.  
  49. if ( password_verify( $_POST['senha'], $hash );
  50.  
  51. $password = password_hash($password);
  52. $check = mysql_query("SELECT `id` FROM `database`.`user`
  53. WHERE `password` = '".$password."'") or die(mysql_error());
  54.  
  55. $password = password_hash($password);
  56. $insert = mysql_query("INSERT INTO `database`.`user`(`username`,`password`,`email`)
  57. VALUES ('".$username."','".$password."','".$email."')") or die(mysql_error());
  58.  
  59. $password = password_hash($password);
  60. $oldpassword = password_hash($oldpassword);
  61. $update = mysql_query("UPDATE `database`.`user` SET `password` = '".$newpassword."'
  62. WHERE `password` = '".$oldpassword."'") or die(mysql_error());
Add Comment
Please, Sign In to add comment