My app is facing an issue where radio buttons and checkboxes are not correctly entering information into the database. Currently, only text fields are successfully saving data, while checkboxes and radio buttons are only recording the value of the first radio button in the database. This means that even if "No" is selected on the radio button, "Yes" is stored in the DB. I am unsure of what mistake I might be making.
Below are the relevant HTML functions:
function saveUserInfo(userName, userEmail, optedIn, currentUser, catDog, otherBrand)
{
if(optedIn === "Yes")
{
finalAnswers = userName + "yes" + "~" + userEmail + "~" + optedIn + "~" + currentUser + "~" + catDog + "~" + otherBrand + "~";
}else{
finalAnswers = userName + "no" + "~" + userEmail + "~" + optedIn + "~" + currentUser + "~" + catDog + "~" + otherBrand + "~";
// finalAnswers = userName + "~" + userEmail + "~0" + optedIn + "~1" + currentUser + "~2" + catDog + "~3" + otherBrand + "~4";
}
try
{
$.ajax({
url: surveyServer + finalAnswers,
type: 'post',
success: function(evt){
console.log('success saving ' + finalAnswers);
}
});
}
catch(err)
{
alert(err.message);
}
}
function saveUser()
{
$('.wrapper').find("#userEmail").blur();
if (($('#userName').val().length > 0) && ($('#userEmail').val().length > 0))
{
var testEmail = /^[A-Z0-9._%+-]+@([A-Z0-9-]+\.)+[A-Z]{2,4}$/i
var valueToTest = $('#userEmail').val();
if (testEmail.test(valueToTest))
{
//pass
saveUserInfo($('#userName').val(), $('#userEmail').val(), $('#optedIn').val(), $('#currentUser').val(), $('#catDog').val(), $('#otherBrand').val());
$('.wrapper').slick('slickNext');
} else {
// Do whatever if it fails.
alert("Please enter a valid email address.");
$('.wrapper').find("#userEmail").focus();
}
}else{
alert("Please enter your name and email address then click Submit.");
$('.wrapper').find("#userName").focus();
}
}
The following is the surveySurver code snippet:
if (isset($_GET['user']))
{
try
{
$dbh = new PDO('mysql:host=localhost; dbname=bp1234', 'bp1234','bp1234');
$userAnswerArray = explode("~", $_GET['user']);
$stmt = $dbh->prepare("INSERT INTO bpQuiz (userName, userEmail, optedIn, currentUser, catDog, otherBrand) VALUES (:userName, :userEmail, :optedIn, :currentUser, :catDog, :otherBrand)");
$stmt->bindParam(':userName', $userName);
$stmt->bindParam(':userEmail', $userEmail);
$stmt->bindParam(':optedIn', $userOption);
$stmt->bindParam(':currentUser', $currentUser);
$stmt->bindParam(':catDog', $catDog);
$stmt->bindParam(':otherBrand', $otherBrand);
// insert value
$userName = $userAnswerArray[0];
$userEmail = $userAnswerArray[1];
$userOption = $userAnswerArray[2];
$currentUser = $userAnswerArray[3];
$catDog = $userAnswerArray[4];
$otherBrand = $userAnswerArray[5];
$stmt->execute();
}
catch (PDOException $e)
{
echo 'ERROR: ' . $e->getMessage();
}
}
else
{
echo "no querystring...";
}
To add to the context, here are the form input fields:
<input type="text" class="contactFormInputBox" name="userName" id="userName"/>
<input type="text" class="contactFormInputBox" name="userEmail" id="userEmail"/>
<input type="checkbox" name="optedIn" id="optedIn" value="Yes">
<input type="radio" name="currentUser" value="1" id="currentUser">Yes
<input type="radio" name="currentUser" value="0" id="currentUser">No
<input type="radio" name="catDog" value="cat" id="catDog">Cat
<input type="radio" name="catDog" value="dog" id="catDog">Dog
<input type="radio" name="catDog" value="both" id="catDog">Both
</div>
<div class="surveyOptions" id="Q2-b">
<input type="text" class="contactFormInputBox" name="otherBrand" id="otherBrand"/>