a slight problem with form using JQuery, PHP, MySQL
I have a form which is using HTML, JQuery, PHP and MySQL to submit data from a web-page into back-end database. One of the form fields (editor_name) just comes through as 'undefined' in the database. I am using PHP to store this field in a SESSION after using SQL to extract from the database. The session variable seems to be holding, but not getting entered into the database. I think this is a JQuery problem because of this. Note that I am not using editor_name as an input ID, but I do want this to be entered into the database. I added it to the JQuery b/c It wouldn't work without adding the var editor_name part. I wasn't how sure to do it as a SESSION var in the JQuery. Hope all this makes sense!
- $(function() {
$('.error').hide();
$(".button").click(function() {
// validate and process form
// first hide any error messages
$('.error').hide();
var editor_name = $("input#editor_name").val();
var Answer1 = $("textarea#Answer1").val();
if (Answer1 == "") {
$("label#Q1_error").show();
$("textarea#Answer1").focus();
return false;
}
var Answer2 = $("textarea#Answer2").val();
if (Answer2 == "") {
$("label#Q2_error").show();
$("textarea#Answer2").focus();
return false;
}
var Answer3 = $("textarea#Answer3").val();
if (Answer3 == "") {
$("label#Q3_error").show();
$("textarea#Answer3").focus();
return false;
}
var Answer4 = $("textarea#Answer4").val();
if (Answer4 == "") {
$("label#Q4_error").show();
$("textarea#Answer4").focus();
return false;
}
var Answer5 = $("textarea#Answer5").val();
if (Answer5 == "") {
$("label#Q5_error").show();
$("textarea#Answer5").focus();
return false;
}
var Answer6 = $("textarea#Answer6").val();
if (Answer6 == "") {
$("label#Q6_error").show();
$("textarea#Answer6").focus();
return false;
}
var Answer7 = $("textarea#Answer7").val();
if (Answer7 == "") {
$("label#Q7_error").show();
$("textarea#Answer7").focus();
return false;
}
var Answer8 = $("textarea#Answer8").val();
if (Answer8 == "") {
$("label#Q8_error").show();
$("textarea#Answer8").focus();
return false;
}
var Answer9 = $("textarea#Answer9").val();
if (Answer9 == "") {
$("label#Q9_error").show();
$("textarea#Answer9").focus();
return false;
}
var Answer10 = $("textarea#Answer10").val();
if (Answer10 == "") {
$("label#Q10_error").show();
$("textarea#Answer10").focus();
return false;
}
var Answer11 = $("textarea#Answer11").val();
if (Answer11 == "") {
$("label#Q11_error").show();
$("textarea#Answer11").focus();
return false;
}
var Answer12 = $("textarea#Answer12").val();
if (Answer12 == "") {
$("label#Q12_error").show();
$("textarea#Answer12").focus();
return false;
}
var dataString = 'editor_name='+ editor_name+ '&Answer1='+ Answer1 + '&Answer2=' + Answer2 + '&Answer3=' + Answer3 + '&Answer4=' + Answer4 + '&Answer5=' + Answer5 + '&Answer6=' + Answer6 + '&Answer7=' + Answer7 + '&Answer8=' + Answer8 + '&Answer9=' + Answer9 + '&Answer10=' + Answer10 + '&Answer11=' + Answer11 + '&Answer12=' + Answer12;
$.ajax({
type: "POST",
url: "bin/process.php",
data: dataString,
success: function() {
$('#contact_form').html("<div id='message'></div>");
$('#message').html("<h2>Your answers were successfully submitted!</h2>")
.append("<p>We will be in touch.</p>")
.hide()
.fadeIn(1500, function() {
$('#message').append("<img id='checkmark' src='images/check.png' />");
});
}
});
return false;
});
});
runOnLoad(function(){
$("textarea#Q1").select().focus();
});