Advertisement
Guest User

Work Username Update

a guest
Oct 13th, 2016
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.36 KB | None | 0 0
  1. <?php
  2. session_start();
  3. $pdo = new PDO('mysql:host=localhost;dbname=zocker-ka', 'zocker-ka', 'IbdN1hahaha');
  4.  
  5. if(isset($_GET['updatename'])) {
  6.   mysql_connect("localhost","","");
  7.   mysql_select_db("");
  8.  
  9. $email = $_POST['email'];
  10. $passwort = $_POST['passwort'];
  11. $name = $_POST['name'];
  12.  
  13.   $verbot = mysql_query("SELECT verbot FROM verboten");
  14.   while($row = mysql_fetch_assoc($verbot)) {
  15. if(strpos($name, $row['verbot'])!==false) {
  16. die('Dieser Beitrag ist nicht erlaubt');
  17.   }
  18.   }
  19.  
  20. $statement = $pdo->prepare("SELECT * FROM users WHERE email = :email");
  21.     $result = $statement->execute(array('email' => $email));
  22.     $user = $statement->fetch();
  23.     if ($user !== false && password_verify($passwort, $user['passwort'])) {
  24.         $_SESSION['userid'] = $user['id'];
  25.  
  26. $statement = $pdo->prepare("UPDATE users SET name = :name WHERE email = :email");
  27. $result = $statement->execute(array('name' => $name, 'email' => $email));
  28. ?>
  29. <script>alert("erfolgreich gesendet");</script>
  30. <?php
  31. }
  32. else {
  33.         $errorMessage = "E-Mail oder Passwort war ungültig<br>";
  34.     }
  35. }
  36. if(isset($errorMessage)) {
  37.     ?>
  38.     <script>alert("Bitte überprüfen sie ihre Daten nochmal, es ist ein Fehler aufgetreten.")</script>
  39.     <?php
  40. }
  41. ?>
  42.  <html>
  43.     <head>
  44.     <link href="/css/standart.css" rel="stylesheet">
  45.     <title>Userbereich</title>
  46.      </head>
  47.      <body>
  48.      <nav>
  49. <ul>
  50. <li><a href="/">Home</a></li>
  51. <li><a href="/login">Login</a>
  52. <ul>
  53. <li><a href="/login/login.php">Log In</a></li>
  54. <li><a href="/login/registrieren.php">Registrieren</a></li>
  55. <li><a href="/login/logout.php">Log Out</a></li>
  56. </ul>
  57. </li>
  58. <li><a href="/login/geheim.php">aktuelle Seite</a></li>
  59. <li><a href="/newsletter">Newsletter</a></li>
  60. <li><a href="/fragen">Frage stellen</a></li>
  61. <li><a href="/admin_area">Admin Area</a></li>
  62. <li><a href="/userlist">Userlist</a></li>
  63. <li><a href="/forum">Forum</a></li>
  64. </ul>
  65. </nav>
  66. <br /><br /><br /><br /><br /><br />
  67.      <h1> Hallo</h1>
  68.      <h2>Username ändern:<br />
  69.      <form action="?updatename=1" method="post">
  70.      E-Mail:<br />
  71.      <input type="email" name="email" maxlength="40" size="40" /><br />
  72.      Neuer Name:<br />
  73.      <input type="text" name="name" maxlength="20" size="40" /><br />
  74.      Passwort:<br />
  75.      <input type="password" name="passwort" maxlength="250" size="40" /><br />
  76.      <input type="submit" name="ändern" value="ändern" />
  77.      </form>
  78.      </h2>
  79.      </body>
  80. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement