i'm trying to create a registration form for users
to register on our site? basically i've created this script
now i've been getting alot of help from a friend of mine(OpenAi.com)
i've tested the form and the form information isn't going into my database(phpmyadmin)
i have setup tables for each column but don't know what's going on
i have html here as well
could someone please tell me where i'm going wrong?
i'v obviously set in the php code as my username ect but i have the rite
database credentials
to register on our site? basically i've created this script
Code:
<?php
// Check if the form was submitted
if ($_SERVER["REQUEST_METHOD"] == "POST") {
// Get form data and sanitize inputs
$yourname = filter_input(INPUT_POST, "yourname", FILTER_SANITIZE_STRING);
$lastname = filter_input(INPUT_POST, "lastname", FILTER_SANITIZE_STRING);
$username = filter_input(INPUT_POST, "username", FILTER_SANITIZE_STRING);
$email = filter_input(INPUT_POST, "email", FILTER_SANITIZE_EMAIL);
$password = $_POST["password"];
// Validate inputs
if (empty($yourname) || empty($lastname) || empty($username) || empty($email) || empty($password)) {
echo "Please fill in all fields.";
} else {
// Hash the password (ensure you have proper hashing and salting)
$hashedPassword = password_hash($password, PASSWORD_DEFAULT);
// Database connection settings
$servername = "my_server_name"; // Replace with your actual server name
$connection_username = "my_username"; // Replace with your actual database username
$connection_password = "my_password"; // Replace with your actual database password
$dbname = "my_database_name"; // Replace with your actual database name
// Create connection
$conn = new mysqli($servername, $connection_username, $connection_password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// Prepare and bind the SQL statement to prevent SQL injection
$stmt = $conn->prepare("INSERT INTO users (yourname, lastname, username, email, password) VALUES (?, ?, ?, ?, ?)");
$stmt->bind_param("sssss", $yourname, $lastname, $username, $email, $hashedPassword);
if ($stmt->execute()) {
echo "Registration successful!";
} else {
echo "Error: " . $stmt->error;
}
// Close the connection
$stmt->close();
$conn->close();
}
}
?>now i've been getting alot of help from a friend of mine(OpenAi.com)
i've tested the form and the form information isn't going into my database(phpmyadmin)
i have setup tables for each column but don't know what's going on
i have html here as well
Code:
<!DOCTYPE html>
<html>
<head>
<title>Registration Form</title>
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
</head>
<body>
<h4>
<span class="boldp_line"><span></span></span>
<span class="solid_line"></span>
<a href="#" class="title_text">Register</a>
</h4>
<form id="registrationForm" method="post">
yourname: <input type="text" name="yourname"><br>
lastname: <input type="text" name="lastname"><br>
username: <input type="text" name="username"><br>
email: <input type="email" name="email"><br>
password: <input type="password" name="password"><br>
<input type="submit" value="Register">
</form>
<div id="responseMessage"></div>
<script>
$(document).ready(function() {
$("#registrationForm").submit(function(event) {
event.preventDefault();
$.ajax({
url: "form.php", // Update this to match the correct PHP script filename
method: "POST",
data: $(this).serialize(),
success: function(response) {
$("#responseMessage").html(response);
}
});
});
});
</script>
</body>
</html>could someone please tell me where i'm going wrong?
i'v obviously set in the php code as my username ect but i have the rite
database credentials
