Advertisement
Guest User

Untitled

a guest
Oct 23rd, 2016
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.88 KB | None | 0 0
  1. <form method="GET">
  2. <h4>Användarnamn:</h4>
  3. <input type="text" class="username" placeholder="Användarnamn" name="reg-user">
  4. <h4>Välj lösenord:</h4>
  5. <input type="text" class="password" placeholder="Lösenord" name="reg-pass">
  6. <h4>Förnamn</h4>
  7. <input type="text" class="firstname" placeholder="Förnamn" name="reg-fn">
  8. <h4>Efternamn</h4>
  9. <input type="text" class="lastname" placeholder="Efternamn" name="reg-en"><br><br>
  10. <div class="btn btn-success reg-btn">Registrera</div>
  11. </form>
  12. </div>
  13.  
  14. <script type="text/javascript">
  15. $(".reg-btn").click(function(){
  16. var username = $(".username").val();
  17. var password = $(".password").val();
  18. var firstname = $(".firstname").val();
  19. var lastname = $(".lastname").val();
  20.  
  21. //Ajax call
  22. $.ajax({
  23. method:"GET",
  24. url: "php/register.php",
  25. data:{ username: username, password: password, firstname: firstname, lastname: lastname },
  26. success: function(){
  27. $(".username").val("");
  28. $(".password").val("");
  29. $(".firstname").val("");
  30. $(".lastname").val("");
  31. $("#slide-register").prepend("<p>Användare registrerad.</p>");
  32. }});
  33. })
  34.  
  35. <?php
  36. mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
  37. include('connect.php');
  38.  
  39. if(isset($_GET['username']) && isset($_GET['password'])){
  40. $uname = mysqli_real_escape_string($conn, $_GET['username']);
  41. $pword = password_hash(mysqli_real_escape_string($conn, $_GET['password']), PASSWORD_DEFAULT);
  42. $fname = mysqli_real_escape_string($conn,$_GET['firstname']);
  43. $lname = mysqli_real_escape_string($conn,$_GET['lastname']);
  44.  
  45. $username = trim($uname);
  46. $password = trim($pword);
  47. $firstname = trim($fname);
  48. $lastname = trim($lname);
  49. $admin = "0";
  50.  
  51. $query = "SELECT username FROM users WHERE username ='$username'";
  52. $result = mysqli_query($conn, $query);
  53.  
  54. $count = mysqli_num_rows($result);
  55.  
  56. if($count == 0){
  57. $stmt = mysqli_prepare($conn, "INSERT INTO users (username, password, firstname, lastname, admin) VALUES (?, ?, ?, ?, ?)");
  58. mysqli_stmt_bind_param($stmt, "sss", $username, $password, $firstname, $lastname, $admin);
  59. mysqli_stmt_execute($stmt);
  60. }
  61. else {
  62. $msg = "Användarnamn upptaget.. ";
  63. }
  64. }
  65. mysqli_close($conn);
  66. ?>
  67.  
  68. Warning: mysqli_stmt_bind_param(): Number of elements in type definition string doesn't match number of bind variables in /customers/5/0/5/xxxxxx/php/register.php on line 24
  69.  
  70. Fatal error: Uncaught mysqli_sql_exception: No data supplied for parameters in prepared statement in /customers/5/0/5/xxxxx/php/register.php:25
  71. Stack trace:
  72. #0 /customers/5/0/5/xxxxx/php/register.php(25): mysqli_stmt_execute(Object(mysqli_stmt))
  73. #1 {main}
  74. thrown in /customers/5/0/5/xxxxxxx/php/register.php on line 25
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement