Having some trouble identifying the issue here. It seems quite simple, but I'll highlight it here anyway. On a basic website, I have a form for user registration where I'm using AJAX to send data to register.php. The form and AJAX code are as follows:
<form method="GET">
<h4>Username:</h4>
<input type="text" class="username" placeholder="Username" name="reg-user">
<h4>Choose password:</h4>
<input type="text" class="password" placeholder="Password" name="reg-pass">
<h4>First Name</h4>
<input type="text" class="firstname" placeholder="First Name" name="reg-fn">
<h4>Last Name</h4>
<input type="text" class="lastname" placeholder="Last Name" name="reg-en"><br><br>
<div class="btn btn-success reg-btn">Register</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>User registered.</p>");
}});
})
The information is sent to the PHP file for user registration without any error messages displayed currently:
<?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 = "Username already taken.. ";
}
}
mysqli_close($conn);
?>
However, even though there are no syntax errors visible in the AJAX call execution, nothing seems to happen. Let me know if you see something I've missed. Thank you in advance.
I'm encountering the following errors:
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