After spending three days experimenting with various methods, I'm still unable to successfully use the Javascript ajax command to send form values to a php script. Despite no errors being displayed and the scripts running smoothly, nothing is getting inserted into my database. For the sake of brevity, I've included the HTML in this pastebin for reference.
Below is my php script:
<?php
if($_POST) {
$link = mysqli_connect(localhost, <removed>, <removed>, <removed>);
function val_data($data){
$data = trim($data);
$data = strip_tags($data);
$data = mysqli_real_escape_string($link,$data);
return $data;
}
$type = val_data($_POST['type']);
$size = val_data($_POST['size']);
$date = val_data($_POST['datepicker']);
$message = val_data($_POST['message']);
$steam = val_data($_SESSION['steamid']);
//Query
$sql = "INSERT INTO requests (type, size, fdate, steam64id, message) VALUES ('$type', '$size', '$date', '$steam', '$message')";
$query = mysqli_query($link, $sql);
mysqli_close($link);
}
?>
Here's the corresponding Javascript:
function hideModal() {
$('#myModal').modal('hide');
}
$(document).ready(function() {
$(document).on('submit', '#myModal', function() {
var error = "";
var type = document.getElementById("type").val();
var size = document.getElementById("size").val();
var date = document.getElementById("datepicker").val();
var message = document.getElementById("message").val();
if(type == "") {
error = "A Job type is required";
document.getElementById("sparam").innerHTML = error;
$("type").focus();
return false;
}
if(size == "") {
error = "A Job size is required";
document.getElementById("sparam").innerHTML = error;
$("size").focus();
return false;
}
if(date == "") {
error = "A desired completion date is required";
document.getElementById("sparam").innerHTML = error;
$("date").focus();
return false;
}
if(message == "") {
error = "A description of the job is required";
document.getElementById("sparam").innerHTML = error;
$("message").focus();
return false;
}
$.ajax({
type: 'post',
url: 'ajaxsubmit.php',
data: {
type:type,
size:size,
date:date,
message:message
},
success: function(res) {
$('#sparam').html("Thanks! We'll be in touch soon");
setTimeout(hideModal, 5000);
}
});
return false;
});
});