I have made a form where I submit new employee data to the database using jquery ajax and php. The data gets submitted and appears in the database, but how do I get it so the data will display on my page without the page refreshing?
I want the data to appear on the page without the page refreshing.
My problem: I can submit the data, but the page refreshes. If I make it so the page doesn't refresh, it won't submit the data.
function createNewEmployee(){
require ('connection.php');
$first = $_POST['first'];
$last = $_POST['last'];
$sin = $_POST['sin'];
$pwd = $_POST['pwd'];
$sql = "INSERT INTO employee (firstname, lastname, sin_, pass_) VALUES ('$first', '$last', '$sin', '$pwd');";
mysqli_query($conn, $sql);
}
<form id="addform" action="addemployee.php" method="POST">
<p>Add New Employee:<p>
<input type="text" name="first" placeholder="First Name">
<br>
<input type="text" name="last" placeholder="Last Name">
<br>
<input type="text" name="sin" placeholder="SIN Number">
<br>
<input type="password" name="pwd" placeholder="Password">
<br>
<button type="button" id="submitbtn">Add</button>
$(document).ready(function() {
$("#submitbtn").click(function() {
var first = $("#name").val();
var last = $("#last").val();
var sin = $("#sin").val();
var pwd = $("pwd").val();
$.ajax({
type: "POST",
data: {first:first,last:last,sin:sin,pwd:pwd},
url: "addemployee.php",
success: function(result) {
$("#resultadd").html(response);
}
});
});
});