Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <form method="GET">
- <h4>Användarnamn:</h4>
- <input type="text" class="username" placeholder="Användarnamn" name="reg-user">
- <h4>Välj lösenord:</h4>
- <input type="text" class="password" placeholder="Lösenord" name="reg-pass">
- <h4>Förnamn</h4>
- <input type="text" class="firstname" placeholder="Förnamn" name="reg-fn">
- <h4>Efternamn</h4>
- <input type="text" class="lastname" placeholder="Efternamn" name="reg-en"><br><br>
- <div class="btn btn-success reg-btn">Registrera</div>
- </form>
- </div>
- <script type="text/javascript">
- $(".reg-btn").click(function(){
- var username = $(".username").val();
- var password = $(".password").val();
- var firstname = $(".firstname").val();
- var lastname = $(".lastname").val();
- //Ajax call
- $.ajax({
- method:"GET",
- url: "php/register.php",
- data:{ username: username, password: password, firstname: firstname, lastname: lastname },
- success: function(){
- $(".username").val("");
- $(".password").val("");
- $(".firstname").val("");
- $(".lastname").val("");
- $("#slide-register").prepend("<p>Användare registrerad.</p>");
- }});
- })
- <?php
- mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
- include('connect.php');
- if(isset($_GET['username']) && isset($_GET['password'])){
- $uname = mysqli_real_escape_string($conn, $_GET['username']);
- $pword = password_hash(mysqli_real_escape_string($conn, $_GET['password']), PASSWORD_DEFAULT);
- $fname = mysqli_real_escape_string($conn,$_GET['firstname']);
- $lname = mysqli_real_escape_string($conn,$_GET['lastname']);
- $username = trim($uname);
- $password = trim($pword);
- $firstname = trim($fname);
- $lastname = trim($lname);
- $admin = "0";
- $query = "SELECT username FROM users WHERE username ='$username'";
- $result = mysqli_query($conn, $query);
- $count = mysqli_num_rows($result);
- if($count == 0){
- $stmt = mysqli_prepare($conn, "INSERT INTO users (username, password, firstname, lastname, admin) VALUES (?, ?, ?, ?, ?)");
- mysqli_stmt_bind_param($stmt, "sss", $username, $password, $firstname, $lastname, $admin);
- mysqli_stmt_execute($stmt);
- }
- else {
- $msg = "Användarnamn upptaget.. ";
- }
- }
- mysqli_close($conn);
- ?>
- 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
- Fatal error: Uncaught mysqli_sql_exception: No data supplied for parameters in prepared statement in /customers/5/0/5/xxxxx/php/register.php:25
- Stack trace:
- #0 /customers/5/0/5/xxxxx/php/register.php(25): mysqli_stmt_execute(Object(mysqli_stmt))
- #1 {main}
- thrown in /customers/5/0/5/xxxxxxx/php/register.php on line 25
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement