Advertisement
Guest User

Untitled

a guest
Aug 3rd, 2016
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. $servername = "YOUR_SERVER";
  2. $username = "YOUR_USERNAME";
  3. $password = "YOUR_PASSWORD";
  4. $dbname = "YOUR_DB";
  5.  
  6. // Create connection
  7. $conn = new mysqli($servername, $username, $password, $dbname);
  8. // Check connection
  9. if ($conn->connect_error) {
  10. die("Connection failed: " . $conn->connect_error);
  11. }
  12.  
  13. $sql = "SELECT id, password FROM your_table";
  14. $result = $conn->query($sql);
  15.  
  16. $newPasswords = [];
  17.  
  18. if ($result->num_rows > 0) {
  19. // output data of each row
  20. while($row = $result->fetch_assoc()) {
  21. $newPasswords[] = ["id" => $row["id"], "newPass" = "YOUR_PASSWORD_ENCRYPTED_WITH_BCRYPY"];
  22. }
  23. } else {
  24. echo "0 results";
  25. }
  26.  
  27. foreach($newPasswords as $user) {
  28. $sql = "UPDATE your_table SET password = $user["newPass"] WHERE id = $user["id"]";
  29. $result = $conn->query($sql);
  30. }
  31.  
  32. $conn->close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement